Hello everyone. I'm new to this forum - any help would be greatly appreciated!
I have a file that I use for work that several people share. The macro that I wrote opens a file from a location in Dropbox. For those of us using Windows, I just made sure everyone's Dropbox location is C:\Dropbox\Folder... But not sure how to do this across platforms so Mac users can run this macro as well. I tried a hyperlink to Dropbox, but it's crazy slow. (Not sure if I had the VBA syntax correct, though). By the way, I kinda have no idea what I'm doing in VBA...
Sheets("Output").Select
Workbooks.Open Filename:= _
"C:\Dropbox\Folder\demo.xls"
Windows("Weekly Demos Report.xlsm").Activate
Calculate
I have a file that I use for work that several people share. The macro that I wrote opens a file from a location in Dropbox. For those of us using Windows, I just made sure everyone's Dropbox location is C:\Dropbox\Folder... But not sure how to do this across platforms so Mac users can run this macro as well. I tried a hyperlink to Dropbox, but it's crazy slow. (Not sure if I had the VBA syntax correct, though). By the way, I kinda have no idea what I'm doing in VBA...
Sheets("Output").Select
Workbooks.Open Filename:= _
"C:\Dropbox\Folder\demo.xls"
Windows("Weekly Demos Report.xlsm").Activate
Calculate
