AnsweredAssumed Answered

AW: AW: vrf ActiveX Spreadsheet object in VXL

Question asked by detlef.baranski on Nov 15, 2005
Whats about name = xlapp.Activesheet.name   ??  or names

-----Ursprngliche Nachricht-----
Von: Richard Kleinhenz [mailto:scubaman@us.ibm.com]
Gesendet: Mittwoch, 16. November 2005 15:36
An: VRF
Betreff: Re: AW: [vrf] ActiveX Spreadsheet object in VXL

I agree 100% - it lowers the barrier for sure!

But I have a simple question on your example.  Probably shows why I love
vxl   I tried to extend your formula box to also give the active sheet,
by adding sheet = xlApp.Activesheet; .  But what I get back from that is
"_Worksheet" followed by a hex code   I wanted to get the title.  I know
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   In the browser,
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: Detlef.Baranski@pilkington.de
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/".

---
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/".

Outcomes