Posted by: Coco Sanchez
How can I read / retrieve data from multiple worksheets on an Excel file.
These are jsut part of the codes on what we are currently using to read only
from the first worksheet on an Excel file:
Set bReturn = gExcelApp.PropGetWorkbooks( gExcelWorkbooks )
Set bReturn = gExcelWorkbooks.Open( psFileName,,,,,,,,,,,,,gExcelWorkbook )
Call gExcelWorkbook.PropGetActiveSheet( oXSheet )
We are using GTD4.2.
Thanks in advance for any help you could provide.