Open and Save an Excel File

  • Thread starter Thread starter John
  • Start date Start date
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
 
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?
 
Back
Top