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
Hi T Poirier,
from an Excel - COM object the command to call the second sheet should be :
MySheet = XlFile.Sheets.Item("Sheet2")
MySheet.Activate();
Regards,
Christophe
from an Excel - COM object the command to call the second sheet should be :
MySheet = XlFile.Sheets.Item("Sheet2")
MySheet.Activate();
Regards,
Christophe