AnsweredAssumed Answered

vrf VRF - continued beginner mental block with Excel ActiveX automation

Question asked by VRFuser on Feb 9, 2000
I am aware that this subject has been beaten to the ground recently, and I
apologize for resurrecting what may have been explained before I joined the
group last week.

If someone has the time and inclination, could you please help me understand
how I should translate the following excerpts from Excel Help into something
VEE can understand?

I'm more interested in learning the concept of how to translate what VB
'says' into something VEE can understand than I am with trying to learn how
to do these particular procedures.


1)  How can this be translated into VEE?
Using the Application Object:
Use the Application property to return the Application object. The following
example applies the Windows property to the Application object.
Application.Windows("book1.xls").Activate

The following example creates a Microsoft Excel worksheet object in another
application and then opens a workbook in Microsoft Excel.
Set xl = CreateObject("Excel.Sheet")
xl.Application.Workbooks.Open "newbook.xls"

2)  How could one know that Autuor is a property of ActiveWorkbook?  How can
I find out what other properties ActiveWorkbook might contain?
ActiveWorkbook Property:
ActiveWorkbook.Author = "Jean Selva"

3)  How can this be translated into VEE?
Range Property:
The following example places the value of cell A1 in cell A5.
Worksheets("Sheet1").Range("A5").Value = _
    Worksheets("Sheet1").Range("A1").Value


Thanks for any insight...

Paul

Paul Bryan
ABL Electronics Corporation
410-584-2738 x133
pbryan@ablcables.com


---------------------------------------------------------------------
This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "vrf@lvld.hp.com".  Subscriptions and
unsubscriptions are done through the address "vrf-request@lvld.hp.com".
If you need details, just send a message containing the text "help"
to "vrf-request@lvld.hp.com".
---------------------------------------------------------------------

Outcomes