Excelnoobster
New Member
- Joined
- Sep 4, 2007
- Messages
- 18
Hi Gang,
I have a template called template.xtl. When I open this directly from say my documents it will open as template1.xtl and after i have made changes i click the save button and the save as will appear with .xls preselcted and i can go ahead and save it wherever.
My problem is that I have a marco set up which opens template.xtl and pastes some information in. However when the macro opens it it doesn't open it as as template1.xtl, only without the 1, then when i hit save it has template preselcted rather than workbook.
This is a bit of a pain as other people use it and if they're not concerntrating and forget to change to xls will overwrite the the original.
Can anyone shed any light on how to get this working as it should.
Thanks in advance!
I have a template called template.xtl. When I open this directly from say my documents it will open as template1.xtl and after i have made changes i click the save button and the save as will appear with .xls preselcted and i can go ahead and save it wherever.
My problem is that I have a marco set up which opens template.xtl and pastes some information in. However when the macro opens it it doesn't open it as as template1.xtl, only without the 1, then when i hit save it has template preselcted rather than workbook.
This is a bit of a pain as other people use it and if they're not concerntrating and forget to change to xls will overwrite the the original.
Can anyone shed any light on how to get this working as it should.
Thanks in advance!