Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using macros to save files in different locations
Adam,
I guess you mean: ActiveWorkbook.SaveAs Filename:= "C:\Documents and Settings\monthly\My Documents\" & vFile & ".xls", FileFormat:=xlNormal NickHK "Adam" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save & send Excel files without macros. | Excel Discussion (Misc queries) | |||
can you automatically save files to two different locations? | Excel Discussion (Misc queries) | |||
Is it possible to save an Excel file to 2 locations? | New Users to Excel | |||
VBA Code to save to 2 locations | Excel Programming | |||
VBA Code to save to 2 locations | Excel Programming |