I am having trouble accessing the data from a excel worksheet. I am also confused regarding the "workbook "and "worksheet" terms. Can someone also send me the code to do it through DAO.
Thanks
[Edited by amitabh on 08-08-2000 at 08:59 PM]
Printable View
I am having trouble accessing the data from a excel worksheet. I am also confused regarding the "workbook "and "worksheet" terms. Can someone also send me the code to do it through DAO.
Thanks
[Edited by amitabh on 08-08-2000 at 08:59 PM]
Worksheet is a single spreadsheet.
Workbook is a collection of worksheets. You know when you first open excel and the workbook loads with sheet1, sheet2, and sheet3.
Sheet1, etc., are worksheets while the file itself is the workbook.