| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to copy and paste over existing files
Hello,
I have several Excel files that I update (refresh) the data on my C:\ drive (much faster refreshing time). Then, I would have to copy all these files and paste over the existing files (same file name) in a network drive. Is there a way in macro to automate this process? I remembered back in the DOS days, you can create a bat file to perform this function. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use macros to copy and paste from 1 file to several files | Excel Worksheet Functions | |||
| copy&paste 28 individual files into one file/28 work sheets | Excel Worksheet Functions | |||
| Macro 4 copy & paste between 2 books/files | Excel Discussion (Misc queries) | |||
| Copy and Paste Between Files | Excel Discussion (Misc queries) | |||
| cannot copy newly created files to backup, all existing ok | Excel Discussion (Misc queries) | |||
Threaded Mode
