i am using visual basic 6.0. i need to know total no of
excel sheet avaiable in one excel file thru vb
program.how to do that?

Thanks
balakumar

xlApp.ActiveWorkbook.Sheets.count

or for worksheets

xlApp.ActiveWorkbook.Worksheets.count

--
Regards,
Tom Ogilvy

balakumar wrote in message
...
i am using visual basic 6.0. i need to know total no of
excel sheet avaiable in one excel file thru vb
program.how to do that?

Thanks
balakumar

Sheets can include both Charts and Worksheets.

For both charts and Worksheets (includeing Excel4 macro sheets)

xlApp.ActiveWorkbook.Sheets.count

For Charts only:

xlApp.ActiveWorkbook.charts.count

For Worksheets only:

xlApp.ActiveWorkbook.Worksheets.count


Bill Barclift


"balakumar" wrote in message
...
i am using visual basic 6.0. i need to know total no of
excel sheet avaiable in one excel file thru vb
program.how to do that?

Thanks
balakumar