Change Excel sheets from Access vba

[lawdy]

Using Access vba, I am able to open an Excel spreadsheet and get data and/or add data. But, while I am on a certain sheet, I need to get data from another sheet. Is There a function to change sheets? Thanks in advance for you help.

[Welshgasman]

No need to change sheets, just refer to the worksheet and range.

[lawdy]

Thanks for you reply, but how would I do that?

[Welshgasman]

With the standard
Workbook.Sheets().Range() syntax ?

How are you addressing ranges now?

[lawdy]

strCat = objWorkSheet.Cells(lngRow, 1)

[lawdy]

Ok, thank you very much.