Writing Excel VBA Code That Runs on Office 32-bit and 64-bit

Writing Excel VBA Code That Runs on Office 32-bit and 64-bit

Your Excel 2016 program runs perfect on your Excel 2016 32-bit, but fails on Excel 2007, or on Excel 2013 64-bit. Why that happens and how to write a fully compatible VBA program? Here are the answers (and some VBA code) In last week’s Blog post, I explained and...
Calling External Windows Functions (DLL) From Excel VBA

Calling External Windows Functions (DLL) From Excel VBA

Windows offers tons of readily available functions that perform almost any task we need. Why not make use of it in our Excel VBA programs? * Here’s what you need to know about calling DLLs in Excel VBA Modular Programming As you recall from our computer programming...
Excel VBA: How to Check if Printer is Ready

Excel VBA: How to Check if Printer is Ready

Your VBA program needs to send out an original document to the printer. What if the printer is offline, or disconnected? Verify the printer is ready before printing or notify the user of a problem * Here’s the VBA function for that Why check if the printer is ready?...
Can Excel serve as a Database?

Can Excel serve as a Database?

Excel offers large Worksheets. Data can be arranged and stored flexibly, searched and acted upon. Do we have a Database here? * Let’s sort out Excel as a Database. What is a Database? Simply speaking, a database is any structure in which data is to be arranged along...