Export query to Excel

[Zonie32]

I have a simple query as a command button. I just want to be able to click the button and have the query open in Excel 2003 format.

Anyone have an easy solution? Thanks in advance!

 

[sxschech]

The docmd will export the data to an excel file.
The Follow Hyperlink will open up the excel file.

...
...
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QUERYNAME", "c:\temp\EXCELNAME.xls", True

    FollowHyperlink "c:\temp\EXCELNAME.xls", , True, False
...
...

 

[alvechurchdata]

Thanks for the tip. In the past I've done this the hard way by creating an Excel object:

    Set gobjExcel = CreateObject("Excel.Application")
    gobjExcel.Workbooks.Open Filename:="EXCELNAME.xls"
    gobjExcel.Visible = True

I'll try FollowHyperLink next time.

Geoff Franklin

http://www.alvechurchdata.co.uk