Set DB = Workbooks.Open(DBname, 3, False,, ,, True)ĪctiveWorkbook. Again this file should be editable by multiple users simultaneously. Is open in read only and changes cannot be saved. The other Excel file when opened works fine (if I remove the LockServerFile command), all it's macro's work fine, but it The code that I show below is in the Excel file that is opened manually by the user and that opens automatically the other Excel file. You can work with a wide variety of data sources in Excel, including native data and external data. For information about Microsoft 365 (in the cloud), see Use external data in workbooks in SharePoint Online. I've tried > but always get an error message >. The information in this article applies to Excel Services in SharePoint Server 2013 (on premises) only. If you use 'Open with Explorer' in SharePoint, see How to use the 'Open with Explorer' command to troubleshoot issues in SharePoint Online and Switch the default for document libraries from new or classic in SharePoint Online in the Microsoft Knowledge Base. However I can't get it to even open in edit mode. Tableau Community Forums question resolved: Connecting to excel data on a Sharepoint 365 site. The file being opened by the vba macro needs to be edited, and mustīe editable by multiple users at the same time. I have an macro enabled Excel file on a SharePoint that when a user opens it from the SharePoint the file opens programmatically another macro enabled Excel file on the same SharePoint.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |