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 wanted to why its so.. please help me







Thank in advance,

Mohanakshi

3 Replies

  • Morgan's avatar
    Morgan
    Frequent Contributor
    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
  • Problem is not for selecting the tab.. but for clicking on tab button using shortcut keys