> Does anyone have an Active X example
> of how to search the first column of
> an Excel sheet for a text string.
Hi,
I think I have my own workaround for this problem . I put the formula
=MATCH(C1,A:A,0) into a cell in my template sheet and write the text
string I want to find into the next cell in that row. The formula will
determine the row number into which the unique reference is positioned. I
can then read that entire row which holds the test parameters I need.
I have done everything using DDE which I know is frowned upon but it seems
to work OK (OS XP SP2)
Always have trouble translating the Active X from a recorded macro in Excel
into VEE code which works !! Will try to translate what I have done above
into Active X and post.
I too don't want to get kicked of VRF. But here goes. I have just made a
small donation to S_ _ WN. Shame on me for not appreciating him earlier.
Lets all rally round and do the same !! I am only a small 'one man band' so
come on you corporates - do the same as me.
Just had a job sorting out a non working test rig which uses LabView5 / NI
DAQ card. Got it working by having to do a self taught crash course on LV5.
Makes you appreciate VEE. Tried a demo of LV8 but that didn't impress me
either. Got no practical help from NI (promised to call me back twice but
never did) in the UK but now flooded with post and emails tring to sell me
stuff.
Ashley
---
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@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
> of how to search the first column of
> an Excel sheet for a text string.
Hi,
I think I have my own workaround for this problem . I put the formula
=MATCH(C1,A:A,0) into a cell in my template sheet and write the text
string I want to find into the next cell in that row. The formula will
determine the row number into which the unique reference is positioned. I
can then read that entire row which holds the test parameters I need.
I have done everything using DDE which I know is frowned upon but it seems
to work OK (OS XP SP2)
Always have trouble translating the Active X from a recorded macro in Excel
into VEE code which works !! Will try to translate what I have done above
into Active X and post.
I too don't want to get kicked of VRF. But here goes. I have just made a
small donation to S_ _ WN. Shame on me for not appreciating him earlier.
Lets all rally round and do the same !! I am only a small 'one man band' so
come on you corporates - do the same as me.
Just had a job sorting out a non working test rig which uses LabView5 / NI
DAQ card. Got it working by having to do a self taught crash course on LV5.
Makes you appreciate VEE. Tried a demo of LV8 but that didn't impress me
either. Got no practical help from NI (promised to call me back twice but
never did) in the UK but now flooded with post and emails tring to sell me
stuff.
Ashley
---
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@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
To dig a little deeper in Carlos' original question, some background
info first:
The government here in Venezuela wants to adopt Linux and other
opensource solutions. One may be against or in favor of this idea, but
if you want to work in government projects, you will have to go with the
flow and start thinking Linux. In our company, we want to participate in
PDVSA (oil company), so we sure need to start adopting Linux soon.
What I "know" from reading various websites and listening to gurus:
Using VMware should be possible, but anybody has already tried it? I
have used VMware to load a Linux session on a Windows machine, just to
play around, but have not yet a real Linux machine with a "virtual
Windows running Agilent". One thing I will try soon is using VMware in
Windows with a Virtual Windows running VEE, accessing some serial port
or using Modbus TCP. If that works fine, chances are that on Linux
should be fine too. With the new free VMware player and the VXE's and
runtime being free to distribute, we think that it is worth trying.
Drawback of VMware is, that if the government goes "drastic" on us, and
don't want use of any license (Microsoft Windows, for example), we can
not use VMware because we would still need to install Windows on the
virtual machine.
Other option could be Wine http://www.winehq.com, which I have never
tried or even seen in action. This is a emulator running on Linux and
claims to be able to run Windows applications. Also says that you don't
need to install Windows anywhere, so you will not have any license
problems. So one would probably develop on a Windows PC, generate the
vxe, and take it, along with VEE runtime and some needed DLL's to the
Linux machine, and Wine will do the rest....(Solitaire and Minesweeper
runs in Wine
So if anybody has ever tried Agilent VEE in VMware or Wine, or just any
other application that works with any instrumentation or PLC or
something like that, I would like to hear about your experiences.
Thanks,
Nelson
e-mail: nmambre@seebeck.com.ve
URL: www.seebeck.com.ve
Stan Bischof (Richard S) wrote:
> 1. Has Agilent Technologies vast experiences in UNIX?
>
> yes
>
> 2. Was originated Agilent VEE on UNIX?
>
> yes ( though back then it was HP since it was long before Agilent
> existed. VEE was first released on HPUX then later on Windows.
>
> 3. Exist ports to use Agilent VEE or libraries of Agilent VEE in
> UNIX-like: LINUX, Solaris or BSD?
>
> no, though it should be possible to run VEE inside one of the
> emulation environments like VMware. Instrument IO would
> be limited and a little tricky- but using LAN Gateway
> should work OK.
>
> Stan
>
>
> --------------------------------------------------------------------------
> Stan Bischof Agilent Technologies 707-577-3994 stan_bischof@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@agilent.com".
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
From: Nelson Mambre <nmambre@seebeck.com.ve>
To: "Stan Bischof (Richard S)" <rsb@soco.agilent.com>, VEE <vrf@agilent.com>
Subject: Re: [vrf] Interest in Agilen for UNIX-like: LINUX, Solaris or BSD
Hi all,
To dig a little deeper in Carlos' original question, some background
info first:
The government here in Venezuela wants to adopt Linux and other
opensource solutions. One may be against or in favor of this idea, but
if you want to work in government projects, you will have to go with the
flow and start thinking Linux. In our company, we want to participate in
PDVSA (oil company), so we sure need to start adopting Linux soon.
What I "know" from reading various websites and listening to gurus:
Using VMware should be possible, but anybody has already tried it? I
have used VMware to load a Linux session on a Windows machine, just to
play around, but have not yet a real Linux machine with a "virtual
Windows running Agilent". One thing I will try soon is using VMware in
Windows with a Virtual Windows running VEE, accessing some serial port
or using Modbus TCP. If that works fine, chances are that on Linux
should be fine too. With the new free VMware player and the VXE's and
runtime being free to distribute, we think that it is worth trying.
Drawback of VMware is, that if the government goes "drastic" on us, and
don't want use of any license (Microsoft Windows, for example), we can
not use VMware because we would still need to install Windows on the
virtual machine.
Other option could be Wine http://www.winehq.com, which I have never
tried or even seen in action. This is a emulator running on Linux and
claims to be able to run Windows applications. Also says that you don't
need to install Windows anywhere, so you will not have any license
problems. So one would probably develop on a Windows PC, generate the
vxe, and take it, along with VEE runtime and some needed DLL's to the
Linux machine, and Wine will do the rest....(Solitaire and Minesweeper
runs in Wine
So if anybody has ever tried Agilent VEE in VMware or Wine, or just any
other application that works with any instrumentation or PLC or
something like that, I would like to hear about your experiences.
Thanks,
Nelson
e-mail: nmambre@seebeck.com.ve
URL: www.seebeck.com.ve
Stan Bischof (Richard S) wrote:
> 1. Has Agilent Technologies vast experiences in UNIX?
>
> yes
>
> 2. Was originated Agilent VEE on UNIX?
>
> yes ( though back then it was HP since it was long before Agilent
> existed. VEE was first released on HPUX then later on Windows.
>
> 3. Exist ports to use Agilent VEE or libraries of Agilent VEE in
> UNIX-like: LINUX, Solaris or BSD?
>
> no, though it should be possible to run VEE inside one of the
> emulation environments like VMware. Instrument IO would
> be limited and a little tricky- but using LAN Gateway
> should work OK.
>
> Stan
>
>
> --------------------------------------------------------------------------
> Stan Bischof Agilent Technologies 707-577-3994 stan_bischof@agilent.com
> --------------------------------------------------------------------------
>
>
>
>