How to run an SQL Query in Excel with VBA

I've been making a lot of reports and dashboards combining my love of SQL and Excel lately, so I've put together a neat guide of fully customizable, ultra-commented VBA code to show you how to make a VBA Macro do your SQL bidding. Check it out, and let me know what you think in the … Continue reading How to run an SQL Query in Excel with VBA

Advertisements

Web-scraping Final Fantasy VII with Python & Beautiful Soup

Over the last week I've been figuring out how to web scrape, using some handy tutorials from the internet (mostly this one from Data Science Dojo). I've learnt a lot about Python and Beautiful Soup, and I'm here to share some of that sweet, sweet knowledge with you today! I'm a big fan of video … Continue reading Web-scraping Final Fantasy VII with Python & Beautiful Soup