Can anyone help me?

I am using VB.NET to output data to an Excel 2002 spreadsheet, this works fine.
I would like to know how to change the sheet names and output to a named worksheet and add/remove a named worksheet
Also if possible I would like to subtotal the data on the worksheet.

I can do all this in VBA but for the life of me can't do it in VB, please help.
--
All advice greatfully received

* "=?Utf-8?B?QmFncHVzcw==?=" <(E-Mail Removed)> scripsit:
> I am using VB.NET to output data to an Excel 2002 spreadsheet, this works fine.
> I would like to know how to change the sheet names and output to a named worksheet and add/remove a named worksheet
> Also if possible I would like to subtotal the data on the worksheet.
>
> I can do all this in VBA but for the life of me can't do it in VB, please help.

I doubt that there is a big difference between how to do that in VBA and
via Excel automation. How would you have done it in VBA?

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

Thanks for the quick response.

My VBA code looks lik this;

Sheets("Sheet1").Select
Selection.Subtotal GroupBy:=4, Function:=xlSum, TotalList:=Array(6, 7), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
ActiveSheet.Outline.ShowLevels RowLevels:=2

How can I get VB to do this for me?
--
All advice greatfully received


"Herfried K. Wagner [MVP]" wrote:

> * "=?Utf-8?B?QmFncHVzcw==?=" <(E-Mail Removed)> scripsit:
> > I am using VB.NET to output data to an Excel 2002 spreadsheet, this works fine.
> > I would like to know how to change the sheet names and output to a named worksheet and add/remove a named worksheet
> > Also if possible I would like to subtotal the data on the worksheet.
> >
> > I can do all this in VBA but for the life of me can't do it in VB, please help.
>
> I doubt that there is a big difference between how to do that in VBA and
> via Excel automation. How would you have done it in VBA?
>
> --
> Herfried K. Wagner [MVP]
> <URL:http://dotnet.mvps.org/>
>