Between the 2003 and the most recent versions, the number of rows that can be reached in an Excel sheet has changed significantly. As a result, the VBA codes prevent the portability of your workbook ...

An alternative to the limited vba Mod() function. One of the (multiple) probelms with Excel VBA's Mod() function is that it does not support decimals. Mod() will evaluate a single or double as an ...

Since version 0.16.0 ZXing.Net contains a special assembly which can easily used from VBA via COM Interop. The assembly is a wrapper arround the core functionality of ZXing.Net. It makes the API ...

10+ of my favorite Windows API functions to use in Office applications Your email has been sent When a VBA solution falls short of your needs, there's probably a Windows API function that can handle ...