Search found 112 matches

by ivill
18 Jan 2019, 01:51
Forum: Ask For Help
Topic: Excel sum cells to an established number
Replies: 4
Views: 549

Excel sum cells to an established number

Hi all, For example, The established number is 500000(maybe i shall create an input box), how to use COMobjExcel way to pick the right cells in column A which can get the sum result 500000? as the attachment image shown, there are two or more answers, the yellow and blue background colored cells, si...
by ivill
24 Dec 2018, 04:23
Forum: Scripts and Functions
Topic: Class Monitor (Brightness, ColorTemperature)
Replies: 44
Views: 18412

Re: Class Monitor (Brightness, ColorTemperature)

Hi, Since the latest Windows 10 preview build 18305.rs_prerelease.181213-2133 installed, the script no longer works, anyone else who have the same issue?
by ivill
11 Apr 2018, 00:07
Forum: Scripts and Functions
Topic: FindText - Capture screen image into text and then find it Topic is solved
Replies: 346
Views: 91912

Re: FindText - Capture screen image into text and then find it Topic is solved

Hi, FeiYue, i have a question, your script works great, except the different displayer issue, can you maybe make a fuzzy match setting at the next update? here is my issue: the same image/text to find on different displayer will not work as the same, let's say i captured this on PC1: __00000________...
by ivill
05 Mar 2018, 22:34
Forum: Ask For Help
Topic: Numberic date convertion improval?
Replies: 2
Views: 436

Numberic date convertion improval?

Hi, I use the following script to convert numberic date to format year . month . date but sometimes it's not stable...not work for all possible existing format, anyway i didn't found smilar script in our forum, is there any simple and stable way to convert date like this? thanks! 20180306112449.png ...
by ivill
27 Feb 2018, 03:23
Forum: Ask For Help
Topic: LV_GetText without a ListView/GUI
Replies: 6
Views: 828

Re: LV_GetText without a ListView/GUI

First, your Msgbox is wrong, should be: MsgBox % R[1] "`n" R[2] "`n" R[3] "`n" R[4] "`n" R[5] Second, after 107 posts you're asking how to populate a variable with another variable contents ? Strange. Anyway: blablabla := R[1] ccccccc := R[2] agfhasgsf := R[3] another1 := R[4] thelast := R[5] You k...
by ivill
27 Feb 2018, 03:01
Forum: Ask For Help
Topic: LV_GetText without a ListView/GUI
Replies: 6
Views: 828

Re: LV_GetText without a ListView/GUI

Yes, replace with this: UDR := 1 ; Maximum Results ;... ;... ;... str:="" For I, R In Results str .= R[1] "`n" R[2] "`n" R[3] "`n" R[4] "`n" R[5] MsgBox %str% return How to call the R[1]-R[5], in order to use them later (not just the example MsgBox %str% ) str:="" For I, R In Results MsgBox, %R[1]%...
by ivill
26 Feb 2018, 19:07
Forum: Ask For Help
Topic: LV_GetText without a ListView/GUI
Replies: 6
Views: 828

Re: LV_GetText without a ListView/GUI

Like this ? #NoEnv SetBatchLines, -1 ; Constant multipliers P1 := 7.25 P2 := 6.53 P3 := 6.16 P4 := 5.43 Amount := 30000 MinD := 10 ; Minimum Deviation MaxD := 50 ; Maximum Deviation UDR := 15 ; Maximum Results UDD := 3 ; Maximum Delta ( 1 to 5 ) UDI := 3 ; Maximum Iterations (1 to 3 ) gosub Calcula...
by ivill
26 Feb 2018, 04:05
Forum: Ask For Help
Topic: LV_GetText without a ListView/GUI
Replies: 6
Views: 828

LV_GetText without a ListView/GUI

Hi, everyone, This script works very well for me, Thanks for @just me's help, but i just got an idea and meet a challenge, can't accomplish it by myself: How can i make the script works without a GUI, use a preset conditions and vAmount(for example 30000) to calculate then instant get the results Ms...
by ivill
26 Feb 2018, 04:00
Forum: Ask For Help
Topic: Split specified number into parts and sum Topic is solved
Replies: 17
Views: 2320

Re: Split specified number into parts and sum Topic is solved

Well, I added a g-Label for the ListView. You can select a result by double click. #NoEnv SetBatchLines, -1 ; Constant multipliers ----------------------------------------------------------------------------------------------------------- P1 := 7.25 P2 := 6.53 P3 := 6.16 P4 := 5.43 ; GUI ----------...
by ivill
02 Feb 2018, 01:41
Forum: Ask For Help
Topic: Store multiple values then invoke them 1by1
Replies: 5
Views: 814

Re: Store multiple values then invoke them 1by1

You can put them in an array like I did in my example Entries.Push([var1, var2, var3]) and loop through them for i, v in Entries { GenerateWorkBook(v[1], v[2], v[3]) } Hi, Capn Odin, this is an script example i'm using now, i want the values (DDL, M1, NTOW, IncrementalSearch) stored and ready for u...
by ivill
01 Feb 2018, 09:41
Forum: Ask For Help
Topic: Store multiple values then invoke them 1by1
Replies: 5
Views: 814

Re: Store multiple values then invoke them 1by1

Entries := [] Gui, 1:New, +Resize, Example Gui, Margin, 0, 0 Gui, Add, Edit, vED Gui, Add, Button, ys gAdd, Add text Gui, Add, Edit, xs vText ReadOnly Multi Gui, Add, Button, xs gWorkbooks, Make workbooks Gui, Show, AutoSize GuiControlGet, BPos, Pos, Button1 return GuiClose: ExitApp return GuiSize:...
by ivill
01 Feb 2018, 06:01
Forum: Scripts and Functions
Topic: FindText - Capture screen image into text and then find it Topic is solved
Replies: 346
Views: 91912

Re: FindText - Capture screen image into text and then find it Topic is solved

大神你好,打扰了,请问你的薇信多少,我有个很简单的脚本问题想请教一下您,方便的话可以加下我吗ivill66
by ivill
01 Feb 2018, 03:05
Forum: Ask For Help
Topic: Store multiple values then invoke them 1by1
Replies: 5
Views: 814

Store multiple values then invoke them 1by1

Hi, i'm currently updating a script to make it better it's a GUI i should fill some text in(e.g date, number etc) while it's completed, it will create a new workbook, then fill&save&exit > Reload the GUI and do the same job(with different values) the orginal function is like this: enter the values1(...
by ivill
24 Oct 2017, 19:10
Forum: Ask For Help
Topic: pre-set a password in "LockUp" script Topic is solved
Replies: 1
Views: 471

Re: pre-set a password in "LockUp" script Topic is solved

:oops: :D :?:

Edit:i found it's quite simple to remove the pw part
by ivill
23 Oct 2017, 22:25
Forum: Ask For Help
Topic: pre-set a password in "LockUp" script Topic is solved
Replies: 1
Views: 471

pre-set a password in "LockUp" script Topic is solved

Since the forum is archieved, i came here to ask for help, i just found the script very useful while you can make a script keep running in the background with a black screen covered, but here is a thing, how do i make a pre-set password, so that i don't need to enter a pw by manually each time i run...
by ivill
05 Oct 2017, 19:47
Forum: Ask For Help
Topic: StringGetPos - numerical input limiter
Replies: 17
Views: 2264

Re: StringGetPos - numerical input limiter

unfortunatly there's a bug, in my case, it will returns empty result if put a non-existing date (i.e 0229, 0230, 0231, 0431, 0631, 0931, 1131) , as you see, a basic date time rule is needed... Not 100% sure I understand what you mean as I return those dates. Before the fix: https://imgur.com/Fle61G...
by ivill
04 Oct 2017, 20:21
Forum: Ask For Help
Topic: StringGetPos - numerical input limiter
Replies: 17
Views: 2264

Re: StringGetPos - numerical input limiter

Sorry for the delay very busy... Gui, Add, Edit, w200 gLimit vStart Limit4 Number, Gui, Show, AutoSize, Limit Test return LIMIT: Gui, Submit, NoHide if RegExMatch( START, "^(?<dd>01|0[1-9]|1[0-2])(?<MM>01|0[1-9]|[1-2][0-9]|3[0-1])?$", _ ) { if StrLen( START ) = 4 { Msgbox % "dd: " _dd " MM: " _MM ;...
by ivill
04 Oct 2017, 19:31
Forum: Ask For Help
Topic: StringGetPos - numerical input limiter
Replies: 17
Views: 2264

Re: StringGetPos - numerical input limiter

Sorry for the delay very busy... Gui, Add, Edit, w200 gLimit vStart Limit4 Number, Gui, Show, AutoSize, Limit Test return LIMIT: Gui, Submit, NoHide if RegExMatch( START, "^(?<dd>01|0[1-9]|1[0-2])(?<MM>01|0[1-9]|[1-2][0-9]|3[0-1])?$", _ ) { if StrLen( START ) = 4 { Msgbox % "dd: " _dd " MM: " _MM ;...
by ivill
29 Sep 2017, 19:20
Forum: Ask For Help
Topic: StringGetPos - numerical input limiter
Replies: 17
Views: 2264

Re: StringGetPos - numerical input limiter

hrm curious, have you tried the DateTime Gui Control?? For instance Gui, Add, DateTime, Choose20170101 1 vMonthDay, MMdd Gui, Add, Button, gGetDate, Get Date Gui, Show, AutoSize, Limit Test return GetDate: Gui, Submit, NoHide FormatTime, Day, % MonthDay, dd FormatTime, Month, % MonthDay, MM msgbox ...
by ivill
28 Sep 2017, 19:04
Forum: Ask For Help
Topic: StringGetPos - numerical input limiter
Replies: 17
Views: 2264

Re: StringGetPos - numerical input limiter

...is it possible to seprate the input fileld to 2 parts, part1 will check if input is correct(01-12) i.e months, allow the part2 to input(01-31) i.e days after the part1? Do you want it to check as the numbers are being entered of after the entire field is complete? Yes, the field is only to allow...

Go to advanced search