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
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
There are several useful worksheet functions. See the articles on these functions:
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
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
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
03/17/2014 1:45 pm Link ID: 03172014-6