Open and Save an Excel File

J

John

using Access 2000

I have a button on my form that allows me to open C:\My
Documents\MyExcelTemplate.xlt file.

My question . . how can my access application automatically save the
template file as C:\My Documents\MyNewFile.xls
 
B

Bill

Do you want to make changes to the template or just write it to another file
name? When you say that you can open it are you saying that you are opening
it as an Excel workbook?
 
Top