This download expands on my earlier post “When Excel is Overwhelmed: Access Excel Integration”, where I demonstrated how offloading data to an Access database can dramatically reduce file size, eliminate VLOOKUP-heavy sheets, and improve performance. In this follow-up, I take the concept further by introducing cached UDFs (User-Defined Functions) that connect Excel to Access only […]
Dynamic Gantt Chart with open code
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 to these shapes […]