Search found 1269 matches

by FanaticGuru
15 Jan 2019, 19:15
Forum: Ask For Help
Topic: [Gdip] How to draw lines and retrieve pixel length?
Replies: 9
Views: 166

Re: [Gdip] How to draw lines and retrieve pixel length?

A script on the forums called Compass might be useful to look at. https://www.autohotkey.com/boards/viewtopic.php?t=7225 It draws a line and lets you measure between two points. It erases each line after drawing but it is close. It looks like it draws the line and then erases with DllCall("gdiplus.d...
by FanaticGuru
15 Jan 2019, 18:55
Forum: Ask For Help
Topic: Fastest sort
Replies: 4
Views: 124

Re: Fastest sort

A sort truly implemented in AHK is never going to be as fast as a the Sort command which is implemented in C++. The Sort command is probably a Quicksort at its core. Using the Sort command to sort an array object is mostly the time it takes to convert to a string and then convert back to an array ob...
by FanaticGuru
14 Jan 2019, 20:52
Forum: Ask For Help
Topic: Sorting an Array
Replies: 6
Views: 285

Re: Sorting an Array

@IMEime: Nice!, making DllCall redundant. The word "logical" led me to it and I didn't see that layoff. StrCmpLogicalW is great when you are comparing strings contain both numbers and letters but in this case your RegEx is making sure you are only comparing numbers. ie. StrCmpLogicalW handles this ...
by FanaticGuru
14 Jan 2019, 16:38
Forum: Ask For Help
Topic: Help - Sorting
Replies: 2
Views: 72

Re: Help - Sorting

If I was attempting to list names to view with some data, I would look at using a ListView . It displays information in nice columns and allows you to sort based on specific columns. If not a ListView then it looks like the data you are wanting sorted is in this string variable: Survey_Count_Text. Y...
by FanaticGuru
14 Jan 2019, 14:29
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 62
Views: 17779

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

So looking forward to the multiple line hotstring implementation if you can wrangle the RegEx to do it FantasticGuru --- it will help me clean up my messy hotstrings files enormously. Such a useful and clever bit of scripting. My testing works on multi-line hotstrings. ::btw:: ; <-- By The Way MsgB...
by FanaticGuru
14 Jan 2019, 14:23
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 62
Views: 17779

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

Many thanks, this last update (2019 01 03) indeed identifies the square key and Shift-square key, that I use in 4 hotkeys: 01.png Thanks for sharing this little useful tool. :D This reply is to post a bug and solution concerning duplicate entries. Somehow, each entry displays twice for #include fil...
by FanaticGuru
12 Jan 2019, 15:40
Forum: Ask For Help
Topic: Comparing 2 excel Files takes Forever to finish Topic is solved
Replies: 20
Views: 444

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

If I understand your task correctly, how you load the data into memory is insignificant to the time to process the data. Whether you load the data by traditional COM or more directly through accessing the XML of the data structure, the loading of the data is not the bottleneck. Now of course you nee...
by FanaticGuru
11 Jan 2019, 13:39
Forum: Ask For Help
Topic: Comparing 2 excel Files takes Forever to finish Topic is solved
Replies: 20
Views: 444

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

I Tried! it does seem to be way faster, but it gives me error after the 1st row on EXCEL2 After looping it to EXCEL1 ("Invalid Index") i also tried playing around to try and see if it will give me the same answers as my old code... NO LUCK, its either blank or gives me ERROR... #Persistent #SingleI...
by FanaticGuru
10 Jan 2019, 14:48
Forum: Ask For Help
Topic: Comparing 2 excel Files takes Forever to finish Topic is solved
Replies: 20
Views: 444

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

I have this 2 Excel Files i need to compare 1 file is over a million rows, the other file is over 38k rows.. i tried researching how to make it faster, and i think i need to fileread on memory and put it on array , instead of directly reading on excel... A SafeArray is what you are looking for. It ...
by FanaticGuru
09 Jan 2019, 13:36
Forum: Ask For Help
Topic: A search in a CSV file
Replies: 4
Views: 120

Re: A search in a CSV file

MsgBox % CSV.2.7 ; item 2, field 7 I cant understand how you made a 2 step object dotation with the two StrSplits. I always thought an object was limited to only 1 dot like this: Csv.2 Csv.3 Etc. Can you please add more verbal explanations to the First For Loop? Thanks in advance :) Here is the loo...
by FanaticGuru
08 Jan 2019, 17:37
Forum: Ask For Help
Topic: A search in a CSV file
Replies: 4
Views: 120

Re: A search in a CSV file

This a start: ; get info from file FileRead, OutputVar, Test.csv ; csv-file ; put info in array CSV := {} for Index, Line in StrSplit(OutputVar, "`n", "`r") CSV.Push(StrSplit(Line, ",")) ; example of get specific item and field MsgBox % CSV.2.7 ; item 2, field 7 ; example of looping through all item...
by FanaticGuru
08 Jan 2019, 15:00
Forum: Ask For Help
Topic: Start/close the script with certain program (need to make CPU friendly)
Replies: 4
Views: 138

Re: Start/close the script with certain program (need to make CPU friendly)

Hey guys. I've created a script with custom GUI that goes over some program. Now my goal is to make another script launch the "GUI script" when the program starts and close it when the program closes. I've made this so far but I need to make easy on a CPU. What am I missing? Thanks Below link is to...
by FanaticGuru
08 Jan 2019, 13:08
Forum: Ask For Help
Topic: I need a script to paste over highlighted text, and then copy the highlighted text that was replaced Topic is solved
Replies: 1
Views: 50

Re: I need a script to paste over highlighted text, and then copy the highlighted text that was replaced Topic is solved

Suppose I have word_a already copied to my clipboard. Then I highlight word_b and paste word_a over it. I'd like a way to then automatically copy word_b to my clipboard instead of word_a . This is all to be done with a single keystroke. I'm not very good at writing scripts so I really appreciate th...
by FanaticGuru
04 Jan 2019, 20:24
Forum: Scripts and Functions
Topic: Excel Enum Constants Search
Replies: 11
Views: 380

Re: Excel Enum Constants Search

I ended up making quite a bit of changes. The main thing is I switched over to keeping the data in an array in an attempt to make it a little quicker. With the large number of constants from both Excel and Word the Initialization is definitely noticeable. It is only the first time you open the dialo...
by FanaticGuru
04 Jan 2019, 16:02
Forum: Scripts and Functions
Topic: Excel Enum Constants Search
Replies: 11
Views: 380

Re: Excel Enum Constants Search

This is simple but great! I am constantly looking up enumerated constants for Excel and Word. I should have created something like this years ago but was too complacent with just googling all the time. I am going to see about adding Word's constants and adding a hotkey so I can have it running all t...
by FanaticGuru
04 Jan 2019, 15:03
Forum: Scripts and Functions
Topic: Hotkey Help - Display Active AHK Hotkeys and Hotstrings
Replies: 62
Views: 17779

Re: Hotkey Help - Display Active AHK Hotkeys and Hotstrings

Updated in First Post Change Log: Update 2019 01 03 Added support for SCxxx and VKxx type Hotkeys This only displays the SC and VK code used in the Hotkey definition. It does not translate that to an actual character for display. First translating looks pretty technically difficult and second the d...
by FanaticGuru
02 Jan 2019, 13:04
Forum: Ask For Help
Topic: saving user input to existing excel
Replies: 4
Views: 189

Re: saving user input to existing excel

bump, so I've gotten help and decided to make a GUI, but now using the GUI it's not writing to correct cell path when an image is found. F1:: Gui, New Gui, Font, s11, Calibri Gui, Add, Text, , Password: Gui, Add, Text, , Eng: Gui, Add, Text, , Heater: Gui, Add, Text, , Air: Gui, Add, Edit, w100 y5 ...
by FanaticGuru
31 Dec 2018, 19:51
Forum: Ask For Help
Topic: Is there any way to create a function dynamically? Topic is solved
Replies: 13
Views: 516

Re: Is there any way to create a function dynamically? Topic is solved

Example below, Function_Name := "Test" %Function_Name%() { } Not sure of your end game but you could create the function code dynamically then either execute it through a pipe or add it to your function library. Function_Name := "TestFunc" Code = ( %Function_Name%() { MsgBox I am here! } ) MsgBox %...
by FanaticGuru
31 Dec 2018, 19:14
Forum: Ask For Help
Topic: saving user input to existing excel
Replies: 4
Views: 189

Re: saving user input to existing excel

Hi, I'm in need of some of help with saving user input data to specific cells without having to making a code for every cell. IE, user inputs 4 data and they need to be stored in a specific formatted excel sheet. I can't think of a shorter way of doing this instead of duplicating multiple codes. Th...
by FanaticGuru
31 Dec 2018, 18:32
Forum: Bug Reports
Topic: Hotstring Bug?
Replies: 18
Views: 752

Re: Hotstring Bug?

For string function and label references to work you just need to do an On command for the hotstring. You don't have to turn it Off in order for this to work. With the workaround all the Hotstrings work as expected in the example above. In my example, it is a label (Go:) and it would not work until...

Go to advanced search