Search found 534 matches

by FanaticGuru
Today, 01:01
Forum: Ask For Help
Topic: AHK commands for Excel =MID() & =VALUE() Topic is solved
Replies: 3
Views: 48

Re: AHK commands for Excel =MID() & =VALUE() Topic is solved

Thanks FG. That's really helpful (including the comment re variables). I need to find/create a chart showing equivalent functions because I am far more comfortable with Excel formulas than with AHK. It is best to use AHK functions when possible but if you really need to use an Excel function in AHK...
by FanaticGuru
Yesterday, 17:22
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 10
Views: 314

Re: Reads Excel (xlsx) Fast

ozzii wrote:Doesn't work with xlsm files ;(
It works with xlsm files for me.
Xlsx and Xlsm file structures are very similar. Xlsm just has a few extra files in the Zip but the same folder layout.

FG
by FanaticGuru
Yesterday, 17:11
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 10
Views: 314

Re: Reads Excel (xlsx) Fast

saving-excel-file-data-to-csv Nice try. Though, it is still slower 3 times than mine. Mine is less than 1s. Yours is more than 2s. Always.. Regards. My results are reversed from yours. Below code of yours (with a modified path to my test folder) executes always more than 2 seconds for me. myExcel :...
by FanaticGuru
21 Mar 2017, 12:28
Forum: Ask For Help
Topic: AHK commands for Excel =MID() & =VALUE() Topic is solved
Replies: 3
Views: 48

Re: AHK commands for Excel =MID() & =VALUE() Topic is solved

Code: [Select all]GeSHi © Codebox Plus

X := SubStr("W369A4KM", 2, 3)
MsgBox % X
X := X / 3 + 5
MsgBox % X
There is not really much use for a command like "Value" in AHK. AHK does not have variable types and pretty much treats a variable like a string or a number as needed.

FG
by FanaticGuru
13 Mar 2017, 16:30
Forum: Ask For Help
Topic: program that uses OpenProcess? Topic is solved
Replies: 6
Views: 326

Re: program that uses OpenProcess? Topic is solved

to protect my program I'd like to have a check that detects any program that executes OpenProcess with my PID? I want to prevent that other programs can get a handle to my program easily. What options do I have? (WinAPI and so on) Does my program receive any notification as soon as another program ...
by FanaticGuru
13 Mar 2017, 16:18
Forum: Ask For Help
Topic: Rapid method to share between scripts ?
Replies: 11
Views: 670

Re: Rapid method to share between scripts ?

Take your pick: 0. clipboard and/or hidden Gui This is a link to a hidden Gui solution: https://autohotkey.com/boards/viewtopic.php?t=3275 It is not as technically sophisticated but it is simple and works. It allows you to do GuiVar_Set("Customer","Fanatic Guru') in any s...
by FanaticGuru
11 Mar 2017, 03:58
Forum: Ask For Help
Topic: how to save excel without opening it?
Replies: 6
Views: 396

Re: how to save excel without opening it

tmplinshi wrote:
FanaticGuru wrote:but I imagine you are going to see the Window for a moment before it is closed

I thought so, but I tested and didn't see anything.
I just tested it and for me I see the Workbook for a moment then it closes and then a blank Excel with no workbooks is left open and visible.

FG
by FanaticGuru
11 Mar 2017, 02:50
Forum: Ask For Help
Topic: how to save excel without opening it?
Replies: 6
Views: 396

Re: how to save excel without opening it

FilePath = C:\Book1.xlsx xlBook := ComObjGet(FilePath) xlBook.Application.Windows(xlBook.Name).Visible := True xlBook.ActiveSheet.Range("A1").value := "this text is set by AHK script" xlBook.save xlBook.close That is a round about fix that will sorta work but I imagine you are g...
by FanaticGuru
11 Mar 2017, 02:45
Forum: Ask For Help
Topic: how to save excel without opening it?
Replies: 6
Views: 396

Re: how to save excel without opening it

The idea of working with an Excel file without opening it is an illusion. ComObjGet starts Excel and opens a file as a hidden Workbook. You can go to View/Windows/Unhide and see hidden workbooks. Then when you save it, it is saved as a hidden workbook. Much better to start Excel with ComObjCreate...
by FanaticGuru
10 Mar 2017, 20:16
Forum: Ask For Help
Topic: AHK selecting a save path for my code everytime it runs?
Replies: 1
Views: 436

Re: AHK selecting a save path for my code everytime it runs?

Most Save As dialogs should accept a full path:
Send, C:\Reports\Flash_Report_ElRanchero_

You also might be able to speed your script up by eliminating some of the Sleeps with the various WinWait commands like WinWait, WinWaitActive, WinWaitClose.

FG
by FanaticGuru
10 Mar 2017, 19:59
Forum: Ask For Help
Topic: How to retrieve specific line of an Object (array)?
Replies: 5
Views: 657

Re: How to retrieve specific line of an Object (array)?

friends i converted a range of excel sheet into object (array) by these codes- f1:: xl := ComObjActive("Excel.Application") ab:= xl.range("a1:a10") return now i want to retrieve the value of cell now a4 then what should i add in these codes? i managed to have these codes which p...
by FanaticGuru
10 Mar 2017, 19:27
Forum: Ask For Help
Topic: Starting and closing process Topic is solved
Replies: 34
Views: 2888

Re: Starting and closing process Topic is solved

Code: [Select all]GeSHi © Codebox Plus

Exes =
(
mozilla firefox portable\FirefoxPortable.exe
proxy\proxy soft\proxyCV.exe -f ./proxy/proxy soft/SettingMAIN
)
You only put the subfolders and exe with flags that you to run here. No ,,PID.

FG
by FanaticGuru
10 Mar 2017, 18:23
Forum: Ask For Help
Topic: Starting and closing process Topic is solved
Replies: 34
Views: 2888

Re: Starting and closing process Topic is solved

#Persistent #SingleInstance Exes = ( mozilla firefox portable\FirefoxPortable.exe proxy\proxy soft\proxyCV.exe -f ./proxy/proxy soft/SettingMAIN ) PIDs := {} Loop, Parse, Exes, `n { run, %A_ScriptDir%\%A_LoopField%,,,PID PIDs.Push(PID) } SetTimer, CheckPIDs, 500 CheckPIDs: for index, PID in PIDS { ...
by FanaticGuru
10 Mar 2017, 18:17
Forum: Ask For Help
Topic: Starting and closing process Topic is solved
Replies: 34
Views: 2888

Re: Starting and closing process Topic is solved

FanaticGuru: Maybe I expressed badly :angel: , ABC folder will be moved frequently (To other folders and even USB) So the script must be portable and work with the current folder. I am not sure what current folder means. I imagine you would want A_WorkingDir or A_ScriptDir. If the programs you are ...
by FanaticGuru
10 Mar 2017, 16:17
Forum: Ask For Help
Topic: Starting and closing process Topic is solved
Replies: 34
Views: 2888

Re: Starting and closing process Topic is solved

FanaticGuru: I can not use absolute paths because the files are portable USB run, F:\mozilla firefox portable\FirefoxPortable.exe,,PID run, C:\proxy\proxy soft\proxyCV.exe,,PID -f ./proxy/proxy soft/SettingMAIN The script now assumes a path and does not use %A_WorkingDir% as the path. #Persistent #...
by FanaticGuru
10 Mar 2017, 15:49
Forum: Ask For Help
Topic: How to find multipal letters in a column in ms excel by these codes?
Replies: 5
Views: 512

Re: How to find multipal letters in a column in ms excel by these codes?

Xl := ComObjActive("Excel.Application") if (Xl.Range("B1").Value ~= "p|m") Xl.Range("B1").Select else { R1 := Xl.Columns("B").Find("p").Row R2 := Xl.Columns("B").Find("m").Row Xl.Range("B" Min(R1,R2)).Select }...
by FanaticGuru
10 Mar 2017, 14:06
Forum: Ask For Help
Topic: Using IE.Document.GetElementsByClassname
Replies: 8
Views: 703

Re: Using IE.Document.GetElementsByClassname

Added newKey AutoHotKey.exe REG_DWORD 11001 to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION and both scripts by FG are recognized Great information to know. Much appreciated. I tried it and it works for me. I have tried several times to get a ...
by FanaticGuru
09 Mar 2017, 20:00
Forum: Ask For Help
Topic: Using IE.Document.GetElementsByClassname
Replies: 8
Views: 703

Re: Using IE.Document.GetElementsByClassname

kczx3 wrote:Are these DOM methods case sensitive like in JS? Not at a computer to test but was curious.
The method and property names like getElementsByClassName are not case sensitive. getelementsbyclassname will work fine but the element names like "example" above are case sensitive.

FG
by FanaticGuru
09 Mar 2017, 02:12
Forum: Ask For Help
Topic: Using IE.Document.GetElementsByClassname
Replies: 8
Views: 703

Re: Using IE.Document.GetElementsByClassname

When it tried to refer to an element that didn't exist, there was no error message. The problem is not that the element does not exist but that the document does not support getElementsByClassName which is easy to reproduce. html = ( <div class="example">First div element with class="...
by FanaticGuru
08 Mar 2017, 15:22
Forum: Ask For Help
Topic: Creating auto-searcher for list of names. Topic is solved
Replies: 10
Views: 595

Re: Creating auto-searcher for list of names. Topic is solved

Well, software definitely lets me do exact searches again. I already removed autocheck each hour and push f12 manually, it's that script itself doesn't start. You can try putting a Msgbox within the hotkey to verify it is running when you push F12. SendMode Input Nicknames = ( Johnny Pro xxx_123 Di...

Go to advanced search