Hello everyone
I have a question regarding the path for a file in a dropbox folder in excel VBA:
Currently, I use
I use
because it has to work on multiple computers.
But is it also possible to make a changeable for the name of the dropbox. The name of our company dropbox is "PVAP Dropbox". But can I write the code so that it would work for another dropbox name for example "ABC Dropbox" without having to change each path in the workbook manually.
in short: is there something in excel like?
Thx in advance
I have a question regarding the path for a file in a dropbox folder in excel VBA:
Currently, I use
VBA Code:
path = "C:\Users\" & Environ("username") & "\PVAP Dropbox\..."
I use
VBA Code:
Environ("username")
But is it also possible to make a changeable for the name of the dropbox. The name of our company dropbox is "PVAP Dropbox". But can I write the code so that it would work for another dropbox name for example "ABC Dropbox" without having to change each path in the workbook manually.
in short: is there something in excel like?
VBA Code:
Environ("dropboxname")