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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |