From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

LV ActiveX controll of XL on remote machine

(Emailed Cc:s appreciated.)

Is there a discussion of, and maybe a simple example .vi
illustrating the manipulation of a spreadsheet on a remote
machine available anywhere? I see I'm going to have to
contend with DCOM, etc., and would like to know more
to reduce the blind thrashing. _______________Marty
0 Kudos
Message 1 of 4
(2,551 Views)
If you have ActiveX vi's that already do what you need them to, you can
call those vi's remotely using the VI server. If the vi's require dat
to be passed in/out, use the Call By Reference Node. If you're having
trouble writing the VI's to control Excel, email me or post a message
with some specifics of what you're trying to accomplish and I'll see
what I can do. I do a lot of "blind thrashing" myself, but sometimes I
manage to grab hold of something that works. 🙂

MaxMar


* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
0 Kudos
Message 2 of 4
(2,551 Views)
Very interesting how work to with ActiveX. One idea I have is to conect to
matlab on one PC with LV on a second PC. One step for me could be learn com
with xls first, if someone of you would like share VIs I would appreciaet
that.

Anders Björk
Analytical Chemistry
Royal Inst. of Tech.
Stockholm
Sweden
0 Kudos
Message 3 of 4
(2,551 Views)
Björk:

The National Instruments Web Site has many examples of ActiveX control
of Excel. Just go to www.ni.com and search the entire website for
excel. The search will turn up the links to the example code database
entries that illustrate Activex control of excel.

MaxMar


* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!
0 Kudos
Message 4 of 4
(2,551 Views)