AnsweredAssumed Answered

vrf Plotting in Excel using VEE

Question asked by VRFuser on Feb 13, 2003
Hello Al,

For my $20-00 worth I would recommend an O'Reilly book by Steve Roman with the attention grabbing title Writing Macros for Excel (or something like that).  It is really targeted at the VBA user, but since all the syntax in VEE is pretty much the same, it should not make any difference.  The really good thing is that it provides good explanation of the Excel object model.  Just take a little care since VEE does not support all the VBA syntax constructs.

When I am using Excel I tend to use templates/skeletons a lot - cuts down the amount of programming of Excel from VEE.  The approach would be 1) create your Excel sheet and save 2) Use VEE to fire up Excel and open this template 3) squirt in the data into the correct columns 4) save the Excel sheet 5) close excel down (sometimes easier said than done!)

That's about it.  I found the book very useful when I first started trying to program Excel.

Hope this helps

Andy
--------------------
Andy Street
Technical Consultant
Agilent Technologies
Tel: +44-1189-275395
Mob: +44-7765-897003
Fax: +44-1189-276862

-----Original Message-----
From: Garvin, Al [mailto:al.garvin@lmco.com]
Sent: 13 February 2003 18:00
To: VEE vrf
Subject: [vrf] Plotting in Excel using VEE


Hello,
   Can anyone  direct me to a book or a web site which would have examples
of how to control plotting data within an Excel worksheet by sending the
commands from VEE. I am currently taking data from a Network Analyzer with
VEE and  writing it to an Excel workbook and now want to have Excel graph
the data without any operator intervention.  I have looked through the
Example Excel97Graph.vee in the examples folder. It seems to imply that the
commands
which I would need can be gotten from recording a macro in Excel and
importing that Visual Basic code into a formula box. But as most things like
this are,
it isn't that easy.
Thanks
Al Garvin
Lockheed Martin
Sunnyvale, Ca.

---
You are currently subscribed to vrf as: andy_street@agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes