| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro to copy and paste over existing files
Googled shell bat excel and got 'Excel run batch file from macro' (http://www.mrexcel.com/archive/VBA/3600b.html) If your .Bat file skills are intact, it might be a starting place... -- jamescox ------------------------------------------------------------------------ jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111364 |
| Reply |
| 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) | |||
Linear Mode
