Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the sheet names present in a work book????
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the sheet names present in a work book????
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting the sheet names present in a work book????
Thanx .I am able to figure it out
Dim xlApp As Excel.Application Dim xlWB1 As Excel.Workbook Dim x1WS1 As Excel.Worksheet xlApp = New Excel.Application() xlApp.Visible = True xlWB1 = xlApp.Workbooks.Open("C:\2004.xls") For Each x1WS1 In xlWB1.Worksheets MsgBox(x1WS1.Name()) Next xlWB1.Close() xlApp = Nothing Reagdrs Reny "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 --- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Work sheets tab names only replace part ot the present name | Excel Worksheet Functions | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Moving a row to new work sheet/book if order=yes | Excel Programming |