Using SQLite with Python

  Data analysis 19 Apr 2020 A SQLite database is perfect for projects where you want a small portable file. I find it has three big advantages over other database, which using it in this regard. First, it comes with the Python distribution so you don’t need to install or configure any addtional software. Second, the entire databae is stored in a single file making cloud storage super easy. And third, there is a light weight GUI plugin for Firefox called...

Hide VBA Modules

  Data analysis 17 Feb 2020 I’ve been using VBA for a while now and I usually lock the VBA project or use Unviewable+ when I need to deter others from viewing or messing with the code. However, I found that pressing ALT+F8 brings up a list of all available procedures. Which makes me wonder, what if someone else who knows about this trys to run a procedure they’re not supposed to? I could easily see how that might cause some...