Search found 500 matches

by sinkfaze
10 Apr 2019, 08:12
Forum: Ask For Help
Topic: Need help with keyword search
Replies: 6
Views: 159

Re: Need help with keyword search

Scr1pter wrote:
10 Apr 2019, 07:12
What happened to the topic title?
I never saw one. I have now added one.
by sinkfaze
08 Apr 2019, 11:33
Forum: Ask For Help
Topic: Coordinates
Replies: 11
Views: 314

Re: Coordinates

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...
by sinkfaze
08 Apr 2019, 10:26
Forum: Ask For Help
Topic: Coordinates
Replies: 11
Views: 314

Re: Coordinates

What is your script trying to do?
by sinkfaze
05 Apr 2019, 14:51
Forum: Ask For Help
Topic: VBScript.Regex and highlighting text Topic is solved
Replies: 4
Views: 174

Re: VBScript.Regex and highlighting text Topic is solved

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.
by sinkfaze
05 Apr 2019, 14:07
Forum: Ask For Help
Topic: "Clipboard :=" does not always empty the clipboard immediately Topic is solved
Replies: 33
Views: 919

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

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
by sinkfaze
04 Apr 2019, 15:39
Forum: Ask For Help
Topic: extra "button down" reported by keyhistory
Replies: 2
Views: 113

Re: extra "button down" reported by keyhistory

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.
by sinkfaze
04 Apr 2019, 10:25
Forum: Ask For Help
Topic: Size of array after stringsplit Topic is solved
Replies: 6
Views: 243

Re: Size of array after stringsplit Topic is solved

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, ...
by sinkfaze
03 Apr 2019, 10:41
Forum: Ask For Help
Topic: FormatTime Issues Topic is solved
Replies: 5
Views: 261

Re: FormatTime Issues Topic is solved

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.
by sinkfaze
02 Apr 2019, 13:57
Forum: Ask For Help
Topic: If and or statements Topic is solved
Replies: 4
Views: 114

Re: If and or statements Topic is solved

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")
by sinkfaze
02 Apr 2019, 13:48
Forum: Ask For Help
Topic: If and or statements Topic is solved
Replies: 4
Views: 114

Re: If and or statements Topic is solved

I copied and ran your code as is, I got i'm an error.
by sinkfaze
02 Apr 2019, 10:28
Forum: Ask For Help
Topic: How to prevent multiple instances of external application
Replies: 4
Views: 131

Re: How to prevent multiple instances of external application

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
by sinkfaze
02 Apr 2019, 08:38
Forum: Ask For Help
Topic: Clipboard manipulation as a quantity Topic is solved
Replies: 2
Views: 99

Re: Clipboard manipulation as a quantity Topic is solved

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
by sinkfaze
02 Apr 2019, 08:26
Forum: Ask For Help
Topic: Simple script to count characters and words in selection
Replies: 2
Views: 178

Re: Simple script to count characters and words in selection

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\-\']+\...
by sinkfaze
01 Apr 2019, 14:24
Forum: Ask For Help
Topic: Need help with clicking through Firewall screen
Replies: 7
Views: 258

Re: Need help with clicking through Firewall screen

Do you know the actual name of the button from that list?
by sinkfaze
01 Apr 2019, 10:21
Forum: Ask For Help
Topic: How to manage the FileGetTime & DST problem?
Replies: 3
Views: 149

Re: How to manage the FileGetTime & DST problem?

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.
by sinkfaze
01 Apr 2019, 09:21
Forum: Ask For Help
Topic: Need help with clicking through Firewall screen
Replies: 7
Views: 258

Re: Need help with clicking through Firewall screen

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
by sinkfaze
01 Apr 2019, 09:14
Forum: Ask For Help
Topic: Need help with clicking through Firewall screen
Replies: 7
Views: 258

Re: Need help with clicking through Firewall screen

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
by sinkfaze
01 Apr 2019, 09:01
Forum: Ask For Help
Topic: If statements too slow...
Replies: 27
Views: 658

Re: If statements too slow...

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":...
by sinkfaze
01 Apr 2019, 08:38
Forum: Ask For Help
Topic: Help to replace "." (dots) with " " (space) in a string Topic is solved
Replies: 6
Views: 220

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

Code: Select all

str :=	"Wempen,.Faithe.-.No.018.15.-.Office.-.2016.For.Seniors.For.Dummies"
MsgBox %	RegExReplace(str,"\.(?=\D)|(?<=\D)\."," ")
by sinkfaze
29 Mar 2019, 13:35
Forum: Ask For Help
Topic: Efficient way to remove elements from array Topic is solved
Replies: 13
Views: 431

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

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,"),","),",")
:?:

Go to advanced search