run time error 1004 method open of object workbooks failed

[bennyamy]

I am getting a run time error when running the script below. The files are located on a SharePoint site. I can open each of the files with no problem so I don't think they are corrupt.
This line is where the error occurs "Set WorkBk = Workbooks.Open(FolderPath & FileName)"

Please Login or Register  to view this content.

[davesexcel]

Does the filename not already include the folderPath?

[CK76]

Try using Open method with URL instead of network path. Open method will accept valid url string as argument.

And make sure you convert the string to URL type (i.e. replace space with "%20" etc)
Ex. "http://workspace.bsaconnect.com/fin/AP/NonPO%20Invoices/2017/yourfilename.xlsx"

You may need to change slash direction. My system uses forward slash, but your's may use back slash.

Other than that, you can probably add Sharpoint Folder to shared network drive and work with it that way (if it's on same local network).

[CK76]

Does the filename not already include the folderPath?

Dir should only return file name without path.
0.JPG

[davesexcel]

Here is my code for looping through a folder
http://www.xlorate.com/vba-examples....rough%20Folder