I posted something recently about vxl, and got some back-channel inquiries,
so I thought I'd post a couple of notes on things I recently had to do
where vxl came in really handy, or stuff I found out. Maybe these notes
help someone else. I am not an activeX guru, so any help I can get from a
pgm is something I really appreciate.
1. Find 1st empty row. Very useful for data logging! The function is in
vxl. Also, in the current version there is find 1st empty column.
2. Insert a row: xl.ActiveSheet.Range("A2:A4").EntireRow.insert 3 rows
after the 1st row. Similarly xl.ActiveSheet.Range("A6").EntireRow.delete
deletes the 6th row. xl.ActiveSheet.Range("A1:E1").EntireColumn.insert
inserts columns and xl.ActiveSheet.Range("A1:E1").EntireColumn.delete
deletes columns. I don't have to worry about setting up constants, these
work directly in a formula box.
3. I needed to do a global search and replace. I used an activeX function
for that because it was not in vxl. The call is
xl.ActiveSheet.Range("A1:Z300").Replace(G,B,xlPart,xlByRows,False);
in a formula box. G and B are inputs for the search-for and replace-with
strings. Again, no other setup was required, defining more constants etc.
The problem I ran into was that when the G-string was not found the program
would hang with a warning in excel that I had to click to get past. (And
now you also know why I named the input parameter G and not A vxl has
a setup function than needs to be invoked at the start of the program, in
that function there is a setting for DisplayAlerts. By setting that to
FALSE the program bypassed these alerts. vxl also told me that I could
dynamically change that behavior by putting xl.DisplayAlerts=False|True
into a formula box to avoid trip-ups with other warnings.
4. There is a nifty utility function that I made extensive use of. It
actually has nothing to do with excel, but saved me having to write it.
It's an array search function: search for a string in column 1 of a 2D
array, and output the corresponding element from column 2 if found.
Unfortunately, it breaks if an element is repeated in column 1.
I think it's a slick program. It does a lot of the common things one does
with excel in a lab. And Greg Wale supports the program really well
(thanks, Greg!)
And btw I am not associated with passtechnologies or Greg, just a pretty
happy customer.
--
Regards,
Rich
===================
Richard Kleinhenz
Wafer Engineering
845-892-2617
scubaman@us.ibm.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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!