How to open a Template under a different name, preferably the dat

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I want to open an excelworkbook from a template, this works fine by just
opening the template.
But when opening an excelworkbook generated by the template.
It names the file, and adds a 1 to the filename.
Example --> (action)open template named book1.xlt It opens a excelworkbook
named book11.xls.

What i want is that, when you open the template it names it with the time
and date as filename for the excelworkbook.
So that everytime you open the template you can save your copy of the
workbook under the time and date when the file was opened.
I know this is possible, because i've seen this done.. But I can't figure
out how to do it myself. It should be possible within excel, otherwise i
would be forces to use a macro.. but i rather don't want to use this option.

Please help,

Barry
 
Most likely, a macro is used to save your file at the moment. You will have
to modify this macro to save it as per your requirements? Press <Alt><F11>
to go to VBA, then doubleclick on Modules under the xlt filename, then
doubleclick Module 1. You can then read the macro's, and you will soon se
where the additional 1 is coming from. That would be the starting point.
 
Back
Top