John Steel
New Member
- Joined
- Feb 7, 2017
- Messages
- 12
Hello and thanks for considering an issue I'm bringing up.
First off - this is relevant only to files stored on DropBox or, very likely, other cloud storage platforms. And only due to the files being accessed on different computers.
The problem appears to be that Excel typically uses absolute filepaths and, when accessing the file on different computers via DropBox, the local filepath varies based on the computer.
My code has the following line which works great from the "jstee" computer, but return error code 400 on other computers. At the moment I would also like for it to work for "ematt" computer, but, ideally, would like for it to adapt to other computers the file is accessed from.
Not sure it matters, but the line below is utilized in a macro that looks up a referenced .jpeg file from a folder on DropBox and places it in a certain place in the worksheet. The Comp_photos folder is within the base level DropBox folder and the file with the macro is located deeper in the DropBox directory. This file is generated from a template and must be able to access the Comp_photos folder from wherever it is in the DropBox directory.
I've been struggling with this for over a year now and would be elated for any help. Thank you!
Folderpath = "C:\Users\jstee\Dropbox\Comp_photos"
First off - this is relevant only to files stored on DropBox or, very likely, other cloud storage platforms. And only due to the files being accessed on different computers.
The problem appears to be that Excel typically uses absolute filepaths and, when accessing the file on different computers via DropBox, the local filepath varies based on the computer.
My code has the following line which works great from the "jstee" computer, but return error code 400 on other computers. At the moment I would also like for it to work for "ematt" computer, but, ideally, would like for it to adapt to other computers the file is accessed from.
Not sure it matters, but the line below is utilized in a macro that looks up a referenced .jpeg file from a folder on DropBox and places it in a certain place in the worksheet. The Comp_photos folder is within the base level DropBox folder and the file with the macro is located deeper in the DropBox directory. This file is generated from a template and must be able to access the Comp_photos folder from wherever it is in the DropBox directory.
I've been struggling with this for over a year now and would be elated for any help. Thank you!
Folderpath = "C:\Users\jstee\Dropbox\Comp_photos"