Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Excel Files on Network Drive | New Users to Excel | |||
Save to Network Drive Problems. Expanding Current code | Excel Programming | |||
Saving to network drive gives unwanted copy or overwrite message | Excel Discussion (Misc queries) | |||
Automatically save a copy of worksheet from C: to Network Drive | Excel Discussion (Misc queries) | |||
Userform Local Drive & Network drive question | Excel Programming |