hello....got some headache and need somebodies help...
I am trying to figure out how to using Access DAO or ADO to "retrieve existing Excel Worksheets" particular cells value(s) and save back to Access table, i can only got some coding from some sources as below but which only show how to "write" data from Access to a "new created" Excel & worksheet only...
Can somebodies help....thanks a lot.
Sub OpenExcel()
Dim xlApp As Excel.Application
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Add
ActiveCell.FormulaR1C1 = "ABC"
xlApp.Quit
Set xlApp = Nothing
End Sub
Beginner