I have an Excel template (.xlt) which I have distributed to various users. They periodically need to update their individual template then use it to create individual files from.
I have a desktop shortcut to the template set up on each user's computer. This opens a copy of the template (ie. a standard .xls) to work on individual files from their template.
At present, when they need to make changes to their template (.xlt), I have to tell them to open Excel, file, open, locate the file and open it. This opens the .xlt as it is opened from within Excel.
I was wondering if thee was a way to open the .xlt from the desktop (maybe using some sort of code?) using another shortcut as this will be a much simpler process and leads to less errors in the 2 open methods - as long as it is clear which shortcut opens the template and which one opens a new file created from the template.
Hope this makes sense and thanks for any help.
I have a desktop shortcut to the template set up on each user's computer. This opens a copy of the template (ie. a standard .xls) to work on individual files from their template.
At present, when they need to make changes to their template (.xlt), I have to tell them to open Excel, file, open, locate the file and open it. This opens the .xlt as it is opened from within Excel.
I was wondering if thee was a way to open the .xlt from the desktop (maybe using some sort of code?) using another shortcut as this will be a much simpler process and leads to less errors in the 2 open methods - as long as it is clear which shortcut opens the template and which one opens a new file created from the template.
Hope this makes sense and thanks for any help.