I have VB that customizes the file name in Excel when saving.
However when I add this code, it wants to save the file to my local machine = I lose the sharepoint path/url to the doc library.
How can I populate this dynamically? (I don't want to hard code the path)
Dim MyFileName As String
MyFileName = "PO_" & Format(Now(), "yyyymmdd-hhnnss")
ActiveWorkbook.SaveAs Filename:=MyFileName, FileFormat:=52