Is there a VBA method for extracting the original server path of an Excel file when working from a local temp file
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.