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

C

Cam

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
 
J

Jen

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
 

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

excel 2010 opens blank from network drive 0
Copy and paste over existing file? 1
Task Scheduler or VBA to simple copy periodically folders contents toexternal drive 1
Synchronization problems while moving folders to new email 1
Refresh Macro to run each day? 2
Copy range from multiple files in multiple folders to single sheet in master WB 10
Refresh Bloomberg data in an excel file from a script 4
Macro to copy files from Folders/Subfolders 3

Top