Hi,
So i have several files that I have now uploaded onto my OneDrive. What i would like to do is have a macro that collect the information from all these files and puts them into a masterfile that is located on on my regular drive (not online)
Before, I used the web-address from Sharepoint to collect the info from the spreadsheets.
I want to do the same for my files that is not in OneDrive. I realize that i cannot use macros for Excel Online in OneDrive, but can i link the file online to a local file?
Bookmarks