Create New Excel Workbook from Template VBA?

[Dogers]

I'm looking for a function that will allow (in our instance) Access to create a new excel workbook from a template. Currently our system opens a template, makes the changes then saves it out but with an xls extension - its still a template, not a proper document!

Can this be done?

 

[xlbo]

Have a look at the FILEFORMAT argument of the SAVEAS method

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question