This is VBA, so you will need to translate to .NET

Sheet names

For Each sh In Activeworkbook
Debug,.Print sh.Name
Next sh

Column names. You mean thge value in Row 1?

Cells(1,"A").Value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Reny J Joseph Thuthikattu" <renyatbxtechdotcom wrote in message
.. .
Hi,
I want to dump some date from a excel file to a database.So i am using
VB.NET , Excel 2003 to do so.I want to know how do i get the names of the
sheets present in a workbook and would like to know is there is any way to
identify the column names in a worksheet??????

Regards

Reny


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.809 / Virus Database: 551 - Release Date: 09/12/04