Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy Template Excel File and Populate it

Status
Not open for further replies.

balderdash

Programmer
Mar 9, 2004
5
GB
All,

I have a template excel file that I need to create a copy of, and then open and populate the relevant tab with the relevant data from an Access 2002 database. I am happy with the opening of a file and populating it, however, I can not find sufficient information on copying the template file before the process starts.

Any help anyone can offer would be greatly received.

Thanx

Balderdash
 
If you are automating excel and have the file open in an excel object, couldn't you just do a...

objExcel.Workbooks(1).SaveAs "NewName
 
Use the Workbooks.Add method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top