Copy a file remotely

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi,

I want to copy a file from one folder to another in VBA. Normally I would
open the file and then use savesas, but the file is a csv and you cannot open
in excel.

So is there a way to just copy the file?

Thanks
 
Look at FileCopy in VBA's help.

And if you wanted to move the file, look at Name in VBA's help.
 
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

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
csv files 1
how to link ot a data in a csv file? 3
Excel CSV Files; Creating Of 3
CSV Copy 1
XLT vs XLS 8
Remove All VBA 8

Back
Top