Welcome to Vik’s Software Guide!

Acknowledgements: Content made better by K. Kim!

Abstract

This guide is a collection of references and examples for common commands/examples mainly structured around python, shell (unix/linux/cmd), Microsoft Office related vba and other similar frameworks. All documentation are open source, and can be found on public domain. It was created to help others, in hope that at least one user of these docs may also contribute to a better tomorrow the best way they can.

The objective is to layout concepts and examples step by step in a clear and concise manner with emphasis on the “gotchas”.

Note

Concepts laid out here are not meant to be read from top to bottom. These are merely buckets of concepts. For beginners, start with the 10min intro topics. Future revisions may include a beginner/intermediate/advanced walkthrough.

Support Content Creator

If you enjoyed this library, please consider supporting its creators! Help Today

Feel free to drop a comment on the github page: https://github.com/PydPiper/viks_SoftwareGuide

• 1. Shell Guide
  • 1.1. Linux Quick Start Guide
• 2. Python Guide
  • 2.1. 10min - Python Starter Kit
  • 2.2. Links - Python Awesome List
  • 2.3. builtin - Class (Object Oriented Programming)
  • 2.4. builtin - Tuples, Lists, Sets, Dictionaries
  • 2.5. builtin - Context Manager
  • 2.6. builtin - Copy True/Shallow/Deep
  • 2.7. builtin - Functions
  • 2.8. builtin - File Input/Output (IO)
  • 2.9. builtin - Logic Loops
  • 2.10. builtin - Mutable/Immutable
  • 2.11. builtin - Packaging (managing python imports/files/projects)
  • 2.12. builtin - Strings
  • 2.13. builtin - User Inputs
  • 2.14. builtin - pdb (python debugger)
  • 2.15. lib - Django (web framework)
  • 2.16. lib - pyinstaller
  • 2.17. lib - PyQt5 (GUI)
  • 2.18. lib - pytest
  • 2.19. lib - Sphinx (code documentation)
  • 2.20. lib - Subprocess
  • 2.21. lib - virtualenv
  • 2.22. tool - Git
  • 2.23. tool - pip (Package Installer for Python)
  • 2.24. tool - PyCharm (IDE)
  • 2.25. tool - VScode (IDE)
  • 2.26. tool - vim (text editor)
  • 2.27. DevOps - Continuous Integration (CI)
• 3. VBA Guide
  • 3.1. 10min - VBA Starter Kit
  • 3.2. builtin - Class Modules
  • 3.3. builtin - Enumerations
  • 3.4. builtin - Runtime Errors
  • 3.5. builtin - Events
  • 3.6. builtin- Interapplication Control
  • 3.7. builtin - Logic Loops
  • 3.8. builtin - Subroutines and Functions
  • 3.9. Tips and Tricks
  • 3.10. access - Database Management Systems
  • 3.11. excel - Concatenate Multiple
  • 3.12. excel - Cell Split
  • 3.13. excel - Buffer Data From .csv Without Opening
  • 3.14. office - Create Outlook Email
  • 3.15. office - Hidden Window Background Check
• 4. Shell Guide
  • 4.1. tool - vsCode