Exporting Records to Specific Worksheets and Fields

[Kapelluschsa]

Hey guys,

Right now I have a main table in my database where I am trying to export a group of 50 or so records containing about 100 fields each to excel.

The problem is, my current export code creates a whole new excel sheet with new formatting. I would like to instead add my records to a given worksheet and to have the records start populating at a given row.

An example would be for the data to populate the data sheet "Worksheet 1" at row 11, column A. Any ideas of formatting I should use to approach this? Or if it is even possible?

Thanks guys.

[ssanfu]

There is a lot of info here that might help:

http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm