Saturday, 18 February 2017

AET VBE Tools v1.6.1

Yes, it's still freeware. Think of it as a patch.

I'm still committed to updating this version by fixing any bugs that I find, or tweaking this and that with improvements. It won't have as many features as upcoming versions, but I don't intend to abandon it either.

So, what's new?

  • An indenting bug was fixed for Select Case constructs when working with Projects and Modules.

  • I also improved the indenting of Add Line Numbers code.

  • When adding the date and time to text files being exported, the code has been adjusted to show the correct time.

  • I made a change to the Copy Code and Compare Code userforms. Sometimes duplicate file names were showing.

  • I edited Highlight Code In Excel so that individual Case statements are also highlighted with Select Case constructs.

  • Case Statements

    Note: It is a big help to see them highlighted this way. Unfortunately I had to hard code that part, so it will only work if your tab settings are set to 4. (In the VBE, Tools, Options, Editor, Tab Width). If I find a way to determine this programatically, I will adjust the code to suit.

  • As a small bonus, I also added the functionality to delete Debug.Assert and Stop to the Cleanup Project code.



  • Download it here.

    Saturday, 11 February 2017

    AET VBE Tools v1.6

    This will be the final freeware version.

    Let's see what we have so far. Access AET VBE Tools by right clicking within the active code pane.



    Here are the tools.

    Indent Code
    Indent code within the active VB project, module, procedure or selected text.



    Add Line Numbers
    Add line numbers to code within the active VB project, module, procedure.



    Delete Line Numbers
    Delete line numbers from code within the active VB project, module, procedure.



    Export Code
    Export code from the active VB project, module, procedure to text files.



    Compare Code
    Select modules from projects.



    Code from both modules will be exported to worksheets in a new workbook.

    Code that exists in one module, but not the other (and vice versa) will be highlighted.



    Copy Code
    You can copy code/modules between projects.



    Standard modules, class modules and userforms will be be replaced if they exist (have the same name), or added if they don't exist.

    ThisWorkbook code will be replaced.

    Sheet module's code will be replaced if the sheet exists, or worksheets will be added with the new code if they don't exist.

    Macro Comment Tools
    A handy way to add generic comments to all macros in the active project or module.



    Insert Code Snippets
    Tired of entering the same code all the time? This makes it easier.



    Run Favourite Macros
    Yes, you can already run them from your Personal workbook.

    But now you can also export your favourite code to text files. Note: Not all code will run. This is a experimental tool, but I have found it quite useful when coding myself.



    Multiple Find And Replace
    You can find and replace code with several fields at once. Fields are saved between sessions.



    Cleanup Project
    Just 2 options at the moment. You can delete lines of code that have "Debug.Print", and also delete excess blank lines. (Only a single blank line will remain)

    Highlight Code In Excel
    Export your code to a worksheet in a new workbook. Selecting cells in Column A that have keywords like If, With, Select, etc will be highlighted so you can see where that part of the code begins and ends. This is very beneficial to your mental health when trying to figure out what connects with what in those long, long procedures.



    Last, but not least, there are various settings available.



    That's it for now. I've already started writing code for my upcoming shareware version, and one cool new tool is already added.

    Please support me by purchasing a copy when it's ready.

    For now, download AET VBE Tools v1.6 here.

    Update: A patch has been released. See here for details.

    PS: Stay updated by joining my mailing list. You can subscribe where indicated on the sidebar to the left.

    Saturday, 28 January 2017

    Excel Dashboard Pro Course

    Jordan Goldmeier is an expert at creating dashboards in Excel and is releasing a training course to help you master them too.



    I've had a look at the course myself and have this to say.

  • I am really impressed with the level of detail. Jordan doesn't skip over stuff, yet doesn't drown you with too much information.

  • The course is easy to understand. Jordan explains how things work in everyday language.

  • There's a good balance of hands on learning and theory. Both will benefit you as you progress through the course.

  • I can guarantee you are getting your money's worth. There are 60 plus video lessons, plus matching files that you can use to practice.

  • It's not just the quantity. The course covers everything you need to know and more. There's even bonus materials at the end.

  • As you can see, I like the professionalism of the course and it's presentation. Jordan excels at both and I recommend this course as a comprehensive way to become a dashboard guru. Even if you already have some experience, I'm sure the course will be of benefit.

    Disclaimer: As an affiliate, I make some commission in recommending this course on my blog. That said, I would never recommend anything that I thought wouldn't benefit you, my readers. After all, you are the reason I blog in the first place.

    To access the course site, click the Power of Foresight banner above.

    Monday, 23 January 2017

    AET VBE Tools v1.5

    So soon?

    Yep, I made a couple of small improvements under the hood. Better now than later.

    Download the new version here.

    Sunday, 22 January 2017

    AET VBE Tools v1.4

    Another week, another tool.

    Copy Code
    You can now "copy" code between projects.



    By this I mean the following,

    Standard modules, class modules and userforms will be be replaced if they exist (have the same name), or added if they don't exist.

    ThisWorkbook code will be replaced.

    Sheet module's code will be replaced if they exist, or worksheets will be added with the new code if they don't exist.

    I may add some more functionality to this tool at a later date.

    Line Numbers
    I've rewritten the code so indenting is no longer influenced by line number length. This was a bug that really bugged me ;-)

    Download the latest version of AET VBE Tools here.