How to read data from another sheet in Excel
I am working toward reading user data from the first sheet on an excel file and then using the second to build the test data. How do I get Excel to read data from the second sheet? I'v...
Forum Discussion
Thanks for the reply! I figured it out and I used:
Excel.Sheets(1).Cell(1, 2) - Reads data out of cell 1, 2 from the first sheet
Excel.Sheets(1).Cell(1, 2) - Reads data out of cell 1, 2 from the first sheet