Not finding other files in current folder

User has several files in same Folder. This first part of the Code in the ADMIN file in the Folder should look at each one in turn. Those containing the string "File Complete" anywhere should be listed in Cols A and B, and those without the string should be listed in Cols D and E.

My understanding was that if all the files are in the same Directory, then the full File Path is not needed to call the other files, because "strPath = ThisWorkbook.Path" would be adequate.

Please Login or Register  to view this content.

All solutions, suggestions and alternatives welcome as ever

Ochimus

Hello Ochimus,

The only potential issue I can see is if you have not yet saved the workbook with the macro code. Until a workbook has been saved, the Path property will be an empty string. An empty string would then immediately exit the Do loop.

Hello Ochimus,

Thanks was my next question. If it is in the cloud or on a network prefix your path with "//?/server name/" & ThisWorkbook.Path

Hello Ochimus,

If your workbook is located on the web at "https://d.docs.live.net/", which is the server address, then it will be the same for everyone.

Is the macro in this workbook?