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:
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?
Bookmarks