Forum Discussion
3 Replies
- MorganFrequent ContributorI'm not sure if this is what you are looking for but if you are trying to select an Excel sheet tab, you could try (VBScript) :
Excel.Sheets("tabname").Select
I was just having this issue and this code seemed to make it work!
Good Luck,
Morgan - mohanakshiContributorProblem is not for selecting the tab.. but for clicking on tab button using shortcut keys
- Hi Mohanakshi,
Working with Excel via GUI is not a very good idea, actually (unless you need to test the GUI). If you just need to work with an Excel sheet from TestComplete, you should either use DDT drivers or the Excel COM object - these approaches are much more reliable. You can find additional information on them in the Working With Excel Files via COM and Using Excel Files as Data Storages help topics.