Search found 543 matches

by FanaticGuru
26 Apr 2017, 16:11
Forum: Ask For Help
Topic: *SOLVED* Changing a string of letters into something more readable
Replies: 2
Views: 30

Re: Changing a string of letters into something more readable

This is one way. Array := ComObjCreate("Scripting.Dictionary") Array.item("1") := "one square" Array.item("2") := "two squares" Array.item("/") := "next rank" Array.item("r") := "white rook" Array.item("b&...
by FanaticGuru
24 Apr 2017, 16:10
Forum: Ask For Help
Topic: Zezenia highscores
Replies: 5
Views: 59

Re: Zezenia highscores

Here is a start to download the first page of HTML. MsgBox % Get_URL_Html("www.zezeniaonline.com/community/highscores/All/level/page1") Get_URL_Html(URL) { whr := ComObjCreate("WinHttp.WinHttpRequest.5.1") whr.Open("GET", "http://" URL, true) whr.Send() whr.Wa...
by FanaticGuru
24 Apr 2017, 15:53
Forum: Ask For Help
Topic: Zezenia highscores
Replies: 5
Views: 59

Re: Zezenia highscores

Hello, I'm wanting to know if it was possible to make a script which would log the top 100 peoples EXP on the highscores and then check it again after 15 minuntes and output the data to a notepad file saying the difference in experience. Thanks Yes. It will require some skill and work. Getting the ...
by FanaticGuru
21 Apr 2017, 17:43
Forum: Wish List
Topic: Hide AutoHotkey's process strings
Replies: 25
Views: 541

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Go to advanced search