Can I have a button on a form export directly to an xls file?

[mrtauntaun]

And can I have it prompt for the file name? If I can use a default file name, can I have it use today's date Date()?
Thanx!!!!

 

[annsolomon]

You could put it behind the Click event of your button:

DoCmd.TransferSpreadsheet acExport, "tblYourTable", "FileNameIncludingFullPath.xls", True

I'm not sure about prompting. Maybe someone else can help with that. Ann

 

[mrtauntaun]

I am trying to export a report, can I just substitute the Report name instead?

 

[annsolomon]

Take a look at DoCmd.TransferDatabase acExport ...

I haven't used it much and don't recall all the parameters off the top of my head but you should be able to find it easily enough. Ann

 

[pdldavis]

This works for exporting a report to excel.

DoCmd.OutputTo acOutputReport, "YourReport", acFormatXLS, "c:\YourFolder\YourFileName.xls"