Macro Save As Code???

C

Chris Watson

I need to save a work book into a location with a name from a cell using
a macro ie: C:\Temp\Invoice\F15.
F15 containing the file name.
Is this possible.
 
G

Gary''s Student

Sub Macro2()
Dim s, ss As String
s = Cells(1, 1).Value
ss = "C:\" & s
ActiveWorkbook.SaveAs Filename:=ss, FileFormat:=xlNormal, Password _
:="", WriteResPassword:="", ReadOnlyRecommended:=False,
CreateBackup:= _
False
End Sub
 
Top