f



Open an Excel file from Access

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? 


0
john9229 (57)
10/24/2006 4:07:43 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
808 Views

Similar Articles

[PageSpeed] 6

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
0
fgutkind1 (959)
10/24/2006 5:59:51 PM
Reply: