Moving Excel files within Access

[garyholc]

Hi

I have 4 complex Excel files which I am using as a template. I have a database in Access which, when a new record is created, makes a new folder using a set naming convention.

The Excel files are too complex to recreate in Access, so I wondered if it was possible within Access to tell Access where the 4 Excel template files are, and get Access to make a copy of the four files in the new folder location.

Is there a copy, paste functionality within Access for this purpose?

Thanks
Gary

 

[namliam]

Try the access help some time... I (sometimes) proves helpfull...

Filecopy "source", "destination"

 

[garyholc]

Yeah that worked, thankya kindly