Search found 517 matches

by sinkfaze
05 Apr 2019, 14:51
Forum: Ask For Help
Topic: VBScript.Regex and highlighting text Topic is solved
Replies: 4
Views: 505

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: 3451

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: 325

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: 638

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: 704

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: 422

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: 422

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: 343

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: 319

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: 623

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: 695

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: 406

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: 695

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: 695

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: 1867

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: 659

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: 1367

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,"),","),",")
:?:
by sinkfaze
28 Mar 2019, 15:41
Forum: Ask For Help
Topic: How can I display an array with an Input or MsgBox? Topic is solved
Replies: 10
Views: 1313

Re: How can I display an array with an Input or MsgBox? Topic is solved

Your ugly code can be simplified:

Code: Select all

Loop, 25
{
	i :=	A_Index-1	; set var instance number
	FileReadLine, Message%i%, %Filename%, %LineNum%
	LineNum += 5
}
by sinkfaze
28 Mar 2019, 11:34
Forum: Ask For Help
Topic: Paste variables in a repeated cell pattern in Excel Topic is solved
Replies: 11
Views: 896

Re: Paste variables in a repeated cell pattern in Excel Topic is solved

Code: Select all

xl :=	ComObjActive("Excel.Application")
xl.Range("A1:E3").Value :=	1
:?:
by sinkfaze
28 Mar 2019, 08:25
Forum: Ask For Help
Topic: What am I doing wrong here ? Variable is empty
Replies: 14
Views: 945

Re: What am I doing wrong here ? Variable is empty

V: Variable. Associates a variable with a control. Immediately after the letter V, specify the name of a global variable (or a ByRef local that points to a global, or [in v1.0.46.01+] a static variable). For example, specifying vMyEdit would store the control's contents in the variable MyEdit whene...

Go to advanced search