Using spreadsheet as template

**Jakes** · 01-25-2012, 10:38 AM

Hi there,

I have a template spreadsheet, named Template.xls, Which will always be saved at a specific location (C:\Drawing Issue Manager\template.xls )

I need a macro that , when having a spreadsheet derived from that template, when clicking a macro in the derived spreadsheet, it will create a copy of the C:\Drawing Issue Manager\template.xls ( not the derived spreadsheet), and save it at the desired location.

is that possible?

Cheers, Jakes

**smuzoen** · 01-25-2012, 11:32 AM

You could use the following to browse to a directory save location - I have added the current date to the filename so that way the template is not overwritten and the file saved is a unique name - you could append it with something else or remove the date part - it is up to you. You say it is a template file with xls extension however I am unsure if you are using Excel 2003 or 2007

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The template file if you are using Excel 2007 will need to be a macro enabled workbook so will need an xlsm extension. The code will not save the macro in the saved file.

Hope this helps
Anthony

“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s)

**Jakes** · 01-26-2012, 01:43 AM

Thank you very much, will try that, and mark it as solved if this is working fine!

**andcha** · 01-26-2012, 06:32 AM

Hi Anthony,
My requirement is similar to Jakes, it's just that I want to save a macro enabled template in macro format (excel 2010).
I tried changing the above code with what little knowledge I have of macros, In fact I was trying to hit it with a fluke, and this is what I got.

Please Login or Register  to view this content.

It works only till the "save as" screen and once I press save, it shows error "Runtime error '1004'. This extension cannot be used with selected file type and so on..
Also, with the original code, if I cancel save after the "save as" dialog box appears, it still saves false.xlsx file in the folder. A little help here would be much appreciated.

Anand

**royUK** · 01-26-2012, 09:58 AM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**royUK** · 01-26-2012, 09:58 AM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

**andcha** · 01-26-2012, 11:43 AM

Alright no problem, I will start a new thread, Thanks

Btw, even double posts are not allowed..

Just kidding.. LOL, I understand, it was unintentional.

Anand