Search found 1272 matches

by FanaticGuru
Yesterday, 20:48
Forum: Ask For Help
Topic: Excel sum cells to an established number
Replies: 3
Views: 87

Re: Excel sum cells to an established number

This is combinatorics stuff, it often helps to produce numbers in a particular base e.g. binary. Here's some code to solve the mathematical part of the problem. q:: ;add a subset of numbers to reach a total oArray := [10, 20, 30, 40, 50, 60] vTarget := 110 vChoose := 3 vOutput := "target: " vTarget...
by FanaticGuru
17 Jan 2019, 15:41
Forum: Ask For Help
Topic: Help - Sorting
Replies: 5
Views: 115

Re: Help - Sorting

So if I were to use the sorting command which I have attempted, I can sort it via the text but I am trying to sort it by the numbers to the right of the text. Any ideas? I am looking at the Listview command also. Here is an example using ListView. This is the example straight out of the Help docume...
by FanaticGuru
17 Jan 2019, 13:41
Forum: Ask For Help
Topic: Fastest sort
Replies: 7
Views: 214

Re: Fastest sort

But as FG wrote, if it uses c++ sort I guess there is no chance to surpass the default sort ^^ I assume the default sort is very good. If it is Qsort by Microsoft then it is used in thousands of programs. I imagine it has been picked over and optimized by many different people. The only problem is ...
by FanaticGuru
15 Jan 2019, 19:15
Forum: Ask For Help
Topic: [Gdip] How to draw lines and retrieve pixel length?
Replies: 9
Views: 178

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: 7
Views: 214

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

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: 5
Views: 115

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

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

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: 21
Views: 506

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: 21
Views: 506

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: 21
Views: 506

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

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

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

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

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

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

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

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

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

Go to advanced search