p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Opening Excel Files (http://p2p.wrox.com/showthread.php?t=79316)

Kipster1203 May 5th, 2010 01:17 PM

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.

SerranoG May 14th, 2010 10:47 AM

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

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

SerranoG May 14th, 2010 10:48 AM

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

All times are GMT -4. The time now is 06:22 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.