Excel Samples and Examples

Programming Excel with VBA requires an understanding of the object model. This screen shows an image of the Excel Object Model. The model has many more elements than are shown here, but these are the main objects.

The Workbook Object and Worksheet Object are the containers for all other Excel Objects. Understanding how to reference them in code is essential for programming Excel.

The Excel Range is the most important and versatile object. This article shows basic functions with a range object, such as Copy/Paste, Move and Name. Future article will examine the Excel Range Object in depth.

When running an Excel macro, we often have to select which file or files to process. The Open File article shows how to have an OpenFile dialog box appear. The Read Folder article shows how to read through all the files in a given folder. The files can be filtered by various criteria. There is also an article on how to Save a file after processing.

There are articles on the worksheet functions Sum Product, Sum If, CountA and VLookup. Watch for new articles on additional Excel Functions in the near future.