Even Microsoft does it. I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions of Excel. Excel for the web doesn’t support VBA procedures.

Creating a working VBA procedure in Excel is the first step. The next step is to use Notepad to write a short script that creates an instance of Excel and runs the macro.

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. <BR><BR>Now I want to ...

Calculating the Dollar Value of a Basis Point Calculating the dollar value of basis points is a straightforward procedure in Excel. As an example, say we have a one-year loan of $1,000,000.

So, my stored procedure returns all the desired data in columns with the column titles and everything. That report now needs to print as an Excel file when the user clicks on a button on a form.