Exporting to a named worksheet and workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 28 Mar 2006 23:40 GMT

Hello,

I have used the DoCmd.OutputTo to export data from a query to a user defined
.xls file.

I now want to export data to a Sheet2 in a spreadsheet, which I know the
name of.

I am not clear whether the parms in DoCmd.OutputTo allow for a worksheet to
be named as the destination of the export.

Any ideas?

Signature

David

Reply to this Message

John Nurick - 29 Mar 2006 05:33 GMT

Hi David,

You can't do this with OutputTo. Instead, use TransferSpreadsheet and
specify the worksheet in its Range argument.

>Hello,
>
[quoted text clipped - 8 lines]
>
>Any ideas?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Klatuu - 29 Mar 2006 14:57 GMT

Note the Help file will tell you TransferSpreadsheet will fail if you try to
use the Range argument for an export. That is not true, it does work.

> Hi David,
>
[quoted text clipped - 18 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

David - 29 Mar 2006 16:02 GMT

That did the trick. Thanks John.

Signature

David

> Hi David,
>
[quoted text clipped - 18 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message