Looking at the paths, when I actually physically access the file it is being pulled from a different path then what is present on the main SP site (looks like it stores the files that I have access to in my personal directory). I am no expert but I believe the reason that there are so many posts with different solutions that work for others is just due to the permission settings that are configured for different companies/users. SP site path: /r/sites/?d=xxxxxxxxxxxxxxxxxx&csf=1&web=1&e=xxxxx When I compared the path copied from the file breadcrumb trail on the Info tab to the path that was copied from the SP site, the subtle difference I noticed was that my personal credentials were present in the breadcrumb trail path and there were actually some different folder references. Paste the copied path as is to the Workbooks.Open() method and it should open successfully I do not want to open a locally-cached copy, it needs to be the server version. A million permutations, and none of them work. Some say if it’s https then you have to specify – “ say the forward slashes should be backslashes. Some say you need to specify the filename as a WebDAV filespec:įilespec – “//pathto.sharepoint_server/folder/myfile.xlsx” Or if you want to assign to a Workbook object, you can say Do you have a suggestion?Ī Filename:=filespec
I've read and tried all the variations and I'm not having any success.
I can open the files if they're located on a network share. I'm unable to open any Excel file on a Sharepoint server from a VBA script in an Excel file located on the same server. About six months ago my company started moving projects from a network share to a Sharepoint server, and that's when this problem began. Hello all, I've been using VBA in Excel to write scripts to automate order processing for seven years.
0 kommentar(er)
