Getting query into Excel

[H. Martins]

Hi,

If I do: RunCommand acCmdOutputToExcel
.... It opens Excel and presents present form data.

If I do DoCmd.TransferSpreadsheet acExport, , "qryQuery",
"fileFilename"
.... it generates a xls file containing query data

What about if I want the query data to be presented in Excel (itself),
not to be stored in a file?

Thanks
Henry

 

[golfinray]

http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ImpAllWkshts
This site I think will give you about every Excel ap possibility. You may
have to dig through there a little. Good luck!