Re: Exporting Multiple Queries from Access into Excel

From: Rob (anonymous_at_discussions.microsoft.com)
Date: 07/26/04 

Date: Mon, 26 Jul 2004 01:59:53 -0700

Thanks very much John, help much appreciated :)

>-----Original Message-----
>Hi Rob,
>
>It's possible but as far as I know undocumented. Use
>DoCmd.TransferSpread*** or the TransferSpread***
macro action, and
>include the *** name you want as the "Range" argument,
e.g.
>
> Docmd.TransferSpread*** acExport, _
> acSpreadsheetTypeExcel9, "MyQuery1", _
> "D:Folder\File.xls", True, "MyQuery1"
>
>Then repeat with the same filename but the other queries
and ***
>names.
>
>
>On Fri, 23 Jul 2004 08:28:19 -0700, "Rob"
><anonymous@discussions.microsoft.com> wrote:
>
>>Is this possible? It may sound like a daft question, but
I
>>am exporting three queries from Access into Excel... at
>>present each is exported to a seperate excel
spread***.
>>Is it possible to export them all to three seperate
>>worksheets within the same spreadsheet. I don't want to
go
>>down the route of union queries and exporting the data
en
>>masse to a single ***, I need to export them
seperately.
>>
>>Any advice appreciated :)
>
>--
>John Nurick [Microsoft Access MVP]
>
>Please respond in the newgroup and not by email.
>.
>