Output form in datasheet view to excel workbook

[fishtek]

I have created a user interface that display search results on a form in the datasheet view. I am trying to output this form to an excel workbook with multiple worksheets using
DoCmd.OutputTo acOutputForm, "frmBCTable", acFormatXLS, "S:\MikeW_DB\TransferXL.xls"

The form outputs fine but replaces all worksheets in the workbook with a single sheet with the output data. Is there a way to output to a workbook and still preserve all other worksheets. I am using Office 2003.

Thanks for any help.

 

[PHV]

Have a look at the TransferSpreadsheet method

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fishtek]

Thanks for responding PH. I was looking at the TransferSpreadsheet method as well but do not see how it works with a form , only tables and select queries. Can you elaborate on how the method may work using a form in datasheet view. Thanks again.

 

[PHV]

Transfer the underlaying query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886