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 to the teams folder.
Can anyone please assist with a VBA Script that can loop through a teams folder and open any excel files in it
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?
@adam deltingerI exactly have the same issue.
What are the API to use to access to an Excel file stored in Teams.
Do you have an example.