Macro to copy and paste over existing files

C

Cam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste over existing file? 1
Change a great number of words in word files, with a macro as short as possible. 5
Macro to copy table of contents to a new doc 0
Visio shape text disappears upon copy paste 1
New computer, how do i move outlook 365 ENTIRELY? 0
VBA code to copy multiple Excel files from C drive to network driv 1
Synchronization problems while moving folders to new email 1
Embedded Excel into Word with Tables 0

Top