AutoHotkey Community

[gha1d]

Need help on below script guys, Please HELP..

Run D:\Geoffrey\Time Test.xls
WinWait, Microsoft Excel - Time Test,
IfWinNotActive, Microsoft Excel - Time Test, , WinActivate, Microsoft Excel - Time Test,
WinWaitActive, Microsoft Excel - Time Test,
Send, {CTRLDOWN}g{CTRLUP}
WinWait, Go To,
IfWinNotActive, Go To, , WinActivate, Go To,
WinWaitActive, Go To,
Send, d1{ENTER}

What i need to know is how to run a program if the above mentioned cell d1 contains a value like 1 or 0,

Eg:
If the cell contains 1, then run c:\my documents\Test.ahk
If the cell contains 0, do nothing

[DJAnonimo]

No way, its excel file, when you opet it as text its all crypted...

Better open it and retrieve the number, if you have a good PC
it will be fast, about a second

[PhiLho]

That's what he does...
I understand that you selected the D1 cell and suppose you succeeded. Then Send ^c to copy the value in the cell, and get its value in the Clipboard variable (might need to wait a bit).
_________________
vPhiLho := RegExReplace("Philippe Lhoste", "^(\w{3})\w*\s+\b(\w{3})\w*$", "$1$2")

[Rabiator]

There is another way to manage it, with an additional vbscript.

With it you don't have to open the excel file at all, therefore it's faster.

To use vbscript, the Windows Script Host has to be activated.
Registry: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows Script Host\Settings Enable=1.
Attention please, activating this is often deemed to be a securty risk!

Save the following vbscript e. g. in TEST.VBS.
It reads the cell contents and saves it to RESULT.TXT.

[gha1d]

I forget to thank you for this Rabiator, Good Luck..

[Rabiator]

Better late than never.

[Jeremiah]

Wow. Very helpful. I actually needed something like this. lol. Ironically. Thank you Rabiator.
_________________
-Jeremiah

[jethrow]

Helpful indeed - here's basically the same thing using AHKL & COM_L, now that we have more options :

[tank]