[AccessD] Code to Copy a query to Excel and Open said file?

Athur,
look at Garry Robinson's 512robinson_SA05l.zip there are a lot of 
interesting features...
E.
----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Saturday, March 04, 2006 5:32 AM
Subject: [AccessD] Code to Copy a query to Excel and Open said file?


>I want to open an Access query and have its contents sent to an Excel file,
> and have Excel open automatically with said file visible. I have played
> around a little with TransferSpreadsheet, and if this method works, then I
> am clearly doing something wrong. I have a sample file resembling the
> desired result in Excel, so I could use that as a template in the "Word"
> sense, but I need some guidance as to how to achieve this, because my
> experiments have all failed. I checked Helen Feddema's site but her
> Access->Excel heading says "Coming Soon".
> Have you any suggestions in the interim?
> TIA,
> Arthur
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com