Generate Excel sheet through coding in VB?

[hdave]

Hello,

In my application i am generating execel sheet through coding. But it makes my application very slow.

is there any other more efficient and optimized way to do this.?

is it possible to run pre-defined macro in VB at runtime which accept data and generate excel sheet?

All inputs are welcomed.

Thanks in advance.

[RobDog888]

If the columns are not going to change then you could create a
template. Populate the template with your recordset data and
then view in Excel.

Is this an option?

[hdave]

Hii,

I have never generated template. what should i do? can you provide me example or link to example?

Thanks for quick reply.

HDave

[RobDog888]

Just create a new Workbook and format it the way you want and save it as something.xlt. Thats all there is to it.