Report to Excel format

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alter Code for Batch Printing 8
Unable to hide report using acHidden 1
Problems generating reports from a modal dialog 3
Sending Email in txt format 10
Open Report while creating email 1
SendObject 3
Add to text box String 4
Sending Report via Email 3

Back
Top