Open Excel Template and Save

[JC2710]

Hi

I currently have a button which when clicked I want to open an excel template and then have the user name the file and save it.

I have managed to open file but not sure how to save. Whether to use SaveAs and how to rename it.

Im sure there is some basic code out there which will do this.

Any ideas?

Thanks

 

[Andrew Poulsom]

You can open a copy of a template like this:

Workbooks.Add Template:= "C:\MyTemplate.xlt"

Excel will automatically change the filename to eg MyTemplate1.xls.

 

[JC2710]

OK thanks! Thats Great!