Hello,
I want to receive the worksheet names for random Excel sheets, the below
mentioned solution works for most excel sheet but with the most important one
I get too many excel sheets in this format

'WS1$' ''this one works
'WS1$'print_tables
'WS2$'Z_XX_XXX
'WS2$'Print_area

Where does the stuff after the $' come frome and how can I avoid this and
just receive the actual worksheet names ('WS1$') and at best in the order the
occur in the document and not alphabetically.

Thanks very much for your support and I hope i phrased the question in an
understandable fashion
Jörg


Code to get the Excel schema
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
worksheets = connection.GetSchema("Tables");
}

Does this help?
Sub ShtNames()
n1 = ActiveWorkbook.Sheets.Count
ReDim ShtNames(n1)
For i1 = 1 To n1
ShtNames(i1) = Worksheets(i1).Name
Next
End Sub


"joerg.schad" wrote:

> Hello,
> I want to receive the worksheet names for random Excel sheets, the below
> mentioned solution works for most excel sheet but with the most important one
> I get too many excel sheets in this format
>
> 'WS1$' ''this one works
> 'WS1$'print_tables
> 'WS2$'Z_XX_XXX
> 'WS2$'Print_area
>
> Where does the stuff after the $' come frome and how can I avoid this and
> just receive the actual worksheet names ('WS1$') and at best in the order the
> occur in the document and not alphabetically.
>
> Thanks very much for your support and I hope i phrased the question in an
> understandable fashion
> Jörg
>
>
> Code to get the Excel schema
> string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
> using (OleDbConnection connection = new OleDbConnection(connectionString))
> {
> connection.Open();
> worksheets = connection.GetSchema("Tables");
> }
>
>

The ActiveWorkbook Object is only referring to the currently open Excel
Sheet, or how can I declare on eExcel Workbook as active?
I need to access those excel documents on a server (without Excel...)
Still thank you very much for your answer
Jörg

"Gleam" wrote:

> Does this help?
> Sub ShtNames()
> n1 = ActiveWorkbook.Sheets.Count
> ReDim ShtNames(n1)
> For i1 = 1 To n1
> ShtNames(i1) = Worksheets(i1).Name
> Next
> End Sub
>
>
> "joerg.schad" wrote:
>
> > Hello,
> > I want to receive the worksheet names for random Excel sheets, the below
> > mentioned solution works for most excel sheet but with the most important one
> > I get too many excel sheets in this format
> >
> > 'WS1$' ''this one works
> > 'WS1$'print_tables
> > 'WS2$'Z_XX_XXX
> > 'WS2$'Print_area
> >
> > Where does the stuff after the $' come frome and how can I avoid this and
> > just receive the actual worksheet names ('WS1$') and at best in the order the
> > occur in the document and not alphabetically.
> >
> > Thanks very much for your support and I hope i phrased the question in an
> > understandable fashion
> > Jörg
> >
> >
> > Code to get the Excel schema
> > string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data
> > Source=Book1.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
> > using (OleDbConnection connection = new OleDbConnection(connectionString))
> > {
> > connection.Open();
> > worksheets = connection.GetSchema("Tables");
> > }
> >
> >