How to activate a specific sheet in an Excel file?

[Muhammadi]

Hi,
Does anyone know how to activate a specific sheet of an Excel file in PMC?

This script activates the Excel file:
WinActivate, File's name - Excel ahk_class XLMAIN

I need a similar thing but for a specific sheet in the excel file.

Thanks,
Muhammadi

[aifritz]

I'm not working with PMC, but there are many examples already in the forum.
With ahk and a bit knowledge of VBA you nearly could automate everything.

here a simple example...

Code: Select all

xl:=ComObjActive("Excel.Application")
xl.Sheets(2).Activate ;activates sheet 2 of the current spreadsheet