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.
Does the filename not already include the folderPath?
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).
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Dir should only return file name without path.Does the filename not already include the folderPath?
0.JPG
Here is my code for looping through a folder
http://www.xlorate.com/vba-examples....rough%20Folder
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks