AnsweredAssumed Answered

activex automation using excel

Question asked by VRFuser on Jul 19, 1999
Hi Dean,
I also use Excel to store a huge number of results. To spread
these results over a number of pages I use the following
statements.

xl.ActiveWindow.View = xlPageBreakPreview;
sheet1.PageSetup.FitToPagesTall = <number of pages>;

To add a new sheet use

xl.Worksheets.Add;

To produce a horizontal page break, record a macro in excel and
put the recorded lines into VEE objects. Some small changes have
to be made.
Attached are some basic functions.

Regards
Christian


Biotronik GmbH & Co
Woermannkehre 1
D 12359 Berlin - Neuklln
Tel.: +49 30 689 05 - 301
--------------------------------------
christian.wienhold@biotronik.de
--------------------------------------


Outcomes