How to select / Activate Specific Excel Sheet without COM

[Ram]

Hello i need some help. Does anybody know how to write autohotkey code for selecting / activating specific Excel SHEET without COM?

Because i tried COM and it doesnt work after I reinstall new windows, so i'm lookin for another way without COM.

Thankyou very much

[HiSoKa]

If you mean that you want to move between sheet I think this code will help,

If the window is active you can use this code to move between Sheets.

Code: Select all

#SingleInstance, Force
SetTitleMatchMode, 2

#IfWinActive ahk_exe EXCEL.EXE
f1::  ; Next sheet 
send, {Ctrl Down}{PgDn}{CtrlUp}   
return
f2::  ; Previous sheet  
send, {Ctrl Down}{PgUp}{CtrlUp}
return

Esc::ExitApp

[flyingDman]

COM should work after a a Windows reinstall. Make sure Office is properly installed and registered. If you have an Office 365 subscription, go to https://account.microsoft.com/services/microsoft365/install to make sure your device is listed.

You might not need a script to do Ctrl PgUp and Ctrl PgDn....

[HiSoKa]

@flyingDman Thanks for point it out , Correct me if I'm wrong, Perhaps running the script as administrator will also make sense .

[Ram]

Thankyou very much for your help FlyingDman and Hisoka.

For your script its good man thankyou Hisoka.

And actually i already registered microsoft office etc... i'm still confused why my COM isn't working, it was working before reinstalling to new windows...

[flyingDman]

What error -if any - does it give you?