| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![Jen[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
