Dir () , Workbooks.Open stopped working

I have a macro that I have been using for some time to find and open a set of files to gather data. Suddenly it is not working.

Please Login or Register  to view this content.

I get

Please Login or Register  to view this content.

I have changed the Workbooks.Open line to this:

Please Login or Register  to view this content.

and now it works. The original code still works on my other machine. Why the change??

Between the time that it last worked and the time that it first gave me a problem, I stopped to fix a form control a second spreadsheet. The button clears the filters from a ListObject and it wasn't working. I saw some references to FilterMode and AutoFilterMode on the forum for that issue, and when I threw Debug.Print AutoFilterMode into the sub I got a weird result that seemed to be referencing back to the first spreadsheet. After that I returned to the first one and ran into this issue.

So what gives? Just trying to understand. Thanks in advance.

Dir doesn't return the path, and Open requires that either the file be in the current directory or the path be fully included.

Please Login or Register  to view this content.

Please Login or Register  to view this content.