Open file macro allowing multiple users to run macro

Hi,

I have a macro that goes into a file, copies a range and pastes that range in a different file. I have managed to get it to work for me but can't figure out how to get it to work from any other computer.
The file is saved on Dropbox with the same folder structure for all of the users who might be running the macro.

The code I have currently for opening the file is:

Please Login or Register  to view this content.

from searching on various sites I understand I have to use code along the lines of:

Please Login or Register  to view this content.

However, I haven't managed to work this code into what I already have without it causing an error.

Any help is greatly appreciated!




Also, is the file & folder name considered case sensitive when referencing in VBA?
e.g. when looking at the above code, if the folder name was "18 australia south east" but the code refers to "18 Australia South East" would the code still work or not?

Thanks!

You are almost there.

Please Login or Register  to view this content.

Folder and file names in Windows are not case sensitive, so you don't have to worry about case in VBA (or any other language).

(You are assuming that everybody uses the default path when they install Dropbox. This is a pretty safe bet but not 100% guaranteed. If you want a guarantee you have to read the Dropbox JSON file that gives the configuration details.)

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Just for the sake of completeness, here is the code to find the Dropbox path. This is 100% guaranteed, unless the user has multiple Dropbox accounts installed to the same machine. If there are multiple accounts it uses the last one.

Please Login or Register  to view this content.

Originally Posted by MBel1

I am actually working on mac

You should specify this in the Excel version in your profile.

The file separator on a Mac is ":" so I don't know how you get that path to work.

Also, for code that has to run in both environments you can use Application.PathSeparator instead of hardcoding "\".