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

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