Hi all, I have 2 excel files in 2 different folders within Dropbox. I want my macro in one file to open the other file. I have the local location for the file I wish to open:

"C:\Users\Eigenaar\Dropbox (Consensio Holidays)\accounts\Shared Documents\Chalets\NickyTest QBUpload Files\zzz QB upload file.xlsx"

I also have found the Dropbox link for the file, found by right clicking on the file on my local area and selecting 'copy dropbox link':

https://www.dropbox.com/s/7azm69e9la...file.xlsm?dl=0

I tried recording a macro, I found the file, opened it and clicked stop recording, that gave me the following, but when I then tried to run the macro it said that it could not find the file:

Please Login or Register  to view this content.
I have thoroughly checked the file path and it is correct, it was the one created by recording my action of opening the file.


However I would prefer opening the file by using the dropbox link so that it is the same on other users computers, but I have no idea what to write.

Can anyone help explain why my above macro does not work and what I could use to open my dropbox file using the dropbox link?