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 […]
Excel Status Forms – Keep your User informed
You have just spent the last three days perfecting a killer dashboard for Maximum Trucking Inc. It reaches out to 8 different site data sources. The graphics are spot on and identify trends and emerging issues. You run it again to test the final version and realize it takes over two Minutes to run. No, […]
MS Office Developer 18 months in
It has been a year and half since I left the corporate world and hung up my virtual shingle. Well, that is when I published my Microsoft Office Development www.excelandvbacraftsman.com website that is. My side-hustle goals were simple: Generate a modest amount of income while not working full time. Hard work, a lifetime of saving, […]
How to Hire an Excel Expert
How to Hire an Excel Expert First let me clarify Visual Basic for Applications (VBA) is an incredible powerful language and tool. In the right skilled hands, it can do magic. It can control not only Excel, Word, Outlook and Access it can, through the COM (common language interface), control and use many other programs […]
When to call in ‘Excel Help’? Ask yourself these five questions
When to call in “Expert Help’? Ask yourself these five questions When to call in ‘Excel Help’? Ask yourself these five questions As a Freelance Microsoft Office VBA Developer, I needed to have, as a friend says, “wicked mad computer skills” if I was to succeed. Yes, I’ve been a developer a long time though I’ll […]