This section contains a number of examples that have been useful to me in a real world applications. These examples are provided as is. Any support required to customize an example for a specific application will be offered on a work for hire basis only. 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 ] [ Links ]

  Copyright Application Professionals © 1999 - 2008