Macro to copy and paste source file to destination file using cell value

Hi I need a macro to copy and paste a file from source to destination specified in excel.

Column A has the source
Column B has destination
Column C has status

for example the source in cell A2 has to be copied and pasted to the destination in Cell B2 we should have a status completed or failed in column c2
the source in cell A3 has to be copied and pasted to the destination in Cell B3 and we should have a status completed or failed in column c3
the copying and pasting should be done till the last source and destination is available and it should continue even if it fails.

If it fails it should continue with the next row.

Kindly help me in the above situation.

I have attached a sample file.

Try the attached file. It will probably do what you want.

For convenience, the Macro code follows:

Please Login or Register  to view this content.

Hi LJMetzger,

That was really awsome

Just one more request what if "I want to copy the source folder and paste it to the destination folder"

Source path
C:\Users\Owner\Documents\Lew\WindowsBatchFiles\ExcelandVba

Destination path:
C:\Users\Owner\Documents\Lew\

After pasting i can find a copy of the folder ExcelandVba in the folder "Lew"

So in the above example i want to paste the folder "ExcelandVba" in the folder "LEW". I want to paste the entire folder. After pasting i can find a copy of the folder ExcelandVba in the folder "Lew".
Can you please help me

mani,

Thanks for the kind words and the rep points. Both are much appreciated.

See the attached file which adds the capability of copying folders (and all their subfolders and files). Please note that destination files that already exist are overwritten.

Please be careful when copying folders. It could take forever or longer to recover from an incorrect Destination folder name, especially since.

Lewis

Hi LJMetzger,

Hey man you ROCK That was really excellent But sorry for me asking one more request. This works fine in my local machine. But we have a tricky situation where we have to upload files to a content server. generally copying files to content server takes lot of time.Can you please update me if this is possible.


Thanks a lot for all your help till now

Regards,
Mani

Thanks again for the kind words. Unfortunately, this question is not in my area of expertise. I have never had a good server experience, and at the current time I don't have access to a server.

Sorry, Good luck.

Lewis