Search found 540 matches

by FanaticGuru
21 Apr 2017, 17:43
Forum: Wish List
Topic: Hide AutoHotkey's process strings
Replies: 22
Views: 393

Re: VERY IMPORTANT: Protect Autohotkey! Hide its process strings

Yeah right, I'll petition all of them as if they would agree. I'm also won't play hide and seek no more. I can't install this or that because ahk will be running. It is better to stop using ONE so I can use TEN rather than can't use ten because of one. So long ahk! Any game developer that cares wil...
by FanaticGuru
12 Apr 2017, 12:15
Forum: Ask For Help
Topic: extracting items from a list using RegEx (various methods)
Replies: 6
Views: 110

Re: extracting items from a list using RegEx (various methods)

method 3 - while loop ;METHOD 3 - while loop vPos := 1, o := [] while (vPos := RegExMatch(vText, "O)(\w+)(,|$)", oTemp, vPos)) o[A_Index] := oTemp.1, vPos += StrLen(oTemp.1) MsgBox, % "[3] " o.1 " " o.2 " " o.3 " " o.4 ;red yellow green blue I use t...
by FanaticGuru
05 Apr 2017, 14:25
Forum: Ask For Help
Topic: Any saveGIFtoFile function? Topic is solved
Replies: 2
Views: 58

Re: Any saveGIFtoFile function? Topic is solved

Your script works for me. I run this line saveimagetofile(A_Desktop "/Temp/PictureTest", "gif") and it saved a picture that I put on the clipboard by screen clipping as a "GIF" with no problems. Just for the record Gdip_SaveBitmapToFile and the underlying GDI+ d...
by FanaticGuru
04 Apr 2017, 02:16
Forum: Ask For Help
Topic: Is there a tool that letting us to manage scripts?
Replies: 8
Views: 649

Re: Is there a tool that letting us to manage scripts?

You might check out AHK Startup in my signature. It is a script that starts multiply AHK scripts that then only have one tray icon. When you end AHK Startup all the individual scripts also end. So it is a way to start and stop multiply AHK scripts together to cause them to act more like one scripts ...
by FanaticGuru
27 Mar 2017, 12:15
Forum: Ask For Help
Topic: How to change the cell color of a range in ms excel? Topic is solved
Replies: 7
Views: 187

Re: How to change the cell color of a range in ms excel? Topic is solved

F1:: Xl := ComObjActive("Excel.Application") if (Toggle := !Toggle) Xl.Range("A1:M1").Interior.Color := 0 ; Fill Color Black else Xl.Range("A1:M1").Interior.Pattern := 0 ; No Fill return No Fill and Fill with white is a little different. Any time a cell has a Fill colo...
by FanaticGuru
27 Mar 2017, 11:52
Forum: Ask For Help
Topic: Basic GUI button that changes color / toggles when pressed? Like an "on / off" ?
Replies: 9
Views: 246

Re: Basic GUI button that changes color / toggles when pressed? Like an "on / off" ?

mrsnakers wrote:Perhaps would be cool to have an actual on off switch image...

Below is a link to a nice example and tutorial complete with images to download for the buttons.
https://jszapp.com/make-beautiful-graphical-user-interface-15-lines-less/

FG
by FanaticGuru
23 Mar 2017, 01:01
Forum: Ask For Help
Topic: AHK commands for Excel =MID() & =VALUE() Topic is solved
Replies: 3
Views: 101

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
22 Mar 2017, 17:22
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 10
Views: 553

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
22 Mar 2017, 17:11
Forum: Scripts and Functions
Topic: Reads Excel (xlsx) Fast
Replies: 10
Views: 553

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: 101

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: 374

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: 742

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: 460

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: 460

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: 460

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: 450

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: 691

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: 3050

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: 3050

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: 3050

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

Go to advanced search