Exporting a record to specific fields in excel

[RevJeff]

Hi Everyone,

I'm wondering if it is possible to export certain data fields to specific cells in excel.

ie.

LastName exports to A3
FirstName exports to C8
DOB exports to H2

and so on...

Thanks for your help!

Jeff

 

[pbaldy]

This should get you started:

http://support.microsoft.com/kb/247412

 

[ria.arora]

Below is the example to start:

    ColumnStart = 1
    RowStart = RowStart + 1
    objXLSheet.Cells(RowStart, ColumnStart) = "Revenue"
    ColumnStart = ColumnStart + 1
    objXLSheet.Cells(RowStart, ColumnStart) = "Vol Revenue"

Execute the SQL
Using the resultset start writing to particular cells:

    RowStart = RowStart + 1
    For iCount = 1 To recCount
        ColumnStart = 1
        objXLSheet.Cells(RowStart, ColumnStart) = rsTmp![Banker]
        ColumnStart = ColumnStart + 1
        objXLSheet.Cells(RowStart, ColumnStart) = rsTmp![Income YTD]
        ColumnStart = ColumnStart + 1
        objXLSheet.Cells(RowStart, ColumnStart) = rsTmp![VolRevenue]
        ColumnStart = ColumnStart + 1