Report to Excel format

Bob Vance · Aug 30, 2008

Is it possible to send this report to excel format?
Case "MonthlyPaid"

savRepName = "rptGenericReport"
savFileName = "Montly Paid.rtf"
Me.Form.Visible = False
DoCmd.OpenReport savRepName, acViewPreview, , , , Me.OpenArgs
acFormatrtf, savFileName, True

Tom van Stiphout · Aug 30, 2008

On Sat, 30 Aug 2008 13:23:46 +1200, "Bob Vance" <[email protected]>
wrote:

To export data to Excel use DoCmd.TransferSpreadsheet

-Tom.
Microsoft Access MVP

Report to Excel format

Bob Vance

Tom van Stiphout