AlInVegas2
New Member
- Joined
- Jun 19, 2019
- Messages
- 20
When working on a local server, DirPath = ActiveWorkbook.Path will render a Windows path C:\MyFile'sDirectoryPath\Myfile.pdf
When looking at a cloud based file that has been synced locally, the windows path in the screen will be C:\Users\MyUserName\MyFile'sDirectoryPath\Myfile.pdf
When executing ActiveWorkbook.Path for the same cloud based file, the URL for its location on the cloud is returned. https:/site/MyFile'sDirectoryPath/Myfile.pdf
Is there a command that will render the local path to the file? You can access the file via the URL, however, that requires you to authenticate via a web browser. I'd rather execute using the local as that has already been authenticated. Please forgive any errors my phrasing of the issue. I'm just dangerous enough to spell Macro.
When looking at a cloud based file that has been synced locally, the windows path in the screen will be C:\Users\MyUserName\MyFile'sDirectoryPath\Myfile.pdf
When executing ActiveWorkbook.Path for the same cloud based file, the URL for its location on the cloud is returned. https:/site/MyFile'sDirectoryPath/Myfile.pdf
Is there a command that will render the local path to the file? You can access the file via the URL, however, that requires you to authenticate via a web browser. I'd rather execute using the local as that has already been authenticated. Please forgive any errors my phrasing of the issue. I'm just dangerous enough to spell Macro.
