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

in Excel's VBA editor, set a Reference (menu: Tools/References...) to the
Microsoft Scripting Runtime DLL and add this code to a new module

Sub MoveFiles()
Application.DisplayAlerts=False
With New FileSystemObject
.MoveFolder "{source folder}", "{target folder}"
End With
Application.DisplayAlerts=True
End Sub

"Cam" <(E-Mail Removed)> wrote in message
news:EAB1C140-38B8-4350-B1AE-(E-Mail Removed)...
> 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