Excel VBA runtime error 1004:method ‘’ of object ‘workbooks’ failed

[Turk182]

Hi, does anyone have an idea regarding a possible “fix” for this error?

--Excel VBA runtime error 1004: method ‘’ of object ‘workbooks’ failed

the file to open is not currently open, nor is it being used by someone else
I appreciate any help. Thx.
...

FileToOpen = Application.GetOpenFilename(Title:="Browse for the SUPPLIER File you saved & SELECT it", ButtonText:="Choose SUPPLIER Dec Sheet")

   If FileToOpen <> False Then
       Set OpenBook = Application.Workbooks.Open(FileToOpen)

...

 

[Turk182]

1. Is there a limit on the number of (or "level" of) "nested" folders-within-folders that this code can access to open?… I moved FILE TO BE OPENED to a "parent" folder and it worked!
2. Is there a way to tell whether the folder itself is corrupted?

It is strange--to me-- that just putting the files in the “parent” folder resolved the issue.

Just to test, I put the files back in the “sub folder”, ran the macro, and I got the same error message again!