Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving using a path
I am tring to use the input from a user form to save this workbook int
a designated location below is what I am tring to use but isn't workin so I ahve something wrong not sure what it is. I want it to save upo clicking the Ok Button. "JobNoTXT" and "ComboBox1" are from th userform, and xldata is a folder designation. This is need to create uniform way to name these sheets. Thanks for any input. Private Sub OKBTN_Click() ActiveWorkbook.SaveA Filename:="L:\"JobNoTXT.Value"\xldata\"ComboBox1.V alue".xls " End Su -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving using a path
Try this
Private Sub OKBTN_Click() ActiveWorkbook.SaveAs _ Filename:="L:\" & JobNoTXT.Value & "\xldata\" & ComboBox1.Value & ".xls " End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "HelpMe " wrote in message ... I am tring to use the input from a user form to save this workbook into a designated location below is what I am tring to use but isn't working so I ahve something wrong not sure what it is. I want it to save upon clicking the Ok Button. "JobNoTXT" and "ComboBox1" are from the userform, and xldata is a folder designation. This is need to create a uniform way to name these sheets. Thanks for any input. Private Sub OKBTN_Click() ActiveWorkbook.SaveAs Filename:="L:\"JobNoTXT.Value"\xldata\"ComboBox1.V alue".xls " End Sub --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving using a path
Thanks That worked. I swear I had that at one point and it gave me an
error. Oh well --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions | |||
Saving excel backup copy - path? | Excel Discussion (Misc queries) | |||
Saving to a Network Path using VBA | Excel Programming |