I added a blank password and added an "On Error GoTo" to skip over the file open. Works like a charm.
![]()
Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), ReadOnly:=True, UpdateLinks:=0, Password:="")
I added a blank password and added an "On Error GoTo" to skip over the file open. Works like a charm.
![]()
Set wbResults = Workbooks.Open(Filename:=.FoundFiles(lCount), ReadOnly:=True, UpdateLinks:=0, Password:="")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks