AnsweredAssumed Answered

activex automation using excel

Question asked by VRFuser on Jul 19, 1999

Like • Show 0 Likes0
Comment • 2

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
--------------------------------------

No one else has this question

Outcomes

VRFuser Jul 18, 1999 9:02 PM

Does anyone know if there is a convenient way to use NI-CAN hardware
with HP-VEE? Any information would be appreciated.

Sincerely,

Jeff Buterbaugh

Actions

VRFuser Jul 19, 1999 9:00 AM

hello,

I am using VEE as an activex controller to store test results in a excel
spreadsheet.

I open an existing excel spreadsheet as my template. Six test
results fill the first page. After the sixth test I would like to create
a new sheet with the existing template as the new sheet but not a new file.
Does anyone know how to do this?

Or if I can just create a Hpagebreak after the sixth test will be suffice.

I am following the excel97weather1.vee as an example with workbooks as my
class.

Also, this example shows how to open an existing file in the installed
directory; HPVEE installed directory.

Does anyone know how to open an existing directory other than the HPVEE
installed directory? For example: C:directoryfilename.vee

Please Advise

Actions

2 Replies

VRFuser Jul 18, 1999 9:02 PM
Mark Correct
Correct Answer
Does anyone know if there is a convenient way to use NI-CAN hardware
with HP-VEE? Any information would be appreciated.

Sincerely,

Jeff Buterbaugh
Like • Show 0 Likes0
Actions
VRFuser Jul 19, 1999 9:00 AM
Mark Correct
Correct Answer

hello,

I am using VEE as an activex controller to store test results in a excel
spreadsheet.

I open an existing excel spreadsheet as my template. Six test
results fill the first page. After the sixth test I would like to create
a new sheet with the existing template as the new sheet but not a new file.
Does anyone know how to do this?

Or if I can just create a Hpagebreak after the sixth test will be suffice.

I am following the excel97weather1.vee as an example with workbooks as my
class.

Also, this example shows how to open an existing file in the installed
directory; HPVEE installed directory.

Does anyone know how to open an existing directory other than the HPVEE
installed directory? For example: C:directoryfilename.vee

Please Advise
Like • Show 0 Likes0
Actions

activex automation using excel

Outcomes

Related Content

Recommended Content