AutoHotkey Community

MARCAN

@Alguimist
Hi
Zscaler is giving me a Trojan Horse, when trying to download the file.

Can you please check it out?

Thanks!

MARCAN

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

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

MARCAN

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 :...

MARCAN

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

MARCAN

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...

MARCAN

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 ...

MARCAN

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

MARCAN

flyingDman wrote: ↑
02 Dec 2019, 05:19
Have a look at this post: https://www.autohotkey.com/boards/viewtopic.php?f=76&t=67835&p=291592&hilit=TextToColumns#p291592

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

Best regards,

MC

MARCAN

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 ...

MARCAN

Thank you very much for sharing this jewel.

Regards
MC

MARCAN

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

MARCAN

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'...

MARCAN

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

Best regards
MC

MARCAN

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

MARCAN

@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:

MARCAN

@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...

MARCAN

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...

MARCAN

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

Best regards,

MC

MARCAN

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...

Search found 19 matches

Re: Adventure - General-Purpose IDE, Lightweight Text Editor

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

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

Re: Excel Subtotals Topic is solved

Re: Excel Subtotals Topic is solved

Re: Excel Subtotals Topic is solved

Excel Subtotals Topic is solved

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

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

Re: [Tool] Clipboard Master v2

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

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

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

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

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

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

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

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

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