3 Real Automation Demos (Excel VBA, SQL & Python)
In this session, I walk through 3 real-world automation demos using Excel VBA, SQL, and Python — showing how these tools work together in real business workflows.
What you’ll see in this video:
🔹 VBA: Consolidate multiple Excel files automatically
🔹 SQL: Use an Excel UserForm to dynamically build SQL queries
🔹 Python: Combine data from different systems using a shared ID
These are the kinds of automations I actually use when building solutions for real workflows — no theory, no fluff.
👉 Full step-by-step SQL UserForm tutorial is linked in the pinned comment.
📲 Follow me for daily content on Excel VBA, SQL, Python, and AI automation:
🔗 Instagram: / excel_vba_automation
🔗 TikTok: / jacob.automation
🛠️ Automation tools & templates: https://www.etsy.com/dk-en/shop/Excel...
Download my FREE Automation Toolkit here:
https://jacobautomation.gumroad.com/l...