opening report directly to Excel

[ChrisBair]

How do you create a command button to open a report directly into excel, without exporting?

Thanks

 

[HomeALone]

Put this code into the command button

DoCmd.RunCommand acCmdOutputToExcel

Hope it works for you!

 

[KenReay]

Hi

There are several variations available here

To begin, see docmd.outputTo, and docmd.TransferSpreadsheet in help, you could also open your result set simply as a query result grid, which LOOKS like an excel spreadsheet but is not, you can set it such that user cannot amend the output recordset,

depends on what you are trying to achieve

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK