I
ielmrani via AccessMonster.com
Hi,
I have a report gruoped by Owner that I was able to export to an excel sheet
using the following code: DoCmd.OutputTo acOutputReport, "FinalReport",
acFormatXLS, "C:\FinalRep.xls", True
It's working but.. everytime I export it, it creates a brand new report.
I would like to append data from the report to an existing Excel sheet (Name:
FinalRep)that already have these fields name.
Insured Name:
DOB:
Owner:
Bene:
Company Policy# IssueDt FaceAmount
Thanks in advance
I have a report gruoped by Owner that I was able to export to an excel sheet
using the following code: DoCmd.OutputTo acOutputReport, "FinalReport",
acFormatXLS, "C:\FinalRep.xls", True
It's working but.. everytime I export it, it creates a brand new report.
I would like to append data from the report to an existing Excel sheet (Name:
FinalRep)that already have these fields name.
Insured Name:
DOB:
Owner:
Bene:
Company Policy# IssueDt FaceAmount
Thanks in advance