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

Looking in wrong section these are the examples from Access Newswatch letter
Try here http://www.helenfeddema.com/access.htm
127. Creating Excel Time Sheets from Access Data accarch127.zip
Opens an Excel Spreadsheet inside a Word document from Access query
You may have to muck about with references if keeping  late binding 
especially if you are using different
versions of excel and word , changing type definitions like Excel.Range 
to Variant and removing references,
change file paths and add a couple of Constants.
Const wdUserTemplatesPath = 2
Const xlNormal = -4143 '(&HFFFFEFD1)

Arthur Fuller wrote:

>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada