Launching Excel fro within Access 2007

[JimP]

What code would I use to open a specific Access table (e.g. Table1) in
Excel?

 

[Alex Dybenko]

Hi,
you can run docmd.OutputTo with autostart=true, this will export your table
to Excel and open it with exported data

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[JimP]

My mistake. I have a csv file that I created from Access that I now want to
open.

I originally used the "OutputTo" method on a table, but the end user did not
like the column headers (A, B, C...) repeated in the Excel file as the first
row. The only way I found to delete the headers was by exporting to a csv
file.

 

[JimP]

Please dis-regard. Using macro action "RunApp" or "Shell" works.

Thanks.