I decided (as I always do) the best way to learn was by doing, so I decided to spin up a simple POC with Office Script rather then my normal VBA. Even the record button was back, and although it was based on Typescript it was close enough, I could finally do VBA online, or could I? I heard nothing of it again until a spotted a new ‘Automate’ ribbon appear on Excel online. But a passing article caught my attention, with Microsoft looking at using JavaScript to eventually replace VBA. So I moved on, JavaScript for Cordova and web apps, and eventually got into full RPA solutions with Blue Prism and the Power Platform, and as we all do I got a little embarrassed of my VBA background and tried to move away from it. But I always hit that one ceiling, I always had to be there (or some other Human in the Loop), I wanted it online and that simply wasn’t possible. I was able to bypass my IT depts and create my own RPA and even somethings that could almost be classified as a standalone piece of software. Once I understood with the breadth of references and how few walls between other Microsoft programs I used VBA for everything, from workbooks to file management, to html scraping, to processing emails with Outlook. ![]() ![]() From the first time I hit the record macro button to writing my first sub from scratch was incredibly quick, with simple language syntax and great auto code completion it was a joy to learn (don’t shout at me but I’m sure Python learned its ease of use and learning curve from VBA). With no formal education or training my first taste of coding was with Excel and VBA. ![]() There are many paths into software development, and I suspect a few will be similar to mine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |