Forum Discussion
Solved
MacOS issue VBA with Workbooks.Open
At work, we use Google Drive for Desktop and up until recently could use a script that included the line to find a file path in the computer was a Mac. ElseIf Dir("/Volumes/GoogleDrive/Shared drives...
- After opening a workbook from that location you could open the VBE and open theimmediate window and then write:
?ActiveWorkbook.Path
and hit Enter. That should give you the location.
After opening a workbook from that location you could open the VBE and open theimmediate window and then write:
?ActiveWorkbook.Path
and hit Enter. That should give you the location.
?ActiveWorkbook.Path
and hit Enter. That should give you the location.