| # Fetch latest configuration: | |
| */5 * * * * cd /home/ubuntu/dogsheep-config && python3 git_pull_and_run_scripts.py . && sudo python3 ensure_symlinks.py files-to-symlink | |
| # Goodreads | |
| 46 * * * * cd /home/ubuntu && /home/ubuntu/datasette-venv/bin/goodreads-to-sqlite books goodreads.db -a auth.json | |
| 1,11,21,31,41,51 * * * * /home/ubuntu/datasette-venv/bin/twitter-to-sqlite user-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since | |
| 2,7,12,17,22,27,32,37,42,47,52,57 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite home-timeline /home/ubuntu/timeline.db -a /home/ubuntu/auth.json --since | |
| 4,14,24,34,44,54 * * * * run-one /home/ubuntu/datasette-venv/bin/twitter-to-sqlite mentions-timeline /home/ubuntu/twitter.db -a /home/ubuntu/auth.json --since |
| ssh-keygen -t rsa -b 4096 -N '' -C "rthijssen@gmail.com" -f ~/.ssh/id_rsa | |
| ssh-keygen -t rsa -b 4096 -N '' -C "rthijssen@gmail.com" -f ~/.ssh/github_rsa | |
| ssh-keygen -t rsa -b 4096 -N '' -C "rthijssen@gmail.com" -f ~/.ssh/mozilla_rsa |
| # see rkengler.com for related blog post | |
| # https://www.rkengler.com/how-to-capture-network-traffic-when-scraping-with-selenium-and-python/ | |
| import json | |
| import pprint | |
| from selenium import webdriver | |
| from selenium.webdriver.common.desired_capabilities import DesiredCapabilities | |
| capabilities = DesiredCapabilities.CHROME |
Copy and paste code into two modules in a blank workbook
Open the workbook with the password-protected VBA
Then run the sub 'unprotected' in MODULE 2
Credit to lessthanleo from reddit https://www.reddit.com/r/excel/comments/fabob8/at_work_we_use_an_excel_program_that_compiles/fix1b65/
| { | |
| "meta": { | |
| "theme": "kwan" | |
| }, | |
| "basics": { | |
| "name": "Robert Engler", | |
| "label": "Analyst & Software Developer", | |
| "picture": "https://www.rkengler.com/me.jpg", | |
| "email": "rengler33@gmail.com", | |
| "phone": "", |