Trouble with Name Function: File Not Found

[nhoj]

Hello,

I'm having trouble figuring out why this is happening and was wondering if anyone has any insights?

Problem: a full path string works fine for a workbooks.open command but not for name.

structure of openfile = "C:\several folders\filename1.xlsx"
structure of newname = "C:\same several folders\filename2.xlsx"

no forbidden characters are in either path

The below opens up just fine:

Please Login or Register  to view this content.

With the .xlsx file closed, the below returns "file not found"

Please Login or Register  to view this content.

So to summarize my question...how can the first code block above work, but the second returns "file not found?" Thanks!

[Richard Buttrey]

We generally prefer to see the problem in context. Please upload the file.

Are you saying that 'openfile' is a VBA string Variable with a value "C:\several folders\filename1.xlsx"

We don't know what 'Name' or 'newname' are.

[nhoj]

Unfortunately (for sorting out this issue) the file contains too much proprietary information to share and I have over 1 month of development time into it. I can try to recreate the scenario in a file that is shareable.

"name" is me using the name statement

https://docs.microsoft.com/en-us/off...name-statement

Does the below help?:

Please Login or Register  to view this content.

[nhoj]

I think I'm narrowing down on my issue. I assumed that the name function could globally change the full path in one shot.

It looks like I need to go from right to left on the name changes: first change the .xlsx, then the next level directory and so on.