By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

OutputTo Excel

P: n/a
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?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?


Nov 12 '05 #2

P: n/a
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?

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.