knighttrader
New Member
- Joined
- Apr 3, 2010
- Messages
- 21
- Office Version
- 2021
- Platform
- MacOS
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:
Anyone know how I should correctly write the file pathname for Mac?
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?