OutputTo Excel

[Randy Harris]

I'm using OutputTo to send data into Excel. It has been working nicely.
Now, I need to add more worksheets using OutputTo. Whenever I use it, it
replaces the existing worksheet. Is there any way to get OutputTo to create
more than one worksheet?

[Tom van Stiphout]

On Thu, 02 Oct 2003 04:49:13 GMT, "Randy Harris" <ra***@SpamFree.com>
wrote:

No.
You'll have to use the much more powerful capabilities of Automation.
Create an object of type Excel.Application, and then call the methods
available in the Excel object model. The model is documented in an
Excel help file, which is an optional part of the setup program. So
make sure you do a full install.

-Tom.

I'm using OutputTo to send data into Excel. It has been working nicely.
Now, I need to add more worksheets using OutputTo. Whenever I use it, it
replaces the existing worksheet. Is there any way to get OutputTo to create
more than one worksheet?

[Randy Harris]

My sincere thanks to both Tom and Pieter. I spent most of the night,
tearing out the little hair I have left, trying to get OutputTo to work.
The rest of the night I spent trying to do it with FormulaArray and
Transform, based on a single example in the A2K Developers Handbook. Never
could get that to work at all.

I found the samples you guys recommended, the automation works great. The
CopyFromRecordset Method used is really simple and incredibly fast.

Randy

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:d7********************@newssvr28.news.prodigy .com...

I'm using OutputTo to send data into Excel. It has been working nicely.
Now, I need to add more worksheets using OutputTo. Whenever I use it, it
replaces the existing worksheet. Is there any way to get OutputTo to create more than one worksheet?