Previous Thread

6/15/2006 2:48:02 PM    open spreadsheet from Access
I have a macro that is exporting data from a query to a spreadsheet.  the 
 
spreadsheat is recreated all the time I run that macro.  I would like to open 
 
that spreadsheet as soon as the macro finshes exporting.  How will I do that.



6/15/2006 3:55:03 PM    Re: open spreadsheet from Access
On Thu, 15 Jun 2006 14:48:02 -0700, JOM wrote: 
 
Use code. 
 
DoCmd.OutputTo acOutputQuery, "QueryName", acFormatXLS, 
 
"c:\FolderName\FileName.xls", True 
 
Or.. if you are using TransferSpreadsheet, add: 
 
Application.FollowHyperlink "C:\FolderName\FileName.xls" 
 
after the transfer is completed. 
 
-- 
 
Fred 
 
Please respond only to this newsgroup. 
 
I do not reply to personal e-mail