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?