[AccessD] Macro to export query records to Excel

Doris,

I think you can use the 'TransferSpreadsheet' in a macro and just fill out 
the info at the bottom.  On the next line of the macro use 'RUNAPP' and at 
the bottom(command line) enter:

excel.exe C:\temp\myspreadsheet.xls

replace the path with the path to your file you created.


Good Luck,

Mark A. Matte


>From: DorisH3 at aol.com
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Macro to export query records to Excel
>Date: Tue, 20 Feb 2007 14:22:17 EST
>
>Does anyone know how to write a macro to export query records to MS Excel
>and have the Access macro open the Excel file?   I know I've asked  this
>question once before but I got VB code and I don't know VB, so please  
>excuse the
>fact that I am a novice at this....I thank you in advance for any  help 
>that this
>list extents me.
>
>Doris
><BR><BR><BR>**************************************<BR> Check out free AOL 
>at
>http://free.aol.com/thenewaol/index.adp.  Most comprehensive set of free
>safety and security tools, millions of free high-quality videos from across 
>the
>web, free AOL Mail and much more.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find a local pizza place, movie theater, and more….then map the best route! 
http://maps.live.com/?icid=hmtag1&FORM=MGAC01