Sleeper: Macro Code for Save but no Dialog Boxes

[shydaddy]

Private Sub CommandButton1_Click()
' Runs Macro to save the Target Sheet.
ActiveWorkbook.SaveAs Filename:=Range("N2"), _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

I am no VBA expert but this might do the trick for you. This is what I am using in the project that I am working on now. The user clicks a button on the page and the above macro runs. N2 contains the following formula:

=CONCATENATE("G:\RD\FAB\CMP\Target Sheets\", E2, " - ", E3, ".xls")

This is working for me, the user doesn't have to do anything but press the button.