Saving using a path

  • Thread starter Thread starter HelpMe
  • Start date Start date
H

HelpMe

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.Value".xls "



End Su
 
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)
 
Back
Top