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.
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.
No need to change sheets, just refer to the worksheet and range.
Thanks for you reply, but how would I do that?
With the standard
Workbook.Sheets().Range() syntax ?
How are you addressing ranges now?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
Code:strCat = objWorkSheet.Cells(lngRow, 1)
Ok, thank you very much.