Search found 565 matches
- 06 Dec 2019, 16:25
- Forum: Wish List
- Topic: Function to get focused Edit's ComboBox hwnd/classNN or vice versa
- Replies: 15
- Views: 7818
Re: Function to get focused Edit's ComboBox hwnd/classNN or vice versa
... would be aware of its own Edit/ComboBox handle so that you can easily use both if needed. Would you please provide an example of what you'd do using the edit's handle? I'll give a very specific example I am using now but in summary its when you want to use Control, ChooseString but all you know...
- 05 Dec 2019, 22:02
- Forum: Scripts and Functions (v1)
- Topic: GetClassNN()
- Replies: 3
- Views: 1480
Re: GetClassNN()
Nice I needed it yesterday!
Thank you!
Thank you!
- 05 Dec 2019, 20:22
- Forum: Scripts and Functions (v1)
- Topic: [Library] DSV Parser
- Replies: 8
- Views: 2957
Re: [Library] DSV Parser
Thanks for your detailed reply, its super interesting. I was not aware of Anki but I read the paragraph anyway lol. Seems gigantic and complex to parse correctly! Good job on accomplishing that. Sometimes we don't want to "re-invent" the wheel as they say but it still can be necessary in many scenar...
- 05 Dec 2019, 20:11
- Forum: Wish List
- Topic: Function to get focused Edit's ComboBox hwnd/classNN or vice versa
- Replies: 15
- Views: 7818
- 05 Dec 2019, 00:53
- Forum: Wish List
- Topic: Function to get focused Edit's ComboBox hwnd/classNN or vice versa
- Replies: 15
- Views: 7818
Function to get focused Edit's ComboBox hwnd/classNN or vice versa
Would it be possible to implement a built-in and documented function that would be able to retrieve a Edit's parent ComboBox hwnd and/or classNN ? And also the other way around, get the Hwnd of a ComboBox's edit? I find it hard to get around this still after 1 year and a half with Ahk. Or probably m...
- 04 Dec 2019, 06:05
- Forum: Scripts and Functions (v1)
- Topic: [Library] DSV Parser
- Replies: 8
- Views: 2957
Re: [Library] DSV Parser
Nice code !
Thanks.
I am wondering why you did not use the built-in Loop, Parse, _, Csv ?
Was it for specific custom needs ?
- Seeing that you do some complex regexmatch stuff.
Thanks.
I am wondering why you did not use the built-in Loop, Parse, _, Csv ?
Was it for specific custom needs ?
- Seeing that you do some complex regexmatch stuff.
- 03 Dec 2019, 09:24
- Forum: Ask for Help (v1)
- Topic: How to deal with csv comma delimiters that also have comma's inside ?
- Replies: 7
- Views: 1954
Re: How to deal with csv comma delimiters that also have comma's inside ?
Thanks this works fine! Here's another example for others to refer to: Drag and drop a .csv on Gui to create a global csv.fileName array / object or link a file directly to the getCSV_CONTENT() function #NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases. SendMode ...
- 17 Nov 2019, 08:40
- Forum: Ask for Help (v1)
- Topic: Excel COM Application.Visible to target specific workbook
- Replies: 3
- Views: 1896
Re: Excel COM Application.Visible to target specific workbook
flyingDman Thanks a lot FlyingDman. you need to include xl.visible := true but you can do it after hiding one of the workbooks to avoid having the second file "flash". Ah that's exactly what I wanted to acheive, nice. To activate a hidden workbook, you'll have to make it visible first, then to acti...
- 15 Nov 2019, 14:30
- Forum: Ask for Help (v1)
- Topic: Excel COM Application.Visible to target specific workbook
- Replies: 3
- Views: 1896
Re: Excel COM Application.Visible to target specific workbook
I found a way that feels hacky to me but here's the sample. Is that even close to a good way of doing it ? ;... if (!xlApp.Visible && WindowShouldBeVisible) { xlApp.Visible := true } xlWB.Windows(FileName).Visible := WindowShouldBeVisible ;... What's wierd about it is that the window is opened for a...
- 15 Nov 2019, 13:28
- Forum: Ask for Help (v1)
- Topic: Excel COM Application.Visible to target specific workbook
- Replies: 3
- Views: 1896
Excel COM Application.Visible to target specific workbook
How do you make ExcelWorkbook1.xslx visible and keep ExcelWorkbook2.xlsx invisible when both belong to the same Excel Application object ? XlApp.Visible := True will automatically bring every workbooks in the xlApp object visible together. How do you target only workbook1 or workbook2 with the Visib...
- 14 Nov 2019, 18:06
- Forum: Ask for Help (v1)
- Topic: How to get handle to specific excel file among multiple opened excel files?
- Replies: 19
- Views: 6637
Re: How to get handle to specific excel file among multiple opened excel files?
Thank you again. I had found your example in another forum post while I was documenting on the topic and tried it too. I agree with you on all you said about the complexity of having multiple Excel apps openned and the intention to keep it down to a single instance. I discovered my problem of multip...
- 14 Nov 2019, 18:01
- Forum: Ask for Help (v1)
- Topic: Open Excel or when already active go to active Excel window
- Replies: 15
- Views: 9509
Re: Open Excel or when already active go to active Excel window
Very nice and clear, thank you FG.
- 14 Nov 2019, 08:39
- Forum: Scripts and Functions (v1)
- Topic: ExcelCOM class to help getting the main Excel COM objects
- Replies: 0
- Views: 3066
ExcelCOM class to help getting the main Excel COM objects
Here's a solution to a problem I had to deal with when dealing with Excel COM . This class is a gathering of many ideas by great people. It wraps everything I needed for myself in a easy to use class which I adapted from these other person's work - so credits to them (and many thanks). Details: The ...
- 12 Nov 2019, 12:53
- Forum: Ask for Help (v1)
- Topic: How to get handle to specific excel file among multiple opened excel files?
- Replies: 19
- Views: 6637
Re: How to get handle to specific excel file among multiple opened excel files?
Thanks for this. By doing this method you've shown FanaticGuru I'd suppose it would be possible to have more than one Excel Workbook openned and not encounter ID conflicts ? xlWB:= Excel_GetWB("S:\Folder\WorkHours.xlsm") xlSheet := xlWB.ActiveSheet xlApp := xlWB.Parent MsgBox % xlWB.Sheets(1).Range(...
- 12 Nov 2019, 07:38
- Forum: Ask for Help (v1)
- Topic: Open Excel or when already active go to active Excel window
- Replies: 15
- Views: 9509
Re: Open Excel or when already active go to active Excel window
Re OpenExcel() FanaticGuru Have you ever encountered a exception where you have a minimized Excel workbook that isn't Found when using OpenExcel()? I do not understand why the COM object works fine when the workbook is already openned and NOT in minimized window state. But it doesn't work when minim...
- 07 Nov 2019, 20:48
- Forum: Ask for Help (v1)
- Topic: Open Excel or when already active go to active Excel window
- Replies: 15
- Views: 9509
Re: Open Excel or when already active go to active Excel window
Thanks for your reply.
With your latest example I've not been able to reproduce the need to add the if (xlApp) condition.
Although I do wonder why you return xlWB instead of xlApp ?
I'm not able to use xlWB.Range() directly is this normal ?
With your latest example I've not been able to reproduce the need to add the if (xlApp) condition.
Although I do wonder why you return xlWB instead of xlApp ?
I'm not able to use xlWB.Range() directly is this normal ?
- 05 Nov 2019, 08:17
- Forum: Ask for Help (v1)
- Topic: Open Excel or when already active go to active Excel window
- Replies: 15
- Views: 9509
Re: Open Excel or when already active go to active Excel window
I needed to add this condition to make the example OpenExcel() function provided by FanaticGuru: if (xlApp) { ... } precisely: try { xlApp := ComObjActive("Excel.Application") if (xlApp) { for xlWB in xlApp.Workbooks if (xlWB.Name = FileName) { Found := true break } } } Without this condition I get ...
- 05 Nov 2019, 07:02
- Forum: Scripts and Functions (v1)
- Topic: Lintalist 1.9 Searchable interactive lists to copy & paste text with plugins
- Replies: 200
- Views: 109232
Re: Lintalist 1.9 Searchable interactive lists to copy & paste text with plugins
Hello, Heres my first impression regarding the presentation of Lintalist. It looks phenomenal and id like to know more. But there is TOO much information on the website to even think of reading it. Id really recommend making a voice over video simple introduction as front page presentation every whe...
- 29 Oct 2019, 08:53
- Forum: Ask for Help (v1)
- Topic: Gui Edit and g-label?
- Replies: 10
- Views: 3044
Re: Gui Edit and g-label?
MannyKSoSo Smart move thanks for updating swagfag dude I never saw this kind of syntax. Are you basically showing that with a function binding and passing a object, you don't need to declare each Gui variables ?? The object automatically keeps a hwnd of a Gui, Add command ?? EDIT: ohh wow ok I miss...
- 29 Oct 2019, 08:01
- Forum: Ask for Help (v1)
- Topic: [SOLVED]Quick question: scope of STATIC variables in function Topic is solved
- Replies: 8
- Views: 2108
Re: Quick question: scope of STATIC variables in function Topic is solved
Thank you very much for your help guys, this has all been clear and I get it now. Interestingly, I never used ListVars before O.o Most times I debug with msgboxes alone but ListVars would be faster lol :D thanks Based on yours - here's another example for any one else looking at the post: #Persisten...