I have attached my workbook. I am trying to use this macro to copy and paste a document from one location to another.
I keep getting run-time error '52' "Bad file name or number".
I know the file location that I am referencing is correct but it does not seem to be working.
Can anyone help me with this?
Thanks,
Last edited by glide2131; 06-28-2014 at 10:41 AM.
Why are you adding a "/" at the end of each file name? I didn't set up the files to be able to test it with your data but try this:
Also, you are running down column C but file names 2-4 are blank. That is bound to cause trouble.
Please Login or Register to view this content.
I deleted the "/" and numbers 2-4 with the same result. If I just paste the file locations straight into the code it works fine.
For example:
Please Login or Register to view this content.
What am I missing?
I setup folders and files, populated C3:C5 with 1, 2, 3, and columns F and G with file names, and it worked perfectly with the one change I recommended.
I cannot find anything in your code that would explain why it does not work with reading file names from cells but does work when you hard code the file names. Just for good measure here is the code that works for me:
Please Login or Register to view this content.
Yep. Got it to work. It was the empty rows of data like you said. Thank you a ton!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks