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:

Set openbook = Workbooks.Open(openfile)
With the .xlsx file closed, the below returns "file not found"

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