Copy Paste Chart format in Excel 2003 using VB.NET

[MacAndy]

I have a template file in Excel which contains some sample charts. I need to
generate some charts which has the same format as that of sample charts. I'm
using VB.NET 2005.

 

[Jon Peltier]

What we encourage people to do when using VBA is to run the Excel chart
recorder while performing the action they want to do in VBA, then fix up the
inefficient VBA recorded code and incorporate it into their project. You can
do the same thing, although there may be an additional step where you
translate or at least reference the VBA code so it works as VB.Net code.

- Jon