AutoHotkey Community

flyingDman

So you want to create a hotkey (ins::) to send the option selected in the popup?. Try this: MyGui := Gui('AlwaysOnTop') MyGui.AddText(, 'Select your category') ListBox1 := MyGui.AddListBox('r6', ['Option1', 'Option2', 'Option3']) MyGui.AddButton('Default w80', 'Submit').OnEvent('Click', ButtonClicke...

flyingDman

Home:: { global ListBox1 ; <<<<<<<<<<< MyGui := Gui('AlwaysOnTop') MyGui.AddText(, "Select category") ListBox1 := MyGui.AddListBox('r6 vCategoryChoice', ['Option1', 'Option2', 'Option3', 'Option4', 'Option5', 'Option6']) MyBtn1 := MyGui.AddButton('Default w80', 'Submit').OnEvent('Click', MyBtn1_Cli...

flyingDman

Thank you for shedding light on the intrinsic ambiguity between properties and methods in VBA and your decision to discontinue this ambiguity in v2. That said, for those like me who made extensive use of the MS VBA documentation to write AHK COM code, it has not become easier as certain things that ...

flyingDman

If you are a fan of more compact code: gmax := map(), gsum := map(), res := "" for x,y in strsplit(str, "`n", "`r") { z := strsplit(y," "), grp := z[1] gmax[grp] := gmax.has(grp) ? max(gmax[grp],z[2]) : z[2] gsum[grp] := gsum.has(grp) ? gsum[grp]+z[3] : z[3] } For grp in gmax res .= grp "`t" gmax[gr...

flyingDman

My example includes one but it does not require one.

flyingDman

Try Morse: https://www.autohotkey.com/boards/viewtopic.php?f=76&t=127450&p=563668&hilit=morse#p563668 <^Numpad0::sendtext((x:=Morse())="0"?"single" :x="00"?"double" :x="1"?"long" :"") Morse(to := 250) { while KeyWait(hk := RegExReplace(A_ThisHotkey, ".*?(\W|\w*)$","$1"), "DT" to/1000) st := A_TickCo...

flyingDman

https://www.autohotkey.com/docs/v2/lib/CoordMode.htm

flyingDman

ComObjActive does not connect to a file, it connects to the application (in this case MS Word). Having several files open in Word does not mean that there are several instances of the application running simultaneously. Several files can be open and running under the same instance . One of the open ...

flyingDman

Thanks, just me . It is a similar issue. As long as you do not have any `r`n (i.e. CRLF = a carriage return and a linefeed together ) inside double quoted text*, you can strsplit(xxx,"`r`n) and use the CSV parsing loop to achieve your 2 objectives: 1) a multi-line cell shown as a one-liner inside a ...

flyingDman

Your issue is with the if and {} blocks (or lack thereof) Also (because your UUID look real) There are a few reasons why you should not post your UUID online. First, it could be used to track you across multiple websites and services. Second, it could be used to identify you if you are using a servi...

flyingDman

labels ? Perhaps this will help: a_clipboard := "" Run a_comspec ' /c wmic systemenclosure get chassistypes | clip',,'hide' if ClipWait(1) { regexmatch(a_clipboard, "(\d+)",&m) if (m[1] = 9 or m[1] = 10) msgbox "this is a laptop" else msgbox "this is a desktop" } The exact list is: 1 - Other 2 - Unk...

flyingDman

Try:

Code: Select all

a_clipboard := ""
Run a_comspec ' /c wmic systemenclosure get chassistypes | clip',,'hide'
if ClipWait(1)
	{
	regexmatch(a_clipboard, "(\d+)",&m)
	msgbox (m[1] = 9 or m[1] = 10) ? "laptop" : "desktop"
	}

This worked on my laptop but do not have a desktop to test.

edit added a clipwait

flyingDman

It's obviously hard to say without having the excel spreadsheets themselves but there is no obvious error or obvious potential improvement that I see.

flyingDman

Yes, that is a different and unrelated error. I gave you the exact error that pops up when the file name is incorrect. See in what I pasted: the script is looking for an Excel file called Path.xlsx. I have 317 scripts where it is either xl.workbooks.open(somevariable) or xl.workbooks.open("C:\Users\...

flyingDman

xl.Workbooks.Open("Path") is very definitely wrong. Path is a variable and quotes are not even optional. It will generate this error: --------------------------- script_2024-04-02_13-07_V1.ahk --------------------------- Error: 0x800A03EC - Source: Microsoft Excel Description: Sorry, we couldn't fi...

flyingDman

Correct the errors Russ and I reported and see what happens. When you have errors copy paste the error message here.

GuiControlGetText does not exist! Is that AI generated?

flyingDman

I do not see blatant errors or inefficiencies. Now if you have many rows in your spreadsheet (and I mean say > 1000), this code may be slow. This is because you read each cell using a COM call. In such cases I prefer to read all data into a safearray and extract data from that array. But if your spe...

flyingDman

I guess the OP gets an error on the foundrow line.
Wrkbk := xl.Workbooks.Open("Path") should be Wrkbk := xl.Workbooks.Open(Path). That however triggers an error elsewhere.

flyingDman

What is A_month ? A_MM or A_Mon perhaps?

flyingDman

Use substr(SKU,-1) != "-B" instead of !InStr(SKU, "-B")

Search found 2817 matches

Re: How to get a value of ListBox1 control here (conitnue)?

Re: Ho to get a value of ListBox1 control here?

Re: COM: Table Manipulation in MS Word broken in recent AHK versions

Re: Please help, Data grouping, calculating total and maximum values

Re: Combining long press and double tapping scripts

Re: Combining long press and double tapping scripts

Re: Tomar coordenadas de window y no de screen Topic is solved

Re: ComObjActive with several open Word files Topic is solved

Re: Reading CSV, but maintaining linebreaks and carriage returns between double quotes Topic is solved

Re: Desktop or Laptop ?

Re: Desktop or Laptop ?

Re: Desktop or Laptop ?

Re: Need help with Excel data transfer

Re: Using Edit Boxes to search excel column E and pull corresponding data from column G, breaks on foundrow line

Re: Using Edit Boxes to search excel column E and pull corresponding data from column G, breaks on foundrow line

Re: Using Edit Boxes to search excel column E and pull corresponding data from column G, breaks on foundrow line

Re: Need help with Excel data transfer

Re: Using Edit Boxes to search excel column E and pull corresponding data from column G, breaks on foundrow line

Re: Need help with Excel data transfer

Re: Need help with Excel data transfer