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 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 an Application and Have My VBA Code Wait for that Application to Finish
•  Locate the Window Handle of any Child Window

Networking Tips

•  Get Network Information for the Current User
•  Get the IP Address of the Current Computer
•  Get Network Connectivity Information for the Current Computer

  [ Home ] [ About AppsPro ] [ Books ] [ Free Utilities ] [ Tips and Tricks ]

  Copyright Application Professionals © 1999 - 2013