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
How to select / Activate Specific Excel Sheet without COM
Re: How to select / Activate Specific Excel Sheet without COM
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.
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
- Posts: 2848
- Joined: 29 Sep 2013, 19:01
Re: How to select / Activate Specific Excel Sheet without COM
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....
You might not need a script to do Ctrl PgUp and Ctrl PgDn....
14.3 & 1.3.7
Re: How to select / Activate Specific Excel Sheet without COM
@flyingDman Thanks for point it out , Correct me if I'm wrong, Perhaps running the script as administrator will also make sense
.
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Re: How to select / Activate Specific Excel Sheet without COM
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...
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
- Posts: 2848
- Joined: 29 Sep 2013, 19:01
Re: How to select / Activate Specific Excel Sheet without COM
What error -if any - does it give you?
14.3 & 1.3.7