https://rondebruin.nl https://vbaexpress.com https://analystcave.com https://powerspreadsheets.com/
BASH – Shell script to call Python script with arguments
To execute a python script in a bash script you need to call the same command that you would within a terminal. > python python_script.py var1 var2 To access these variables within python you will need import sys print sys.argv[0] # prints python_script.py print sys.argv[1] # prints var1 print sys.argv[2] # prints var2
VBA – The Golden Rules
The following Rules are from Ozgrid's site. 1 Turn on Option Explicit. Tools>Options - Editor - Require variable declaration in the VBE. Then Educate Yourself on Their Proper Use and Data Types. 2 Split Procedures Into Logical Separate Separate Procedures and use Call or Run When Needed. 3 Make Good use Of Functions so They … Continue reading VBA – The Golden Rules
Linux – Install Webmin, Let’s Encrypt and Apache on Ubuntu Server 18.04.
Well documented step-by-step instruction by DigitalOcean http://www.digitalocean.com/community/tutorials/how-to-install-webmin-on-ubuntu-18-04
iOS – Install CocoaPods
1. Open Terminal. 2. Enter $ sudo gem install cocoapods command in terminal. 3. Create new Xcode project. 4. Navigate to directory containing Xcode project. Use cd “../directory-location/..” or cd [drag-and-drop project folder] 5. Pod install.
Linux – How to resize Linux partition with Gparted?
How to resize Linux partition with Gparted — Read on geekyshacklebolt.wordpress.com/2018/03/13/how-to-resize-linux-partition-with-gparted/
Disk Imaging – Clonezilla
Easy to use disk and partition imaging tool. Clonezilla can be run from live CD or USB drive. clonezilla.org/