Export in visual basic

[hakimuddink]

Hi All

In my application i am generating bills for the customer. I am not using DataReport Designer or crystal report for this purpose. I am designing a form with some label controls and a hierarchical flexigrid control . Now i want to have export and print functionality on my Form . I am able to print the form but how do i export all the text which is in labels and hierarchical flexigrid to an html file or any other format.

Please someone address this issue as soon as possible

[BrianB]

I think you may have posted in the wrong forum. This one is for Visual Basic for Applications (not Visual Basic). which refers to the Microsoft Office range of applications. If you have a query specific to one of these, eg. Excel, Word please specify.

[hakimuddink]

Then Please let me know in which forum should i post my query.

Thanks

[Dave Sell]

He could ask "How do I export my DataGrid to an Excel spreadsheet?"

I dunno, but I have a function to export an ADO Recordset to an Excel spreadsheet. Here is the functrion definition:

Sub RecordsetToSheet( _
    rstSource As ADODB.Recordset, _
    wksSource As Excel.Worksheet, _
    strFileName As String)

Let me know if you want it.