Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating Path and FileName
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 | |
|
|
Similar Threads | ||||
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) | |||
How do i display the Filename without the path? | Excel Discussion (Misc queries) | |||
Pulling in the path to a filename | Excel Worksheet Functions | |||
Filename and path | Excel Programming | |||
filename and path as constant | Excel Programming |