Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am tryin to create a filename and path using Input boxes.... Sub MySub() Dim UserInput1 as string Dim UserInput2 as string UserInput1=inputbox("Enter Data") UserInput2=inputbox("Enter Some Moredata" activeWorkBook.SaveAs Filename:="C:\Mypath"&UserInput1&"\UserInput1 _ &"-"UserInput2&".xlsm",FileFormat:=xlOpenXMLWorkbookM acroEnabled, CreateBackup:=False But Im getting "expected End of Statement" on the "\" What am I doing wrong? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Creating Path and FileName | Excel Programming | |||
Using xlDialogFindFile to get filename and path. | Excel Programming | |||
Filename and path | Excel Programming | |||
Need directory path without filename | Excel Programming |