vba pdf book notes download for free


About Book

This book has 100+ pages that cover the basic to advanced topic of VBA with practical program and code examples. if you want to learn VBA then this book is for you. this book is developed by professional programmers for educational purposes.


Book contents

  1. Getting started with VBA
  2. comments
  3. string literals - escaping nonprintable characters and line continuations
  4. VBA option keyword
  5. declaring variables
  6. declaring and assigning strings
  7. concatenating strings
  8. frequently-used string manipulation
  9. substrings
  10. searching within strings for the presence of substrings
  11. assigning strings with repeated characters
  12. measuring the length of strings
  13. converting other types of strings
  14. date time manipulation
  15. data types and limits
  16. naming conventions
  17. data structures
  18. arrays
  19. copying, returning and passing arrays
  20. collections
  21. operators
  22. sorting
  23. flow control structures
  24. passing arguments byref or byval
  25. scripting filesystem object
  26. working with files and directories without using filesystem object
  27. reading 2GB+ files in binary in VBA and file hashes
  28. creating a procedure
  29. procedure calls
  30. conditional compilation
  31. object-oriented VBA
  32. creating a custom class
  33. interfaces
  34. recursion
  35. events
  36. scripting dictionary object
  37. working with ADO
  38. attributes
  39. user forms
  40. createobject vs getobject
  41. non-Latin characters
  42. API calls
  43. automation or using other applications libraries
  44. macro security and signing of VBA projects modules
  45. VBA run-time errors
  46. error handling