AutoHotkey Community

Scr1pter wrote: ↑
10 Apr 2019, 07:12
What happened to the topic title?

I never saw one. I have now added one.

this line if ((posX >= 719) && (posY >= 942)) || ((posX >= 995) && (posY >= 1008)) doesn't really define the boundaries under which the code should work. If the area should be between two x/y coordinate then you should have >= and <= for x/y boundaries. Also, as logic goes you would want the stateme...

What is your script trying to do?

Tables have a lot of "junk" that you encounter using VBA that you don't see on your screen. You could iterate the table, pull each value out of each cell and evaluate/highlight that way, but as far as using Range itself there's not much that you can do to get around the issues.

Possible workaround:

Code: Select all

tmp :=	Clipboard, cx :=	A_CaretX, cy :=	A_CaretY
Sleep, 25
Send ^v
While	(cx=A_CaretX) && (cy=A_CaretY)
	Sleep, 25
Clipboard :=	tmp

I'm going to move this to Ask for Help first to confirm that there is a bug, if we can confirm it then we'll move to Bug Reports.

Just for clarity's sake: StringSplit - OutputArray wrote: The name of the pseudo-array in which to store each substring extracted from InputVar. For example, if MyArray is specified, the command will put the number of substrings produced (0 if none) into MyArray0, the first substring into MyArray1, ...

Code: Select all

xl :=	ComObjActive("Excel.Application"), xl.screenUpdating :=	0
xl.Range("O:O").NumberFormat :=	"yyyymmdd""000000"""
xl.screenUpdating :=	1

Remember that once you do this conversion you'll have to extract the timestamp from the cells using the Text property, not the Value property.

Well that's much easier to solve.

(Code != "ABC" or Code != "XYZ")

There is literally no value for Code which will cause this statement to evaluate as true. Perhaps you meant to evaluate with and?

(Code != "ABC" and Code != "XYZ")

I copied and ran your code as is, I got i'm an error.

I don't have the ability to build a testable script for this at the moment, but here are a couple of good starting points:

How to detect a double-click ??
Explorer: get name of file under cursor

Code: Select all

Clipboard =
Send ^ x	; cut a value from a given cell
Clipboard +=	8	; add 8 to that value
Send ^ v	; Paste the new value

Character count: t=This isn't a test. MsgBox % StrLen(t) Character count excluding spaces (this does not include `r`n or other vertical whiteapce): t=This isn't a test. MsgBox % StrLen(StrReplace(t," ")) Word count: t=This isn't a test. This is just an exercise. Promise. RegExReplace(t,"\b[\w\-\']+\...

Do you know the actual name of the button from that list?

What locale are you in, exactly? In the US, DST typically starts on the second Sunday in March and ends on the first Sunday in November, it sounds like your rules for DST fall outside of that.

If you run WinGet while the window is open, does it produce the control list?

Code: Select all

WinGet, cList, ControlList, Windows Security Alert
MsgBox %	cList

Are you able to obtain a handle for the control when the window exists?

Code: Select all

ControlGet, hWnd, hWnd, , &Allow Access, Windows Security Alert
MsgBox %	hWnd

keys := {"610D0A":"{a down}","410D0A":"{a up}" ,"620D0A":"{s down}","420D0A":"{s up}" ,"630D0A":"{d down}","430D0A":"{d up}" ,"640D0A":"{f down}","440D0A":"{f up}" ,"650D0A":"{g down}","450D0A":"{g up}" ,"660D0A":"{UP down}","460D0A":"{UP up}" ,"670D0A":"{DOWN down}","470D0A":"{DOWN up}" ,"690D0A":...

Code: Select all

str :=	"Wempen,.Faithe.-.No.018.15.-.Office.-.2016.For.Seniors.For.Dummies"
MsgBox %	RegExReplace(str,"\.(?=\D)|(?<=\D)\."," ")

Code: Select all

Array := [1, 0, 2, 3, 0, 4, 0, 0, 0, 5, 0]
For i, v in Array
	out .=	v ","
Array :=	StrSplit(Trim(RegExReplace(out,"\b0,"),","),",")

Search found 520 matches

Re: Need help with keyword search Topic is solved

Re: Coordinates

Re: Coordinates

Re: VBScript.Regex and highlighting text Topic is solved

Re: "Clipboard :=" does not always empty the clipboard immediately Topic is solved

Re: extra "button down" reported by keyhistory

Re: Size of array after stringsplit Topic is solved

Re: FormatTime Issues Topic is solved

Re: If and or statements Topic is solved

Re: If and or statements Topic is solved

Re: How to prevent multiple instances of external application

Re: Clipboard manipulation as a quantity Topic is solved

Re: Simple script to count characters and words in selection

Re: Need help with clicking through Firewall screen

Re: How to manage the FileGetTime & DST problem?

Re: Need help with clicking through Firewall screen

Re: Need help with clicking through Firewall screen

Re: If statements too slow...

Re: Help to replace "." (dots) with " " (space) in a string Topic is solved

Re: Efficient way to remove elements from array Topic is solved