VBA code to copy multiple Excel files from C drive to network driv
 

Hello,

I have several Excel files reside on my C drive (faster refresh) that I
refreshed the data/chart daily, then copy the files to a network drive
overdriving existing files.

Opening each Excel files (10 files) to refresh the data, then copy to a
network drive is very time consuming, can you please help automate the
process?
Something like refresh all files in a folder (c drive), then copy and paste
over existing files on the a network folder. THanks

VBA code to copy multiple Excel files from C drive to networkdriv
 

How about something like this, in pseudo code:

1. get a list of filenames using FileSystemObject
2. open each file using Application.Workbooks.Open and .Save. This
should refresh the contents.
3. copy each file to the new folder using FileCopy utility.

HTH, Jenn