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
--------------------------------------
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
--------------------------------------
with HP-VEE? Any information would be appreciated.
Sincerely,
Jeff Buterbaugh