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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Can't delete file 3
Excell 2021 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel XP: File name in Title Bar not changed after Save As... 9
Row Count and Save as... in a macro 3
Pass control name to Word 1
Create and Open Word Document From Access & asociate with 2 Fields 3

Back
Top