Search found 559 matches

by DRocks
03 Dec 2019, 09:24
Forum: Ask For Help
Topic: How to deal with csv comma delimiters that also have comma's inside ?
Replies: 7
Views: 1243

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
Topic: Excel COM Application.Visible to target specific workbook
Replies: 3
Views: 1129

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
Topic: Excel COM Application.Visible to target specific workbook
Replies: 3
Views: 1129

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
Topic: Excel COM Application.Visible to target specific workbook
Replies: 3
Views: 1129

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
Topic: How to get handle to specific excel file among multiple opened excel files?
Replies: 19
Views: 3833

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
Topic: ExcelCOM class to help getting the main Excel COM objects
Replies: 0
Views: 2622

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
Topic: How to get handle to specific excel file among multiple opened excel files?
Replies: 19
Views: 3833

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
Topic: Open Excel or when already active go to active Excel window
Replies: 15
Views: 4423

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
Topic: Open Excel or when already active go to active Excel window
Replies: 15
Views: 4423

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
Topic: Open Excel or when already active go to active Excel window
Replies: 15
Views: 4423

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
Topic: Lintalist 1.9 Searchable interactive lists to copy & paste text with plugins
Replies: 183
Views: 71924

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
Topic: Gui Edit and g-label?
Replies: 10
Views: 1449

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
Topic: [SOLVED]Quick question: scope of STATIC variables in function Topic is solved
Replies: 8
Views: 808

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...
by DRocks
29 Oct 2019, 07:46
Forum: Ask For Help
Topic: Gui Edit and g-label?
Replies: 10
Views: 1449

Re: Gui Edit and g-label?

Try this it works for me with latest AHK version on Win10 Gui, Add, Edit, w200 vEdit1 ReadOnly, First text Gui, Add, Edit, w200 vEdit2 ReadOnly, Second text Gui, Add, Edit, w200 vEdit3 ReadOnly, Third text OnMessage(0x201, "OnWM_LBUTTONDOWN") Gui, Show, autosize return OnWM_LBUTTONDOWN(wParam, lPara...
by DRocks
28 Oct 2019, 21:48
Forum: Ask For Help
Topic: [SOLVED]Quick question: scope of STATIC variables in function Topic is solved
Replies: 8
Views: 808

Re: Quick question: scope of STATIC variables in function Topic is solved

Okay. Thats very clear guys thanks to you both for the reply. So how does this work? A variable name is just a reference to another reference in the memory ? I mean, isInitialized static local variable name can be used a thousand times but they all have a unique hwnd / id / memory adress? So the onl...
by DRocks
28 Oct 2019, 18:48
Forum: Ask For Help
Topic: [SOLVED]Quick question: scope of STATIC variables in function Topic is solved
Replies: 8
Views: 808

[SOLVED]Quick question: scope of STATIC variables in function Topic is solved

EDIT: Solved. Look at each posts that have been replied, they all expand and make it very clear. thanks hello, I'm not sure how to test if a static variable declaration in a function is going to overlap with a variable that has the same name somewhere else in the global / super global scope of the e...
by DRocks
28 Oct 2019, 12:29
Forum: Scripts and Functions
Topic: getDateYYMMDD_fromString()
Replies: 1
Views: 1575

getDateYYMMDD_fromString()

Hi, This is a function I made to help me find the YYMMDD formatted date from any date resembling input. I need that for my work because we receive many client's files where they communicate dates to us that are never in the correct format. Hence this is why I came up with something to help me discov...
by DRocks
27 Oct 2019, 17:57
Forum: Ask For Help
Topic: Scrollable GUI (Recent?)
Replies: 3
Views: 721

Re: Scrollable GUI (Recent?)

I thought it was recent request so I looked for a thread where I found a solution for a scroll GUI so because I had copied the link already, I'll paste it here for reference

https://www.autohotkey.com/boards/viewtopic.php?p=262003#p262003

Go to advanced search