Search found 45 matches
- 09 Dec 2016, 05:20
- Forum: 脚本函数
- Topic: ListView数据或数组生成Excel
- Replies: 13
- Views: 19467
Re: ListView数据或数组生成Excel
Powerful :roll: thank you very much :) with two listview or more use: #Include, <CLASS_LV_COLORS> #Include, <CLASS_EXCEL> Gui, Add, ListView, x5 y5 w200 r10 vCTRL_LV1 hwndHLV1, aaaaaaa|bbbbbbb|cccccc|dddddd Loop, 5 LV_Add("", "Col1" A_Index, "Col2" A_Index, "Col3" A_Index, "Col4" A_Index) CLV1 := Ne...
- 08 Dec 2016, 14:22
- Forum: 脚本函数
- Topic: ListView数据或数组生成Excel
- Replies: 13
- Views: 19467
Re: ListView数据或数组生成Excel
work with LV_Colors.Cell() and LV_Colors.Row()
Can you add LV_Colors.AlternateRows() and LV_Colors.AlternateCols() And Title column of Gui ListView.
I think your script will be complete.
Thank you.
Can you add LV_Colors.AlternateRows() and LV_Colors.AlternateCols() And Title column of Gui ListView.
I think your script will be complete.
Thank you.
- 08 Dec 2016, 10:14
- Forum: 脚本函数
- Topic: ListView数据或数组生成Excel
- Replies: 13
- Views: 19467
Re: ListView数据或数组生成Excel
Omg. good job
- 07 Dec 2016, 23:41
- Forum: 脚本函数
- Topic: ListView数据或数组生成Excel
- Replies: 13
- Views: 19467
Re: ListView数据或数组生成Excel
Thank for reply
I will look at how to add color in excel file.
I will look at how to add color in excel file.
- 07 Dec 2016, 23:10
- Forum: 脚本函数
- Topic: ListView数据或数组生成Excel
- Replies: 13
- Views: 19467
Re: ListView数据或数组生成Excel
This work with [Class] LV_Colors ?
- 03 Nov 2016, 15:50
- Forum: Scripts and Functions (v1)
- Topic: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
- Replies: 43
- Views: 94700
Re: [Func] ADOSQL - wraps ADO for executing SQL queries (AHK-L)
Hi, I use <CLASS_ADOSQL> with MSSQL this work. Now, I would like use with MS Access. This is my script: #SINGLEINSTANCE FORCE F1:: TEST_SERVER := "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\xxxxxxx\Desktop\db\db.accdb" TEST_DATABASE := "tsaisie" TEST_REQUEST := "SELECT * FROM " . TEST_DA...
- 26 Oct 2016, 21:20
- Forum: Ask for Help (v1)
- Topic: [REQUEST] SplashTextOn/Off if script use
- Replies: 3
- Views: 1938
Re: [REQUEST] SplashTextOn/Off if script use
i have a script with GoTo and GoSub.
I wish show SplashTextOn during all the action.
a label may be use by another goto or gosub.
I do not if this is possible.
Can be OnMessage
I wish show SplashTextOn during all the action.
a label may be use by another goto or gosub.
I do not if this is possible.
Can be OnMessage
- 26 Oct 2016, 19:01
- Forum: Ask for Help (v1)
- Topic: [REQUEST] SplashTextOn/Off if script use
- Replies: 3
- Views: 1938
[REQUEST] SplashTextOn/Off if script use
Hello,
it is possible to display [SplashTextOn] if the script is in use (thread)
and [SplashTextOff] if the script is not use (thread).
Exemple:
it is possible to display [SplashTextOn] if the script is in use (thread)
and [SplashTextOff] if the script is not use (thread).
Exemple:
Thank youIf i run this script:
a SplashTextOn/Off appears and disappears automatically.Code: Select all
F1:: Sleep 10000 Return
- 26 Jun 2016, 15:56
- Forum: Ask for Help (v1)
- Topic: Gui ActiveX HTML + JS.
- Replies: 4
- Views: 2574
Re: Gui ActiveX HTML + JS.
Hi,
If i use:
No ScrollBar
And if i use:
ScrollBar ?
If i use:
Code: Select all
Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell Explorer
And if i use:
Code: Select all
Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell.Explorer
- 23 Jun 2016, 19:39
- Forum: Ask for Help (v1)
- Topic: Gui ActiveX HTML + JS.
- Replies: 4
- Views: 2574
Gui ActiveX HTML + JS.
Hello, I would include a js file in a GUI (ActiveX) But I get a blank page. With the html file this work. why it does not work? #SingleInstance Force Gui HTML: Add, ActiveX, x0 y0 w800 h600 vHTML_COM, Shell Explorer HTML_COM.Navigate("about:blank") GoSub, HTML_SRC HTML_COM.document.write(HTML_SRC) ;...
- 18 Jun 2016, 19:24
- Forum: Ask for Help (v1)
- Topic: [SOLVED] delete specific character in first left in var
- Replies: 4
- Views: 1374
Re: [SOLVED] delete specific character in first left in var
Just like that !
it is possible to add a condition ?
Ex:
00000080 get 080
0080 get 080
it is possible to add a condition ?
Ex:
00000080 get 080
0080 get 080
- 18 Jun 2016, 19:19
- Forum: Ask for Help (v1)
- Topic: [SOLVED] delete specific character in first left in var
- Replies: 4
- Views: 1374
Re: delete specific character in first left in var
Thank you working !Capn Odin wrote:Are you saying you want to remove all leading zeros from numbers and only the first char from strings ?
Edit: If so try this.Code: Select all
var := "00080" RegExMatch(var, RegExMatch(var, "^\d*$") ? "([1-9]\d+$)" : "((?<=\w)\w+$)", res) MsgBox, % res
- 18 Jun 2016, 19:18
- Forum: Ask for Help (v1)
- Topic: Help - Perform action according to criteria
- Replies: 4
- Views: 1458
Re: Help - Perform action according to criteria
upperLeftX := 75 upperLeftY := 80 lowerRightX := 200 lowerRightY := 200 Loop, 2 { Sleep, 1000 PixelSearch, Px, Py, %upperLeftX%, %upperLeftY%, %lowerRightX%, %lowerRightY%, 0x00FF00, 3, fast if ErrorLevel MsgBox, That color was not found in the specified region. else MsgBox, A color within 3 shades...
- 18 Jun 2016, 18:19
- Forum: Ask for Help (v1)
- Topic: Help - Perform action according to criteria
- Replies: 4
- Views: 1458
- 18 Jun 2016, 18:00
- Forum: Ask for Help (v1)
- Topic: [SOLVED] delete specific character in first left in var
- Replies: 4
- Views: 1374
[SOLVED] delete specific character in first left in var
Hello,
How to deleting a specific character in first left ?
Ex:
I tried : StringReplace
But this delete all character :/
Thank for your help
How to deleting a specific character in first left ?
Ex:
Code: Select all
080 get 80
Or
008 get 8
Or
ABA get BA
But this delete all character :/
Thank for your help
- 27 May 2016, 16:01
- Forum: Ask for Help (v1)
- Topic: Gui datetime control
- Replies: 8
- Views: 2595
Re: Gui datetime control
Thank Shadowpheonix this work by key. but i want to use checkbox. This work. I can disable, but I can not enable. PRIMARY_GUI_EVENT: If A_GUIEVENT = NORMAL { If (A_GUICONTROL = "FIELD_GUI_DATE_START" or "FIELD_GUI_TIME_START" or "FIELD_GUI_DATE_END" or "FIELD_GUI_TIME_END") { GuiControlGet, CheckBox...
- 26 May 2016, 13:44
- Forum: Ask for Help (v1)
- Topic: Gui datetime control
- Replies: 8
- Views: 2595
Re: Gui datetime control
This is my code: I need enable or disable all gui datetime on primary_gui if checked #SINGLEINSTANCE FORCE #PERSISTENT ;#NOTRAYICON SETBATCHLINES -1 APPLICATION_NAME := "APPS" APPLICATION_COPYRIGHT := "" GLOBAL_FORMAT_DATE = yyyyddMM GLOBAL_FORMAT_TIME = HHmmss GLOBAL_BARCODE_LENGTH := "8" GLOBAL_IQ...
- 26 May 2016, 11:50
- Forum: Ask for Help (v1)
- Topic: Gui datetime control
- Replies: 8
- Views: 2595
Re: Gui datetime control
I need Enable all gui DateTime or Disable all. I need only code for enable or disable gui DateTime. i found this exemple but not work with datetime checkbox: #SingleInstance, force ; Press F2 to enable/disable the DateTime control Gui, Add, DateTime, vMyDateTime, LongDate Gui, show return GuiClose: ...
- 26 May 2016, 09:27
- Forum: Ask for Help (v1)
- Topic: Gui datetime control
- Replies: 8
- Views: 2595
Gui datetime control
Hi, How to gui control DateTime for enable or disable by default is disable: - vFIELD_GUI_DATE_START - vFIELD_GUI_TIME_START - vFIELD_GUI_DATE_END - vFIELD_GUI_TIME_END ... Gui 1: Add, DateTime, x145 y20 h23 w120 vFIELD_GUI_DATE_START gPRIMARY_GUI_EVENT BackgroundTrans CHOOSENONE, %GLOBAL_FORMAT_DAT...
- 03 May 2016, 11:48
- Forum: Ask for Help (v1)
- Topic: Format time with concatenation.
- Replies: 2
- Views: 1074
Format time with concatenation.
Hi, i use this code for add or remove time with EnvAdd But the time format is not good in msgbox. I need only HH:mm:ss FormatTime TIME_NOW_1 += -3, Hours TIME_NOW_2 += -2, Hours TIME_NOW_3 += -1, Hours TIME_NOW_4 += 0, Hours TIME_NOW_5 += +1, Hours TIME_NOW_6 += +2, Hours TIME_NOW_7 += +3, Hours Loo...