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.

How about using something like this, for example, afterwards?

Application.FollowHyperlink "W:\edsplus\applications\0cmad\cmad_chart_spre adsh eet.xls"

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division

I edited my reply but since they also get e-mailed, the edit doesn't get e-mailed to you as well.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division