Hello, I have code that subverts any saving to a custom subroutine. This works generally fine, but when I click the File tab and Save As by choosing a pinned folder, it only ever goes to My Documents. The relevant code is as follows:
How can I get the InitialFileName from the File/Save As prompt?![]()
Dim filename as string filename = Application.GetSaveAsFilename( _ InitialFileName:=Me.Name, _ Title:="SaveAs")
Bookmarks