[AccessD] Exporting two Queries to two different Excel WorkSheets (URGENT)

Paul,

Just use the transferspreadsheet method and use the query names.

Example code line:
DoCmd.TransferSpreadsheet acExport, , strExportQuery, strFileLocation, True

Best,

Bob Heygood



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
paul.hartland at fsmail.net
Sent: Monday, August 18, 2003 1:21 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Exporting two Queries to two different Excel
WorkSheets (URGENT)


To all,

I can't find the last time I done something like this anywhere.....I know
it's pretty straightforward but can't for the life of me figure it out (BIG
Weekend syndrome)......

I have two queries which I need to Export to Excel (Access XP) one to sheet1
and the other to sheet2, then I would like to rename the sheets to match the
queries....i.e. Sheet1 would be renamed to AllShifts, Sheet2 would be
renamed to ShiftTotals etc

Thanks in advance for any help on this as it is pretty urgent

Paul

__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best
Unmetered ISP and Best Consumer Application.


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com