Forum Discussion
how to update the datasources in multiple excel workbooks
I have 300 ish workbooks looking to 4 datasources. We want to move the workbooks and sources to Microsoft teams and out of the sharepoint library they are currently in. What is the best way to update the source for each worbook without having to do it manually?
1 Reply
Please reference this thread for how to loop through a directory of workbooks and save changes to them. If they all have the same data structure you may be able to update them like that. Not sure if you will be able to do it from teams though....
Here's the thread for the file loop:
Here's another thread that references how to access onedrive files via sync(which may be similar):
https://www.experts-exchange.com/questions/28585692/How-do-I-open-files-saved-in-Microsoft-Onedrive-using-vba.html
