Im trying to SaveAs a file that is stored on a server in a different file format. The sub folders that the file is stored in on the server wont be consistent so I cant simply write the path in as a string I need to be able to extract it dynamically.

The true path of the file is:

smb://xxx.xxx.x.xx/Jobs24/Graphic Group/164626/_data/FileName.xlsx

But when I use ActiveWorkbook.FullName I get:

/Users/oliver/Library/Containers/com.microsoft.Excel/Data/Documents/FileName.xlsx

Is there a method that will pull the true path? Since ActiveWorkbook.Save works as intended I assume that information is in there somewhere.

I’ve tried using fso.get and Workbook.FullName but they only pull the local temp path. All the documentation I find is for finding the local file path when I need the server file path. Or the documentation is about finding out the server path manually and then writing it as a string. I cant do that since the exact path wont always be the same.