Search found 18 matches

by MARCAN
Today, 16:00
Forum: Ask For Help
Topic: Add one row in Excel if cell has data Topic is solved
Replies: 3
Views: 36

Re: Add one row in Excel if cell has data Topic is solved

Thank you Odlanir and flyingDman, that is exacly what I was looking. :bravo:

I'm very gratefull and glad that the AHK community has users like you that are willing to help and teach the rest of us.

Again thanks, I'm much aprecciated. Hopefully this code can also help other users.

Best regards,
MC
by MARCAN
Today, 11:21
Forum: Ask For Help
Topic: Add one row in Excel if cell has data Topic is solved
Replies: 3
Views: 36

Add one row in Excel if cell has data Topic is solved

Hi all I have an Excel worksheet and it has a variable number of rows. What I need is, for each row with data in column A, it adds a row below it. If there are no more rows with data in column A, it will stop adding rows below. So far I got to this code: xl := ComObjActive("Excel.Application") Row :...
by MARCAN
05 Jan 2020, 15:31
Forum: Ask For Help
Topic: Excel Subtotals Topic is solved
Replies: 7
Views: 403

Re: Excel Subtotals Topic is solved

That's exactly what I was searching for!!! :dance: flyingDman you're the man!!! :bravo: thank you for sharing the knowledge and for taking the time for it (and also toralf for the time and interest taken). This can also serve for others that may need it. Best regards and keep up the good work. MC
by MARCAN
05 Jan 2020, 09:08
Forum: Ask For Help
Topic: Excel Subtotals Topic is solved
Replies: 7
Views: 403

Re: Excel Subtotals Topic is solved

Could you post your excel file or a screenshot of the final result? I still do not understand what you want to achieve. Will it be in excel or in a ahk gui? Hi toralf. Attached are 3 images: 1 - example of the data 2 - Excel Subtotal command 3 - final result The end result will be in excel, automat...
by MARCAN
05 Jan 2020, 05:31
Forum: Ask For Help
Topic: Excel Subtotals Topic is solved
Replies: 7
Views: 403

Re: Excel Subtotals Topic is solved

You could with AHK set the excel Formular for subtotal into the cell via com. So in general yes, but I’m not sure if that is the answer to your question. Maybe you could elaborate a little more on what exactly you want to achieve. I agree with @toralf . This is a bit vague. Also elaborate on "With ...
by MARCAN
04 Jan 2020, 17:59
Forum: Ask For Help
Topic: Excel Subtotals Topic is solved
Replies: 7
Views: 403

Excel Subtotals Topic is solved

Hi all.

Is there a way to create Subtotals in Excel, like the Subtotal command in it? With "At each Change in", "Use Function" and all other options?

Thanks in advanced, best regards
MC
by MARCAN
04 Dec 2019, 06:26
Forum: Ask For Help
Topic: Auto delimit TXT file in Excel text import wizard Topic is solved
Replies: 2
Views: 269

Re: Auto delimit TXT file in Excel text import wizard Topic is solved

Thank you very much flyingDman, it worked perfectly for my purposes.

Best regards,

MC
by MARCAN
01 Dec 2019, 17:24
Forum: Ask For Help
Topic: Auto delimit TXT file in Excel text import wizard Topic is solved
Replies: 2
Views: 269

Auto delimit TXT file in Excel text import wizard Topic is solved

Hi all. Is it's possible to automate Excel text import wizard, with a txt file, using fixed width, and creating auto break lines at fixed positions? To start I have this code (sorry for the fuzzy code or methods, I'm still a fresh newbie): #NoEnv ; Recommended for performance and compatibility with ...
by MARCAN
11 Nov 2019, 14:54
Forum: Scripts and Functions
Topic: [Tool] Clipboard Master v2
Replies: 9
Views: 2114

Re: [Tool] Clipboard Master v2

Thank you very much for sharing this jewel.

Regards
MC
by MARCAN
11 Nov 2019, 12:06
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

By the way, when I open the ahk files of the Tools and run them, they do work, but thats the point of the Tools tab, right?

Run the Tools with one click, inside the AutoGui.

Cheers
by MARCAN
11 Nov 2019, 10:43
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Hi I'm trying to open the program Tools, like MagicBox, Constantine and similar ones, but I'm not being able to, in my office PC, which I don't have admin rigths (and maybe that should be the cause). I've tried them in my home PC and they work fine. I already removed and add them again and that din'...
by MARCAN
07 Nov 2019, 12:18
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Hi
another suggestion:
a way to store personalized auto-execute code, reusable for new scripts.
that would be cool. :thumbup:

Best regards
MC
by MARCAN
24 Oct 2019, 16:18
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Hello again.
I have a suggestion, althought it might be in development.
It would be great if all unsaved changes (lines) could have a mark next to line numbers.
Can it be done?

Thank you and best regards,

MC
by MARCAN
13 Oct 2019, 15:09
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

@MARCAN: The code I posted should be executed as a separate script file. Custom keyboard shortcuts will be implemented in a feature version of AutoGUI. Can´t wait for the next version. And many thanks for the collapse/expand script...it works like a charm. Best regards and good work. :bravo:
by MARCAN
30 Sep 2019, 07:25
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

@MARCAN: Try the code below. Ctrl + Backspace collapses all folds. Ctrl + Shift + Backspace expands all folds. #IfWinActive AutoGUI v TopMenu := " &View " ^Backspace:: MenuItem := "Collapse All Folds" WinMenuSelectItem A,, %TopMenu%, %MenuItem% Return ^+Backspace:: MenuItem := "Expand All Folds" Wi...
by MARCAN
25 Sep 2019, 15:23
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Hi again. I have another doubt: how can we change/create the hotkeys / shortcut for "collapse all folds" and "expand all folds"? And other hotkeys of AutoGui commands? I went to AutoGUI\Include\Editor and found lines 1347 and 1352. Tried to create hotkeys (using another editor), but they didn´t work...
by MARCAN
22 Sep 2019, 15:29
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Thank you and I'm looking forward for the new developments. :)

Best regards,

MC
by MARCAN
17 Sep 2019, 10:32
Forum: AutoGUI
Topic: AutoGUI - Script Editor, GUI Designer, Debugger and Tools
Replies: 363
Views: 222325

Re: AutoGUI - Script Editor, GUI Designer, Debugger and Tools

Hi all. I'm starting to learn AHK and of all the ide's I've tried, AutoGui is the one I like the most, but for now I only have a question: How can we change Theme colors, like for eg. AHK Studio has? Or can someone point me the lines of code to change the colors used by it? Thanks in advanced and ke...

Go to advanced search