View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HelpMe HelpMe is offline
external usenet poster
 
Posts: 1
Default 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