Search found 72 matches

by hd0202
Today, 06:15
Forum: Ask For Help
Topic: EXE AHK file. Can't write %A_Now% to Excel
Replies: 1
Views: 30

Re: EXE AHK file. Can't write %A_Now% to Excel

write your variable without percent symbols

Code: Select all

... := A_Now
or
... := Case_Number
Hubert
by hd0202
13 Jan 2019, 00:43
Forum: Ask For Help
Topic: Comparing 2 excel Files takes Forever to finish Topic is solved
Replies: 21
Views: 515

Re: Comparing 2 excel Files takes Forever to finish Topic is solved

I found another problem that occurs with every method you try to find the appropriate records: FILEAPPEND it opens and closes the file for every record I have my version changed below to avoid this problem: #Persistent #SingleInstance, Force #NoEnv Menu ,Tray, NoStandard Menu,Tray, Add, Exit, GuiClo...
by hd0202
12 Jan 2019, 12:05
Forum: Ask For Help
Topic: Comparing 2 excel Files takes Forever to finish Topic is solved
Replies: 21
Views: 515

Re: Comparing 2 excel Files takes Forever to finish Topic is solved

here is my version. I read the data from excel2 (38k records) into an AHK array and process it against excel1 (>1 million records): #Persistent #SingleInstance, Force #NoEnv Menu ,Tray, NoStandard Menu,Tray, Add, Exit, GuiClose SetKeyDelay, 30 SetBatchLines -1 ListLines Off SetConTrolDelay, 0 SetWin...
by hd0202
27 Dec 2018, 22:57
Forum: Ich brauche Hilfe
Topic: Text aus Calc-Feld in Variable... Dann 2 Zeilenumbrüche :( Topic is solved
Replies: 11
Views: 260

Re: Text aus Calc-Feld in Variable... Dann 2 Zeilenumbrüche :( Topic is solved

kürze einfach mal die Länge

Code: Select all

user := substr(user, 1, strlen(user) - x)	; wobei du x von 1 bis 4 variierst
Hubert
by hd0202
15 Dec 2018, 12:41
Forum: Ask For Help
Topic: Decoding Base64 image failed Topic is solved
Replies: 8
Views: 255

Re: Decoding Base64 image failed Topic is solved

after dllcall check errorlevel and have a look at the help -> dllcall

Hubert
by hd0202
14 Dec 2018, 09:47
Forum: Ask For Help
Topic: Decoding Base64 image and adding to GUI failed Topic is solved
Replies: 22
Views: 533

Re: Decoding Base64 image and adding to GUI failed Topic is solved

CreateFileA() is for 32-bit systems
CreateFileW() is for 64-bit systems - you seems to have such one

Hubert
by hd0202
14 Dec 2018, 06:58
Forum: Ask For Help
Topic: Help is amazing
Replies: 3
Views: 111

Re: Help is amazing

is there anybody who understands what he is asking ?
by hd0202
14 Dec 2018, 06:54
Forum: Ask For Help
Topic: Decoding Base64 image and adding to GUI failed Topic is solved
Replies: 22
Views: 533

Re: Decoding Base64 image and adding to GUI failed Topic is solved

I think filename must be full qualified path for use in dllcall
and you must use CreateFileW for 64-bit systems

Hubert
by hd0202
14 Dec 2018, 06:48
Forum: Ask For Help
Topic: Decoding Base64 image failed Topic is solved
Replies: 8
Views: 255

Re: Decoding Base64 image failed Topic is solved

here is my version (not tested if input is not multiple of 4): Base64Char := "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/" Base64Index(c) { Global Base64Char return InStr(Base64Char, c, true) - 1 } Base64Decode(str, ByRef var) { Bytes := 1 loop, % strlen(str) / 4 { buffer := sub...
by hd0202
14 Dec 2018, 03:46
Forum: Ask For Help
Topic: Align code lines on = ?
Replies: 4
Views: 158

Re: Align code lines on = ?

here is my version: vars = ; for test only ( width = 100 height = 20 x = 0 y = 0 ) ; vars := clipboard Arr := StrSplit(vars, "`n", "`r") longest := longestLen(Arr) longestLen(Arr) { maxLen := 0 for each, line in Arr { ; RegExMatch(line, ".*(?==)", m_BeforeEquals) ; if ((currLen := StrLen(m_BeforeEqu...
by hd0202
09 Dec 2018, 04:47
Forum: Ich brauche Hilfe
Topic: neue Variablen in einem Loop erzeugen Topic is solved
Replies: 3
Views: 253

Re: neue Variablen in einem Loop erzeugen Topic is solved

Var_1_%A_Index% := clipboard
Var_2_%A_Index% := clipboard
by hd0202
21 Dec 2017, 01:16
Forum: Ich brauche Hilfe
Topic: Zahlen vergleichen
Replies: 17
Views: 1545

Re: Zahlen vergleichen

Du musst die Zufallszahl für den Vergleich eindeutig machen, indem Du sie mit dem Trennzeichen der Liste umgibst: Liste := " " Loop { Random, Zahl , 1, %bereich% ifnotinstring,liste, % " " zahl " " { Liste := Liste Zahl " " GuiControl,, Display, % Liste eintrag += 1 Zahlen%Eintrag% := Zahl } if eint...
by hd0202
06 Jul 2015, 11:42
Forum: Ask For Help
Topic: most efficient way to compare files and remove lines
Replies: 3
Views: 801

Re: most efficient way to compare files and remove lines

My suggestion: file1 = %a_scriptdir%\datafile1.txt file2 = %a_scriptdir%\datafile2.txt file3 = %a_scriptdir%\outfile.txt ; ; generate testfiles data1 = ( 123456 123458 ) filedelete, % file1 fileappend, % data1, % file1 data2 = ( 123456,a,b,c,d 123457,e,f,g,h 123458,i,j,k,l 123459,m,n,o,p ) filedelet...
by hd0202
04 Jul 2015, 04:37
Forum: Ask For Help
Topic: Select Item of TreeView
Replies: 4
Views: 1137

Re: Select Item of TreeView

Serach for "Remote Treeview" in this forum and the other forum "www.autohotkey.com"

Hubert
by hd0202
03 Jul 2015, 09:10
Forum: Ask For Help
Topic: Select Item of TreeView
Replies: 4
Views: 1137

Re: Select Item of TreeView

by hd0202
16 Jun 2015, 23:56
Forum: Ask For Help
Topic: Indirect reference Mod() error
Replies: 5
Views: 920

Re: Indirect reference Mod() error

You must use ":=mod(..." in all three cases --> expression

Hubert
by hd0202
13 Jun 2015, 04:44
Forum: Ask For Help
Topic: Best method for sorting multiple arrays
Replies: 6
Views: 1329

Re: Best method for sorting multiple arrays

Hi, Line 11: defaultColorsArray := {} Is this any different compared to defaultColorsArray := Object() ? No. Line 13: defaultColorsArray[defaultColorsArray_T[A_Index]] := {"X" : colorPickPosition_X[A_Index], "Y" : colorPickPosition_Y[A_Index]} I use an associative array where "color code" is the key...
by hd0202
12 Jun 2015, 03:32
Forum: Ask For Help
Topic: Best method for sorting multiple arrays
Replies: 6
Views: 1329

Re: Best method for sorting multiple arrays

This is my suggestion: ; Select color (MS paint in Windows XP) msPaintSetColorDecimal(r,g,b, colorSameValueHEX:=0x000000) { Static r_last, g_last, b_last Static defaultColorsArray ; Run only first time this function is called. If (!defaultColorsArray.MaxIndex()) { defaultColorsArray_T := [0x000000,0...
by hd0202
10 Jun 2015, 01:15
Forum: Ask For Help
Topic: Best method for sorting multiple arrays
Replies: 6
Views: 1329

Re: Best method for sorting multiple arrays

From your description I get the impression that you use pseudo arrays instead of associative arrays. In the latter you can store all values in one array, you can use the color code as key and have direct access, no shifting or sorting needed.

Hubert
by hd0202
17 May 2015, 09:24
Forum: Ask For Help
Topic: Add Numbers to SubMenu?
Replies: 7
Views: 951

Re: Add Numbers to SubMenu?

This is my suggestion: prevchar = ind = 0 Loop, parse, Clipboard, `n, `r, { StringLeft, FirstChar, A_LoopField, 1 if (firstchar <> prevchar and prevchar <> "") { Menu, Mymenu, Add, %prevchar%%a_space%Submenu, :Submenu%prevchar% ind = 0 } if !firstchar break prevchar := firstchar ind++ CurrentChar :=...

Go to advanced search