November - 2022

Search

Parse Phone and Extension with VBA

Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...

Validate Phone Numbers in Excel

Use Excel's formatting and data validation features to validate phone numbers

Using Access to Clean Excel Data, Part 2

Use MS Access to clean phone numbers in your Excel data.

Validation Harness in Excel VBA

Adding a Visual Basic structure to your Excel file for validating data.

Validating a State in Excel

Use Excel tools to validate a U.S. state.

Using Access to Clean Excel Data, Part 1

Excel data can be messy. Use MS Access features to clean it up.

Debugging VBA without Line Numbers

I wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...

Appending Excel Data to an Access Table

Use an append query to add Excel data to an Access table

CATEGORY