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, […]
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 […]
Build a Smart Excel Combobox
Like most things in life, Excel VBA users mature as they write code overtime. Every time we search the internet for a vexing VBA problem we learn something. Of course, I hope you take the time to look at more than one solution because there may others that are better or more appropriate. In this […]
The Key File Backup Tool
As any Excel VBA ‘Desk Jockey’ can tell you, the hours melt away when you are coding. Yesterday I was developing some HTML for my website tool and in the ‘wink of an eye’ the morning was gone. Getting the look and feel right was quite a challenge but rewarding when completed.As a VBA freelancer […]