first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

“Visual Basic for Applications” has 33 entries.

  1. Word 2003 VBA Code: Emergency Repair Routines for Schema Violations; RepairAttributeViolations()
  2. EncryptionServices; Class Module
  3. basIsEmailValid(); This function checks for a valid email address.
  4. Regex Object Is Not Available by Default in VBA; Microsoft VBScript Regular Expressions 5.5 Library
  5. Code: String Handling Functions from 1999; StringServices.bas
  6. Code: Scanning A Root for Files and Directories with Scripting and rasxADO
  7. Word 2000: TogglePicturePlaceHolder()
  8. Word 2000: GetHTMLStyles()
  9. VBA in Outlook
  10. Code: Sending mail from Outlook Express; basSendMail()
  11. Code: basRandomNum(); Generating a Random Number between Upper and Lower Limits
  12. The Differences among Empty, Nothing, vbNull, vbNullChar, vbNullString and the Zero-Length String
  13. "Stupid" Mod Operator Tricks
  14. Start/End of Month Functions basSOM() and basEOM()
  15. Right-Justifying Text with the Format$() Function; Building Text Files with Fixed-Width Columns
  16. Notes on the Val() Function
  17. The Importance of the Call Keyword
  18. The vbYesNoCancel Form with the VBA.MsgBox Statement
  19. Use of the VarType() Function with Optional Function Parameters
  20. OLE Automation: Using Fully Qualified References for Libraries Considered "Default"
  21. Code: Return only Numbers and Digits (Optional) from a String; basGetDigits()
  22. ByVal and ByRef; Functions and Classes
  23. Code: Scanning A Root for Files and Directories
  24. Limitations of the Do Loop
  25. Code: General Error Handling Structure for a Function
  26. Code: The "Are You Sure?" Message in an If...Then Structure
  27. Code: A Seconds Delay with DoEvents; basDelaySec()
  28. Protecting Type Conversion Functions From Null Values
  29. Review of the Data Type Summary: Floating Point Numbers
  30. Using the FreeFile Function
  31. VBA Can't Tell What Day It Is?
  32. Limitations of the Timer Function
  33. Iterating Through a 0-Based Or 1-Based "Logical Group" Via the Number of Items in the Group