resources from the field
Articles, guides, solutions, tools, templates, code snippets, and tips from the team.
| Date | Title | Topics | Description |
|---|---|---|---|
| Aug 3, 2026 | Global or Local, That Is the Question | Excel | Best Practices | Excel developers have debated workbook-level (global) versus worksheet-level (local) defined names for decades. Here are the pros, the cons, and a clear recommendation. |
| Jul 19, 2026 | Global/Generic Visual Basic Error Handling is Useless but There is a Better Way | VBA | Best Practices | Methodology | Development | Global/generic Visual Basic error handling is misleading and creates a false sense of stability. The more it is used, the more errors are masked and the more difficult our job is as we strive to create bug-free applications. |
| Jul 19, 2026 | Handling the Obfuscation of ThisWorkbook.Path and .FullName for OneDrive and Sharepoint Files | VBA | A workaround to convert the obfuscated OneDrive and Sharepoint URLs returned by these two properties into valid local file paths. |
| Jul 16, 2026 | Wordle Helper | Tools | A free Excel tool that narrows down the possible Wordle answers based on your guesses without giving away the answer. |
| Jul 15, 2026 | Data Automation Professionals Development Methodology | Development | Methodology | We take our projects very seriously and follow a time-proven development process. Learn about our overall solutions development methodology, proven hybrid project management, and best practices for generating clean, fast, efficient, and bug-free code. |
| Jul 15, 2026 | Excel Automation in an AI World: The Good, The Bad, and the Truth | AI | VBA | Development | Best Practices | AI is here and it is not going away. But will it replace experienced Excel automation developers? Not anytime soon. Here is why the how matters more than the what. |
| Sep 1, 2024 | That Whacky Conditional Compiler Argument | VBA | Development | VBA's conditional compilation constants look like Booleans but they are not, and the difference will bite you every time you use Not with Win64. |
| Dec 19, 2023 | Unlock Password Protected Worksheet or Workbook | VBA | A VBA macro to unprotect a sheet or workbook without the password. |