by mor | Mar 11, 2021 | Blog
Have you ever needed to get data over the Internet into your VBA program? * Maybe your automation process require that your VBA application update another system using Internet protocols? * Today we explore and demonstrate how to integrate Internet-based systems with...
by mor | Feb 25, 2021 | Blog
What is the purpose and difference between Power BI and Excel VBA * When to use what * Or maybe you can use both? * Here is my take on the role Power BI and Excel VBA can play in your setting. Lucien, one of the professional Excel VBA experts following my Blog and...
by mor | Feb 18, 2021 | Blog
Send any SQL statement for execution by a remote Database Server from your VBA program * DDL statements allow you to create and alter the schema from your program * Today we write a generic VBA function for adding a column to a table in the Database This Blog post...
by mor | Feb 11, 2021 | Blog
Turn Excel into a powerful information systems development platform * Enjoy the power of a relational Database in your Excel VBA applications * Business applications like you never thought possible with Excel * Today we write SQL queries from Excel VBA to MySQL DB Be...
by mor | Feb 4, 2021 | Blog
Turn Excel into a powerful information systems development platform * Enjoy the power of a relational Database in your Excel VBA applications * Business applications like you never thought possible with Excel * Today we setup and prepare Excel VBA and MySQL Server Do...
Recent Comments