How to activate specific excel sheet? Topic is solved

[Guest]

i want to activate sheet2 of current activated excel file. i.e. if current excel file say ABC is opened then i want that when i press hotkey f1 it should always activate sheet2 of ABC excel file...
how it is possible via com objects...
THANKS

[HotKeyIt]

Code: Select all

xl:=ComObjActive("Excel.Application")
xl.Sheets("Sheet2").Select

You can simply create a macro in Excel and check the code that is run when you do things

[nik2502]

Code: Select all

xl:=ComObjActive("Excel.Application")
xl.Sheets("Sheet2").Select

You can simply create a macro in Excel and check the code that is run when you do things

What if the excel file is invisible, How do i select a specific sheet ?

[flyingDman]

You can use xl.sheets(2).select or xl.sheets(3).activate. In most cases they are equivalent but you can select multiple sheets and then activate one of them (but not more than 1). You should be able to use select and activate when the Excel is not made visible.