Date Text

I want to concatenate a date to a string value, but I want to see a formatted date, like 03/20/2013, not 42399. To do this, create a text representation of the dates. Add a column next to the date column and set the formula for =TEXT(D2, "mm/dd/yyyy") This will convert the date in D2 to a text representation of the date. (They will probably look the same to the human eye, but the computers sees them differently. Use the value in the TEXT column to concatenate to your string.

03/20/2014 1:00 am Link ID: 03202014-66

Worksheet Functions

There are several useful worksheet functions. See the articles on these functions: Sum Product Sum If CountA VLookup Watch for new articles on additional Excel Functions in the near future.

03/17/2014 2:15 pm Link ID: 03172014-114

Excel VBA Samples

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

03/17/2014 1:45 pm Link ID: 03172014-6