View Single Post
  #1 (permalink)  
Old May 5th, 2010, 01:17 PM
Kipster1203 Kipster1203 is offline
Registered User
Join Date: May 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Opening Excel Files

I am creating an excel file using the following commands (with lots of code before that of course)

DoCmd.TransferSpreadsheet acExport, , "First Pass Yield Chart Query", "W:\edsplus\applications\0cmad\cmad_chart_spreadsh eet.xls", True, "First_Pass_Yield_Data"

DoCmd.TransferSpreadsheet acExport, , "Average Temp Table", "W:\edsplus\applications\0cmad\cmad_chart_spreadsh eet.xls", True, "First_Pass_Yield_Sum_Average"

And this creates the excel file and puts it in the file location folder but I need to know how I can make it so that this file also gets opened, thanks guys.