Having developed Excel applications for countless firms, one undeniable truth has emerged: calendars are the backbone of business operations. Their importance often exceeds what most people realize. Every business, no matter the industry, relies on calendars to manage workflows, deadlines, and schedules—but each has unique and specific requirements that a one-size-fits-all solution can’t accommodate. That’s […]
Hiring The Right Excel, Access, Word VBA Automation Expert
Hiring the right Excel, Access, Word and VBA Automation expert can be transformative for your business, streamlining workflows and unlocking the full potential of Microsoft Office tools. With decades of experience and a proven track record of delivering tailored solutions, unique challenges and business needs I will develop customized tools and automation systems that save time, reduce errors, […]
Excel VBA got me to London, Hong Kong and a Great Job.
How Excel VBA got me to London In 2024, Four million people in the U.S. graduated with a bachelor’s degree. That’s a lot of competition. I’ve been there, wondering how to stand out. Diligence helps, but working smart is the real game-changer. Here’s my advice: Intentionally Embrace Technology (IET). In my experience, Excel users fall […]
The Danger of On Error Resume Next
As a developer, you are in a position to make errors that can have awful consequences. I call them scary errors, the kind people lose their jobs over, the kind that cost real dollars. What follows is an made up example of an error I came across when I was called in to “fix a […]
Fixing other Developers Work – Avoiding Needless Complexity
Craftmanship to aspire to One of my best customers called and asked me if I could fix an app. I knew and was friendly with the original developer. I had helped him with some code several times on zoom. He was new to MS Office development. While I’m always happy to help, fixing other people’s […]