Hi im just a new here and Im hoping that you can help me. Im having a problem in my project and I cant find any solution in the internet thats why i am hopeful that in this forum somebody will help me.
this is my codes
Private Sub cmdupdate_Click() Set oapp = Excel.Application Set oWB = oapp.Workbooks.Add Set excelWS = Excel.Worksheets("Sheet1") NewRow = range("A").End(xlDown).Offset(1, 0).Row oapp.Sheets("Sheet4").Cells(NewRow, 1).Value = txtclient.Text oWB.SaveAs ("C:\140410.xlsx") ' <-- method or data member not found.
and it highlighted the word .saveas
should i declare it or what?
advance thank you guys.
Edited 2 Years Ago by pritaeas: Added markdown.