Excel VBA and the Internet

Excel VBA and the Internet

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...
Microsoft 365 or Office 2021: What should you choose?

Microsoft 365 or Office 2021: What should you choose?

Office 2021 or Microsoft 365? Why are there two competing products by Microsoft? What to look for when considering the best choice for you? A brief history of Office software provisioning and consumption Historically, Microsoft dominated the personal computing...
Power BI or Excel VBA?

Power BI or Excel VBA?

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...
SQL Statements to Alter Table from Excel VBA to MySQL Database

SQL Statements to Alter Table from Excel VBA to MySQL Database

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...
Developing Business Applications with Excel VBA and MySQL Server

Developing Business Applications with Excel VBA and MySQL Server

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...
Connecting Excel VBA to MySQL Database

Connecting Excel VBA to MySQL Database

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...
Write Your Own User-Defined Function in Excel

Write Your Own User-Defined Function in Excel

Excel offers hundreds of functions out-of-the-box * SUM(), VLOOKUP(), NPV() – to name a few * What if you need a function to do something unique, not included in the book? The answer: write it yourself! Here is how. Functions in Excel One of the first things you...
Constructing a Dynamic File Name with Excel VBA

Constructing a Dynamic File Name with Excel VBA

Are you automating annual Workbooks, monthly PDF reports, or producing any other dynamic files with Excel? Your program needs to automatically save each file in a folder. Here is how you can construct the full path and filename with a couple of VBA functions What is a...
Staging Data in a Dynamic Report with Excel VBA

Staging Data in a Dynamic Report with Excel VBA

When preparing a dynamic report in Excel, you need to arrange the data in the report structure. In this Blog post I demonstrate how to clear the report range and re-populate it with data. Types of reports Reports can take many forms, as far as presenting data is...
Creating a PDF report from Excel Worksheet with VBA

Creating a PDF report from Excel Worksheet with VBA

Take your Excel model one step further beyond calculations. Prepare and publish the final report as a slick PDF file with a click of a button. Here is how… Why PDF PDF has become to be the standard file format for immutable documents. Immutable, for those not computer...