Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and paste over existing file?
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.programming
|
|||
|
|||
Copy and paste over existing file?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste over existing files | Excel Discussion (Misc queries) | |||
how do I copy an existing file to a flash drive | Excel Discussion (Misc queries) | |||
After Copy and Paste, Add to an Existing Named Range | Excel Programming | |||
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
copy and paste table in another existing worksheet | Excel Programming |