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 your VBA program

Why Internet with Excel VBA?

I remember back in the 1990’s, the biggest question in the corporate IT scene was: Will the Internet ever be of value to businesses and penetrate the holy sanctuary of the LAN?

How things become absurd with time, just like the law stating that it’s illegal for a woman to...

Continue Reading...

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 courses approached me this week with this question.

He noted a shift from Excel to Power BI in his workplace and asked about my point of view on the two.

Lucien mentioned that he is more of an “Excel/VBA person” and that the Power BI reports seem slow and not interactive.

What a great question to call for a Blog post!

...
Continue Reading...

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 continues the current series dealing with building robust business applications with Excel VBA and MySQL Database.

If you have not read the previous posts about preparing MySQL Server and Excel for communications and connecting and sending SQL Select statements, read them first.

What are DDL and DML statements?

In the Databases...

Continue Reading...

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 prepared!

Last week, I guided you through setting up MySQL server and Excel so that they can communicate with one another.

If you don’t have a ready environment for Excel VBA to talk with MySQL server – complete this first and jump back afterwards.

As I want to focus on writing SQL queries from VBA, I will assume...

Continue Reading...

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 you dig what I am talking about?

In case you miss the outstanding promise of that title up here, you are about to discover a new world of capabilities and opportunities you have never imagined with Excel.

Most of the business application running our world’s economy (all organizations out there) – rely on a strong...

Continue Reading...

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 dynamically constructed file name?

When you save a file, you need to point to a particular folder and give it a name.

Your 2022 P&L Workbook may have the following path and file name: \\Shared-Server\Financials\P&L\2022.xlsm

Instead of you manually browsing to the destination folder and typing a filename when you...

Continue Reading...

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 programmers yet, means it cannot be changed once it is created.

PDF is highly popular for its quality, compactness, and the ability to sign electronically to render a formal document accepted by private and public institutions.

Preparing the report

What I always do, is dedicate a Worksheet for staging the report. This...

Continue Reading...

Frequently Asked Questions on the Excel VBA Inner Circle Program

I received many questions on The Excel VBA Inner Circle program since it was launched. I summarize here the most frequent questions and my answers to them.

Last week I published a Blog post I thought would be all you may need in order to choose the right Inner Circle plan for you.

However, I am still getting some questions from some Excel enthusiasts about the program.

Today’s post is dedicated to those still having questions.

Frequently Asked Questions

Q:           I already learned Excel VBA and get along pretty well. Why should I...

Continue Reading...

A story about a customer request and the delivered Excel VBA solution

A rare glimpse of the “behind the scenes” work on an Excel project. From the raw customer request through the business requirements analysis report up to the delivered solution. Impressions from the first Excel VBA Inner Circle workshop.

The first Excel VBA Inner Circle monthly workshop took place two days ago.

The monthly workshop is a deep dive into some aspect of Excel VBA and SQL programming and career. I expose advanced VBA programming, code, user experience considerations, data design and processes planning, and any professional aspect having to do with Excel VBA and SQL.

...
Continue Reading...

Excel VBA: Arrays

Arrays, one of the most flexible, performant and popular data structure in almost any programming language becomes especially useful in Excel. All you need to know about arrays in VBA is right here

In case you missed it, the last month in my Blog was dedicated to data structures in computer programming and their use in Excel VBA. After we covered Enumerations, Collections and User-Defined Data Types, we close this week with a grand finale: Arrays.

What is an Array?

An array is a memory storage structure for storing an indexed series of elements of the same data type.

This is how we would...

Continue Reading...
1 2 3 4
Close

50% Complete

Two Step

Once you submit your details, you'll receive an email with a confirmation link. That's it! you're subscribed!