VBA will work in one workbook, but not another???

[Rerock]

I have the following code in a spreadsheet. When I run it, always get an error on line 21; sometimes it's #70 (path not found) and occasionally it's #76 (permission denied).

However, when I copy the code to a blank workbook (along with the named ranges), the code works perfectly; everytime.

This is all stored in the same folder in a network drive, so I thought perhaps it was a network permission or something goofing things up, but the blank workbook debunked that theory.

Here is the code; can anyone tell me some ideas as to why I might be experiencing this problem? It's vague I know, but I don't know what else to say. If you have some ideas of what I could try to help narrow down the culprit, I'm all ears.

Thanks!

Please Login or Register  to view this content.

[Cerbera]

Hi, Haven't been able to work through your code, however I was wondering if the new workbook is saved in the same directory as the original one before running the code and whether this could cause the different behaviour? Not sure if the current folder location would affect any of your code. It's a long shot but thought I'd mention it as I haven't got time to go through it properly to check.

[Rerock]

Hi,
Thanks for the reply. Yes, the filepath for both spreadsheets is the same on the network drive. The problem is the same though if I save the real spreadsheet and test spreadsheet and run them on my desktop too.

I've attached a copy of the test spreadsheet I've been trying out. I just create folder on my desktop, create a new folder inside of that, and save the spreadsheet inside of that. I also added some other files in there too (jpg's, pdf's, doc's, etc) to test that it copies the files from one folder to another properly.

This test worksheet works properly, but the exact same RENAME_PROJECT_FOLDER macro copied to another spreadsheet does not; sooo weird.