ActiveX script to read in column headers from Excel

[Andy S.]

Is there a script out there that can read in all the column headers from a
worksheet? I'm trying to write code that will go to a particular
spreadsheet and set up the transformations for DTS, but I need to be able to
check whether or not columns are there in advance. Thanks.


--

*************************************************
Andy S.
(e-mail address removed)

Please remove "noreply" before replying.

*************************************************

 

[Andy S.]

I found my answer on Microsoft MSDN website. I'm going to use the Cells
property of the Excel Application object.