using macros to save files in different locations
How do you get a macro to Save As a file that you have already prompted the
user for and assigned to a variable? The following code is what i have but i
can't get it to Save As the User input.
Dim vFile As String
vFile = InputBox("Please type in a date, I.E. January 2006")
ActiveWorkbook.SaveAs Filename:=vFile_
"C:\Documents and Settings\monthly\My Documents\vFile", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:= False, CreateBackup:=False
|