AutoHotkey Community

hd0202

dates can only be usefully compared as yyyy.MM.dd Path = %A_Desktop%/*.xlsx Xl := ComObjCreate("Excel.Application") Xl.Workbooks.Open(Path) ;выбрать файл для проверки Xl.Visible := True loop 100 { ; FormatTime, TimeString, 20171020, dd.MM.yyyy var := Xl.cells(A_Index + 1,7).value formattime, var_ymd...

hd0202

ich denke, das sollten einzelne Einträge sein: ; Syntax: IniWrite, Wert, Dateiname, Sektion, Key IniWrite, %AktSign%, %IniDatei%, Einstellungen, AktSign IniWrite, %Sektname%, %IniDatei%, Einstellungen, Sektname IniWrite, %StellenSign%, %IniDatei%, Einstellungen, StellenSign IniWrite, %StellenIndex%,...

hd0202

in AutoHotkey: FileRemoveDir
in Windows Batch: RMDIR

Hubert

hd0202

here is my version: WordListFile := A_ScriptDir . "\Keywords.txt" ;path of the wordlist file ; loop, Read, %WordListFile% ; { ; Loop, parse, A_LoopReadLine, %A_Tab% ; { ; A_LoopField ; } ; } fileread, searches, %WordListFile% ; keywords in separate lines /* search1 search2 */ WinPath:= "MyDocuments"...

hd0202

Code: Select all

; while start <= amount
loop, % amount

Hubert

hd0202

Code: Select all

return

Hubert

hd0202

try option "AltSubmit" in Gui, Add, Listview

Hubert

hd0202

I cannot find any problem in "original". you should display the clipboard at the end not at the beginning. And you must change the clipboard with ^c during the run. following is my shortened correction for "gui": #singleinstance, force gui, show, w300 h150, lol gui, add, edit, r1 ventry x20 y20 w200...

hd0202

MsgBox, 4, , Would you like to run TeamViewer?,30 ; run teamViewer aotomatically after 30 seconds IfMsgBox Timeout run, C:\Program Files (x86)\TeamViewer\TeamViewer.exe else IfMsgBox yes { run, C:\Program Files (x86)\TeamViewer\TeamViewer.exe WinWait, TeamViewer WinMinimize } else IfMsgBox No retur...

hd0202

shure there are more than 6 elements ?
btw, I suggest a much shorter version:

Code: Select all

loop, 15
{
    if (wb.document.GetElementsByTagName("td")[a_index - 1].innertext) = "Online"
        goto Copy%a_index%
}
goto Next

Hubert

hd0202

I think, in the proposed code "I:\Dat\Customer_Folders" is defined as working directory, but it must be part of "dir"

Code: Select all

Run, %comspec% /q /c dir /s /b I:\Dat\Customer_Folders\*.* > C:\Users\Desktop\Projects\print.txt

Hubert

hd0202

welches File soll geändert werden ? Variable F1 ist leer, da FileSelection auskommentiert ist

und soll das Skript dann wirklich gleich ausgeführt werden ?

Hubert

hd0202

this is my solution: CAUTION: the files are replaced by the modified content, therefore use backups ; CAUTION: the files are replaced by the modified content, therefore use backups ; CAUTION: the files are replaced by the modified content, therefore use backups ; CAUTION: the files are replaced by t...

hd0202

write your variable without percent symbols

Code: Select all

... := A_Now
or
... := Case_Number

Hubert

hd0202

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...

hd0202

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...

hd0202

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

hd0202

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

Hubert

hd0202

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

Hubert

hd0202

is there anybody who understands what he is asking ?

Search found 85 matches

Re: AHK: Excel, check data

Re: Optimierung Umbenennungstool

Re: Folder (and file) maintenance

Re: Keywords loop Topic is solved

Re: PinCode Range Check

Re: need help for script Topic is solved

Re: How to get the line number of the currently selected row in the Listview? Topic is solved

Re: have no idea whats wrong can someone help?

Re: error: else with no matching if Topic is solved

Re: if statement problem..please help...

Re: Loop, Files SPEED UP

Re: Suchen und Ersetzen (AHK Version 1.0.48.05) Topic is solved

Re: Search, Copy and Paste Across Files (XML)

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

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

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

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

Re: Decoding Base64 image failed Topic is solved

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

Re: Help is amazing