Copying file

  • Thread starter Thread starter John
  • Start date Start date
Hi

How can I copy a file to a path via vba?

Thanks

Regards
Click to expand...


Hi.

You can use the "FileCopy" statement

Syntax: FileCopy strSource, strDestination

strSource = string with full path and file name
strDestination = string of destination folder

Make sure you check the file you are copying is closed, if you try to
use the FileCopy statement on a currently open file, an error occurs.


HTH
AndyC
 
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

performance problem with FileCopy on usb key 1
Access Print Files from Query Results 0
How do you Highlight a file name and copy the path and name to avariable using VBA? 4
Discover folder path 1
Copy Excel files from local system to SharePoint 1
Copying a linked table 3
Windows XP error copying file or folder 3
vba powerpoint pasting named shape in selected named slides 0

Back
Top