Forum Discussion
VBA to open excel files in teams
Hi I wrote a VBA script to loop through a folder and open any .xls files and it has been working great for 3 months. Since then my team has migrated to Teams and I need to change my file path t...
Basically you need to share point URL’s In the script you also have to make sure that it got access to that location in SharePoint as well
Thanks for your reply adam deltinger
The script I use loops through a folder opens each workbook and then copies data into one master workbook.
My questions are;
- how can I change the file path to now open these workbooks in Teams
-- do you have any examples of code?
-will it open the workbooks or open them online through teams?
-- If it does open them online will the rest of my copying macro work?