Using filepaths in VBA code - files located on DropBox

[John Steel]

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"

 

[JumboCactuar]

You can adapt your code using

Dim filepath as string 
filepath = environ("USERPROFILE")

Try:

Dim filepath as string

Filename:= Environ("USERPROFILE") & "\Dropbox\Comp_Photos"

 

[John Steel]

Anyone have any thoughts on this as a possible solution? I saw something like it elsewhere but I've not gotten it to work.

Folderpath = "C:\Users" & Environ("username") & "\Dropbox\Comp_photos"

 

[JumboCactuar]

cant edit above but should be

Dim Filepath As String

Filepath = Environ("USERPROFILE") & "\Dropbox\Comp_Photos\"

tested and working here

 

[John Steel]

Thx Jumbo

Should it be filepath or folderpath?

 

[John Steel]

Left it as folderpath and it seems to work fine. Gotta test it on a second computer later tonight.

Thanks Jumbo!

 

[JumboCactuar]

Thx Jumbo

Should it be filepath or folderpath?

can be either really