How do I copy a file in VBA?

[M Skabialka]

I am exporting data from Access to Excel, and want to use a template called
Dallas-xxx.xls for the data.
I would like to copy that template to Dallas-123.xls then fill that
spreadsheet to preserve my template.

How do I do the copy-paste in Access 2007 VBA?

 

[Daniel Pineault]

See http://www.devhut.net/index.php?lang=en&pid=0000000027#CopyFile
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Arvin Meyer [MVP]]

I am exporting data from Access to Excel, and want to use a template called
Dallas-xxx.xls for the data.
I would like to copy that template to Dallas-123.xls then fill that
spreadsheet to preserve my template.

How do I do the copy-paste in Access 2007 VBA?

To copy a file use FileCopy in your code:

FileCopy sourcefile, destinationfile

Here's a sample of copying a recordset to a specific Excel file:

http://www.mvps.org/access/modules/mdl0035.htm

 

[M Skabialka]

Sometimes it's much easier than I expected - thanks!
Mich