Search found 565 matches

by DRocks
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...
by DRocks
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!
by DRocks
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...
by DRocks
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

Re: Function to get focused Edit's ComboBox hwnd/classNN

just me wrote:
05 Dec 2019, 09:35
Do you talk about AHK GUI ComboBoxes?
Yes mostly, for convenience.
I think it would be useful if the Gui, Add, ComboBox, ... vCb1 gCb1 hwndhCb1 would be aware of its own Edit/ComboBox handle so that you can easily use both if needed.
by DRocks
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...
by DRocks
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.
by DRocks
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 ...
by DRocks
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...
by DRocks
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...
by DRocks
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...
by DRocks
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...
by DRocks
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 ...
by DRocks
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(...
by DRocks
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...
by DRocks
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 ?
by DRocks
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 ...
by DRocks
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...
by DRocks
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...
by DRocks
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...

Go to advanced search