Tips & Tricks
This section contains solutions to problems that have been useful to me in real world applications. These examples have been coded in such a way that they can easily be copied and pasted directly into your own projects and perform as expected. Suggestions and corrections are always welcome.
Excel Tips
- Get a List of Worksheet Names From a Closed Workbook
- Ensure an External Add-In Required by My Application is Loaded
- Trap Events from a Workbook Using a WithEvents Class Module
- Determine the Correct Address String for a RefEdit Control
VBA Tips
- Perform Multiple String Substitutions
- Encrypt and Decrypt Data in My Application
- Shell Out to Another Application and Have My VBA Code Wait for that Application to Finish
- Locate the Window Handle of any Child Window