Open an Excel file from Access

[JohnM]

I want to export a table to Excel then open it .......

DoCmd.TransferSpreadsheet acExport, 3, "Table", "ExcelTable", True

..... exports it ... I would like to open it, and possibly even close Access!

Ideas?

[fredg]

On Tue, 24 Oct 2006 17:07:43 +0100, JohnM wrote:

I want to export a table to Excel then open it .......

DoCmd.TransferSpreadsheet acExport, 3, "Table", "ExcelTable", True

.... exports it ... I would like to open it, and possibly even close Access!

Ideas?

DoCmd.TransferSpreadsheet acExport, 3, "Table",
"C:\FolderName\FileName.xls", True

Application.FollowHyperlink "C:\FolderName\FileName.xls"

DoCmd.Quit

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail