Excel/VBA Archives - Excel and VBA Craftsman

Dynamic Gantt Charts

Posted on March 27, 2025March 28, 2025 by raymond Posted in Excel/VBATagged advanced excel Gannt Charts, Dynamic Gannt Charts, Dynamic Gantt Chart, Event Handling VBA, Excel, Excel Automation, Excel Bar Chart, Excel for Business, Excel Formulas, Excel Free Download, Excel Project Management, Excel Project Planning, Excel Project Tracker, Excel Tips, Excel Tutorial, Excel VBA, Excel VBA for Projects, Excel VBA Shapes, Free VBA Resources, Gantt Chart, Gantt Chart Example, Gantt Chart Excel, Gantt Chart VBA, Project Management, VBA, VBA Code, VBA for Beginners, VBA for Project Management, VBA Gantt Charts, VBA Programming, VBA Shapes, VBA Shapes for Gantt Chart, VBA TutorialLeave a Comment

Dynamic Gantt Charts In this video, I demonstrate how to create a dynamic Gantt Chart in Excel using VBA, including annotated “Event” diamonds to highlight key moments, like delays due to vandalism or bad weather. You’ll learn how to: Use VBA to create and add shapes (rectangles and diamonds) for chart visualization. Add event-specific code […]

Excel Auto Backup Tool (Free)

Posted on March 23, 2025April 3, 2025 by raymond Posted in Excel/VBA, UncategorizedTagged Auto Backup Excel Files, Backup Excel Files Automatically, Backup Excel Files to Zip, Backup Tool for Excel, Excel Auto Backup, Excel Backup Tool, Excel File Backup Software, Excel File Safety, Excel File Versioning, Excel Version Control, Excel Version History, Excel Zip Backup, Secure Excel BackupLeave a Comment

In today’s fast-paced, data-driven world, businesses of all sizes rely on spreadsheets for everything from daily tasks to business-critical operations. However, despite their importance, many overlook the risk of losing these invaluable files due to corruption or human error. That’s where the Free Excel Backup Tool comes in. This tool is designed to protect your […]

Excel Calendar Add-in Tool (Free)

Posted on November 16, 2024April 3, 2025 by raymond Posted in Automation, Excel/VBA, Freelance MS Office Developer (VBA)Tagged Automated Excel Calendar, Business Calendar Tool, Cost-Effective Calendar Solution, Custom Excel Calendar, Custom Excel Planner, Custom Excel Tools, Custom Scheduling Calendar, Excel Calendar Automation, Excel Calendar Data Reporting, Excel Calendar Design & Branding, Excel Calendar for Business, Excel Calendar for Construction, Excel Calendar for Healthcare, Excel Calendar for Retail, Excel Calendar for Staff Scheduling, Excel Calendar Forecasting, Excel Calendar Integration, Excel Calendar Software, Excel Calendar with VBA, Excel Event Planning Calendar, Excel Scheduling Tool, Excel Task Management Calendar, Excel Workflow Calendar, Industry-Specific Excel Calendar, Project Management Calendar, Resource Management Excel Calendar, Tailored Excel CalendarLeave a Comment

https://youtu.be/lxR1HnjfQqQ Unlock the Power of Customization with My Excel Calendar Add-In! Welcome to my website, I’m showcasing my custom-built Excel Calendar add-in that’s designed to give you full control over your calendar’s appearance and functionality. Whether you need to mark specific days off, adjust the start of your week, or display up to four months […]

Hiring The Right Excel, Access, Word VBA Automation Expert

Posted on October 17, 2024December 27, 2024 by raymond Posted in Automation, Excel/VBATagged Access automation specialist, Access database design, Benefits of hiring a VBA developer, Custom Access and Excel solutions, Excel Access Word integration, Excel automation services, Excel VBA expert, Hire VBA programmer, How to hire an Excel VBA expert, Microsoft Office Developer:, Microsoft Office programming solutions, VBA automation expert, Word macro development, Word VBA programmerLeave a Comment

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

Posted on December 19, 2022 by raymond Posted in Excel/VBATagged Excel Help, Excel Macro Expert, Freelance MS Office Developer, Learn Excel;, on Error Resume Next, VBA Expert

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 […]

Category: Excel/VBA

Dynamic Gantt Charts

Excel Auto Backup Tool (Free)

Excel Calendar Add-in Tool (Free)

Hiring The Right Excel, Access, Word VBA Automation Expert

The Danger of On Error Resume Next

Contact Me