Brian,
Thank you for your response, but that explanation from the help file, which
does not apply in this case, is the reason why I resorted to this newsgroup.
I did, however, find the answer by searching the newsgroup via the web
interface which allows me to search as far back as 2004 (my OE does not
download headers that far back and I didn't find how to make it do it). The
applicable explanation is found in the Alternative Method at the bottom of
this article: http://support.microsoft.com/kb/196743/en-us
The reasons why the Alternative method works better are given in my post to
Karl Timmermans on this same thread.
--
Cheers,
Alphonse


"Brian Tillman" wrote in message
...
Alphonse wrote:

I have received and Excel file with Contact information; all the
headings, Title, First Name, etc. are correctly placed at the top of
each column, but when I try to import the xls file I receive a
message stating "The MS Excel file [path\filename] has no named
ranges. Use Excel to name the range of data you want to import."
I don't understand what it means by "named ranges"... I have looked
in XL but have not found anything that helps. Can someone please tell
me how to do this?

Did you look in Excel's Help? Here is a description from that Help:

Name cells in a workbook

You can use the labels of columns and rows on a worksheet to refer to the
cells within those columns and rows. Or you can create descriptive names to
represent cells, ranges of cells, formulas, or constant values. Labels can
be used in formulas that refer to data on the same worksheet; if you want to
represent a range on another worksheet, use a name.

You can also create 3-D names that represent the same cell or range of cells
across multiple worksheets.

Name a cell or a range of cells

Select the cell, range of cells, or nonadjacent selections that you want to
name.
Click the Name box at the left end of the formula bar .

Type the name for the cells. Press ENTER.
--
Brian Tillman [MVP-Outlook]