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 ...
Morgan's avatar
Morgan
Frequent Contributor
15 years ago
I'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