Search found 386 matches

by euras
23 May 2019, 07:46
Forum: Ask For Help
Topic: Fastest way to loop through Folders
Replies: 9
Views: 365

Re: Fastest way to loop through Folders

each folder contains some files, maybe the loop scans those files too?
by euras
23 May 2019, 07:19
Forum: Ask For Help
Topic: Fastest way to loop through Folders
Replies: 9
Views: 365

Re: Fastest way to loop through Folders

the same 16 minutes with the empty loop :/
by euras
23 May 2019, 06:14
Forum: Ask For Help
Topic: Fastest way to loop through Folders
Replies: 9
Views: 365

Re: Fastest way to loop through Folders

It have reduced performance time from 40 min to 16 min. Pretty good, but maybe it's possible to make it even faster?
by euras
23 May 2019, 04:23
Forum: Ask For Help
Topic: Fastest way to loop through Folders
Replies: 9
Views: 365

Fastest way to loop through Folders

Hi, does anyone knows a faster way to loop through the folders / subfolders? I loop folders / subfolders in a local drive. There is about 4500 folders / subfolders. I gather each folder / subfolder path and write it in .txt file. To perform it using the method bellow, it takes 40 minutes. I think th...
by euras
08 May 2019, 02:01
Forum: Ask For Help
Topic: String ignoring some character
Replies: 1
Views: 125

String ignoring some character

Hi, is it possible to pass statements on the string, ignoring some part of the string? string := " Name of custody accountCustody accountMarket Value in DKKType of custody account" if (string = " Name of custody accountCustody accountMarket Value in ***Type of custody account") ; I want to exclude D...
by euras
07 May 2019, 04:36
Forum: Ask For Help
Topic: the example of AHK Command source code Topic is solved
Replies: 2
Views: 216

the example of AHK Command source code Topic is solved

Hi,
I'm curious how the source code of the commands in AHK looks like. Maybe someone has an example?
I.e. we use the syntax

Code: Select all

Send, this is a text
, but what is behind that Send?
by euras
24 Apr 2019, 02:20
Forum: Ask For Help
Topic: Replace string in .txt Topic is solved
Replies: 8
Views: 451

Re: Replace string in .txt Topic is solved

it works fine and surprisingly completed 30MB file per 1.3 seconds. Thank you!
by euras
23 Apr 2019, 00:27
Forum: Ask For Help
Topic: Replace string in .txt Topic is solved
Replies: 8
Views: 451

Re: Replace string in .txt Topic is solved

Just change your MsgBox line to be the following NewData := StrReplace(A_LoopReadLine, "Replace", "With") FileAppend, %NewData% Since when in a Loop read fileappend works differently. And also since Loop read is faster than taking all the contents then replacing the file this should be the fastest ...
by euras
19 Apr 2019, 07:51
Forum: Ask For Help
Topic: Replace string in .txt Topic is solved
Replies: 8
Views: 451

Replace string in .txt Topic is solved

Hi, is there a faster way to replace the strings in .txt file using maybe DLL calls? My file is 30MB and there are thousands of lines in it. Sometimes I need to get a specific string in the file and replace it with the other string. I can do it in the .txt file using Replace option, but is it possib...
by euras
18 Apr 2019, 00:18
Forum: Ask For Help
Topic: Excel pasting data Topic is solved
Replies: 2
Views: 166

Excel pasting data Topic is solved

Hi, I got an issue. Somethimes, when you copy paste a table from a source to a excel, it keeps the column order and paste the data in separate columns. the spearator in the clipboard is ; . When you send a info into Excel via FileAppend, using ; separator, it also separates the columns. But when I c...
by euras
15 Apr 2019, 02:09
Forum: Ask For Help
Topic: Array sorting Topic is solved
Replies: 2
Views: 211

Array sorting Topic is solved

Hi, is it possible to sort Array in the key order how they was created, instead of alphabetical sorting, which looks like going automaticaly?

Code: Select all

temp_Array := {"Yellow":"first item", "Black":"Second item", "Green":"Third item"}
for w,e in temp_Array
	Msgbox % w " and " e
by euras
02 Apr 2019, 00:56
Forum: Ask For Help
Topic: Get current Date format
Replies: 4
Views: 286

Get current Date format

is it possible to get the current date format which is used on computer?
lets say my computer uses yyyy-MM-dd format. But other computer can have dd-MM-yyyy format and so on. I want to check what kind of date format that computer uses before proceed further. Is it possible to do that with autohotkey?
by euras
27 Mar 2019, 06:13
Forum: Ask For Help
Topic: Excel Workbook name
Replies: 1
Views: 154

Excel Workbook name

is it possible to set a workbook name by creating it but not by saving it?

Code: Select all

Xl := ComObjCreate("Excel.Application") ;handle
Xl.Visible := True ;by default excel sheets are invisible
Xl.Workbooks.Add() ;add a new workbook
Xl.Workbook(1).Name := "My New Name" ; doesn't work
by euras
26 Mar 2019, 00:50
Forum: Ask For Help
Topic: Run .mac files with AHK
Replies: 3
Views: 284

Re: Run .mac files with AHK

I have tried that class and it works for simple VBScript, but if I try to put into the code what I got from macro recorder from Green Screen, I get an error message that autECLSession variable is undefined. What do I wrong? I quess there is some problem with connection to the Green Screen. vb := new...
by euras
25 Mar 2019, 10:51
Forum: Ask For Help
Topic: Run .mac files with AHK
Replies: 3
Views: 284

Run .mac files with AHK

is it possible to call "green screen" macros with autohotkey? My AHK is 64bit, so it doesn't support ScriptControl oSC := ComObjCreate("ScriptControl") oSC.Language := "VBScript" oSC.Timeout := -1 ;removes the timeout ahkvariable := 2 code = ( ;your vbscript variable = %ahkvariable% ) oSC.ExecuteSta...
by euras
20 Mar 2019, 09:22
Forum: Ask For Help
Topic: Check the Drive status
Replies: 1
Views: 168

Check the Drive status

Hi, I want to check if the path to some drive is accessable or not. To reach the path, you need to have access to. What I have tried, it gives me the same status Ready or OK to both path, but actually I cannot access to the 1st path. Is it a way to check the accesability without opening the path eac...
by euras
19 Mar 2019, 12:16
Forum: Ask For Help
Topic: A_LastError meaning
Replies: 5
Views: 323

Re: A_LastError meaning

I just wrote a function, which checks path length and reduce file name if the length did not pass the limit. The path cannot be changed, so the only option is to reduce the file name.
by euras
19 Mar 2019, 06:40
Forum: Ask For Help
Topic: A_LastError meaning
Replies: 5
Views: 323

Re: A_LastError meaning

the problem was that the whole path was too long.
by euras
18 Mar 2019, 01:32
Forum: Ask For Help
Topic: A_LastError meaning
Replies: 5
Views: 323

A_LastError meaning

Hi, I'm trying to save Outlook Email into C drive, but some emails do not transfers, and I get A_LastError result -2147352567 I cannot find the meaning of this error in msdn. Can someone help me to understand how to check what kind of error it is? new_item := ComObjActive("Outlook.Application").Acti...
by euras
05 Mar 2019, 05:00
Forum: Ask For Help
Topic: WinExist() bug?
Replies: 2
Views: 227

WinExist() bug?

Hi, is it a bug in WinExist() function? I try to create a script, which checks if the window appears during the run, except a couple of type windows. But the function gives me TRUE value, despite I add Exclude titles on both functions. It should return me a False value, but it doesn't work. The clas...

Go to advanced search