VBA for Coying Files and folders

[mvinay]

Hello All,

Could someone help me with attached VBA code.

I have googled and found this code. I had made few changes in the attached code but i am getting error.

Kindly look into this.

Thanks in advance.

[David A Coop]

It is not clear what you are trying to do, but I can drew your attention to a few things.

1. You have declared fFromPath and tToPath, but in your code you haven't used them. Instead you used FromPath. These variables need to be consistent.

2. When you assigned a path to a variable, you used f and t instead of B]fFromPath[/B] and tToPath

3. In the filepaths in cells B1 and B2, you don't have a "\" at the end. You have code looking for that in the IF statements.

This is what I mean!

Please Login or Register  to view this content.

It now exits with a message "C:\20041 doesn't exist" on my PC which was expected.

See how you go!

Regards

David


When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[mvinay]

Wow!! Its working.

Thank You..

[David A Coop]

Wow!! Its working.

Thank You..

You're welcome!

Don't forget to mark your thread as SOLVED and to click the *Add Reputation button at the bottom left.

DAC