Correct path to open file on Mac

[knighttrader]

I am running the latest version of Excel for Mac and trying to get a macro to open a file called Report in Dropbox.

When I run the macro it errors saying it can't find the file. This is the pathname I'm using:

Set wbTarget = Workbooks.Open("Macintosh HD:Users:Steve:Dropbox:BA:Report.xlsm")

Anyone know how I should correctly write the file pathname for Mac?

 

[rollis13]

On a Mac, shouldn't you be using slashs ( / ) instead colons ( : ), am I right ?

 

[knighttrader]

On a Mac, shouldn't you be using slashs ( / ) instead colons ( : ), am I right ?

Yes you are. I was using code from an older version of Excel.

Thanks

 

[rollis13]

Glad having been of some help.