TechRepublic

How to automate entering dates with VBA in a Word document

How to automate entering dates with VBA in a Word document Your email has been sent Illustration: Lisa Hornung, Getty Images/iStockPhoto Must-read Windows coverage CrowdStrike Outage Disrupts ...
TechRepublic

Export your VBA code for use in another Excel application

Export your VBA code for use in another Excel application Your email has been sent After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few ...
Houston Chronicle

How to Program a "Save As" Button in Excel VBA

Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...
Ars Technica

VBA: Connection string results in "External table is not in the expected format"

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the most ...