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

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/

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/