' Save_And_Print Macro
' Prints Proposal then saves it to Completed proposals Folder
I have some code written in a macro for a button that saves and prints.
I would like to change the name of the file instead of it, entering it automatically.
Below you see in blue I have the file name highlighted.
How can I change the code to let me enter a new file name?
Actually I would be happy to just stop the code at that window, let me enter my filename.
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWorkbook.SaveAs Filename:= _
"C:\WINDOWS\Personal\Completed Proposals\Proposal for XL.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
Application.CommandBars("Forms").Visible = False