How to Get Sheet Names in Excel File. 1

[gazal]

Hi Friends

I am developing a small application which will upload data from excel files to SQL Server using VB 6.
The Work Books may have many sheets in it.
So before upload i want to show the user all the sheet names in the selected work book. so then user can choose from which sheet he wants to upload data.

I tried something using Excel Object but can get only the Count not the Sheet Name.

Any Help will be appreciated

Thanks in advance

Gazal

 

[vb5prgrmr]

Ok, here is a hint for you...

This is an example adapted from the excel help files that you should be able to figure out how to adapt...

[tt]
Dim S As Sheets
Dim W As Worksheet
Set S = Application.Worksheets
For Each W In S
MsgBox W.Name
Next
[/tt]

Good Luck

 

[gazal]

hi Vb5Prgmr

Again u have been of great help to me... thanks buddy

Gazal