I currently have an order form which uses a macro to store the xls and csv in dropbox. This form is used on several macs, and currently, I have to make a specific excel file for each mac with the specific paths for that particular mac in the macros.
I don't think I explained that very well so, for example this saves the file as a CSV:-
Dim FName As String, FPath As String
FName = ActiveWorkbook.Sheets("CUSTOMER").Range("C12").Value
FPath = "Macintosh HD:Users:Office2-Spare:Dropbox:Operations:Phone Orders:"
ActiveWorkbook.SaveAs Filename:=FPath & FName & ".csv", FileFormat:=xlCSV
So for each mac that uses this file I have to edit their copy, say from Office2-Spare to read Despatch as that is their user name.
I have tried using
FPath = "Macintosh HD:Users:$USER:Dropbox:Operations:Phone Orders:"
but it didn't like it.
Perhaps there is a way of finding the Dropbox location on each mac when the macro is run, but I wouldn't even know where to start with that...
Can anyone help me?? I have trawled the internet but come up with nothing!
Thanks in advance