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