<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0"><TITLE>vee-Files searchable in XP</TITLE></HEAD><BODY><!-- Converted from text/rtf format --><P><FONT COLOR="#000080" SIZE=2 FACE="Arial">Hi,</FONT><BR><FONT COLOR="#000080" SIZE=2 FACE="Arial">I got the experience that contents of the Vee-Files are not searchable with XP. I was searching for a function of which I knew the name but not where I used it. So I searched for the key word ( = my function name) but I didn't get any results. Trying to search for key words which are used in all vee-Files I didn't get any result, too.</FONT></P><P><FONT COLOR="#000080" SIZE=2 FACE="Arial">Do I use wrong parameters or is it an XP-feature (only Bill Gates knows why…)? Does anybody know how to make the vee-files searchable?</FONT></P><P><FONT COLOR="#008000" SIZE=2 FACE="Arial">Best Regards, Axel</FONT></P><P><FONT SIZE=2 FACE="Arial">TEM - Entwicklung Mechanik<BR>R&D Mechanical Engineering<BR><B>Francotyp-Postalia GmbH</B><BR>Triftweg 21-26<BR>16547 Birkenwerder / Germany<BR>Tel.: +49 (0) 33 03/5 25 - 6 37<BR>Fax: +49 (0) 33 03/5 37 07 - 6 37<BR></FONT><A HREF="mailto:a.kieser@francotyp.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">mailto:a.kieser@francotyp.com</FONT></U></A><FONT SIZE=2 FACE="Arial"><BR></FONT><A HREF="http://www.francotyp.com/"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">http://www.francotyp.com/</FONT></U></A><FONT SIZE=2 FACE="Arial"> </FONT></P><BR><BR><BR><BR>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></HTML>
But I have a simple question on your example. Probably shows why I love
vxl
by adding sheet = xlApp.Activesheet; . But what I get back from that is
"_Worksheet" followed by a hex code
enumerate sheets which gives me the names of all WSs. How do I get the
name of the active sheet?
Maybe I am missing something very basic (very likely
for Application, I see ActiveCell as Range. Then I can go to Range and see
on the right Row or Cell. So I can build a formula like row =
xlApp.ActiveCell.Row . But when I go to Application and ActiveSheet I see
it is defined simply as 'object'. What do I do with that info? Does that
imply some basic set of properties I can expand? Or if somethig is defined
as 'object' it has no properties?
--
Regards,
Rich
===================
Richard Kleinhenz
Wafer Engineering
845-892-2617
scubaman@us.ibm.com
===================
"Baranski,
Detlef"
<Detlef.Baranski@ To
pilkington.de> VRF <vrf@agilent.com>
cc
11/16/2005 07:48
AM Subject
AW: [vrf] ActiveX Spreadsheet
object in VXL
Please respond to
"Baranski,
Detlef"
As usual it is hard to say everything 100 % right in a short way
For sure everything is ActiveX in the background, sorry that I say "these
ActiveX -Stuff " which may lead to misunderstandings.
But with Vee75 it gets really easier to work with Excel even though the
technical background is the same. For Beginners the VEE Excel Library ( VXL
) will help a lot to put the barriers lower ...
With Shawns example in mind , here is a code with VXL used .
Just keep in mind that with VXL the name of the excel-application is :
xlapp
If you put the "green-blue " things together in one VEE-file, you can
enhance your Excel menue then....really fantastic possibilities.
Perhaps we should do a collection of best selfmade Menu -Enhancements . I
love these LegoBlocks within programming...sorry that I make it rosy again
;-)
Best regards,
detlef
-----Ursprngliche Nachricht-----
Von: Richard Kleinhenz [mailto:scubaman@us.ibm.com]
Gesendet: Dienstag, 15. November 2005 20:16
An: VRF
Betreff: RE: AW: [vrf] ActiveX Spreadsheet object
Understood. Thanks for the example anyway
My point was it's not quite as rosy as Detlef pointed out. You can't do
everything via vxl or rather the excel library in 7.5. Some knowledge of
activeX is often still required. But a lot of stuff can be done directly
w/o studying activeX, which is a good thing!
--
Regards,
Rich
---
You are currently subscribed to vrf as: scubaman@us.ibm.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/".[attachment "V75-xlgetactiveCell.vee"
deleted by Richard Kleinhenz/Fishkill/IBM] [attachment "V75-xlsample.GIF"
deleted by Richard Kleinhenz/Fishkill/IBM]
---
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/".