Forum Discussion

mohanakshi's avatar
mohanakshi
Contributor
15 years ago

Sys.keys is not working on active excel window!!

Hi,        I have one excel sheet opened and i want to click on button icon of its tab using click button.... this function works fine some times even the same code fails to do this many time... i ...
AlexeyKolosov's avatar
AlexeyKolosov
Icon for Staff rankStaff
15 years ago
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.