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.

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.

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 ...

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.