Class objects

[campbere]

In this code is the reference to Excel.Sheet.8 is that worksheet 8 or is it specifying a certain version? Any help would be apprciated. If there is a good resource for learning the different options and properties for the Excel class that would also be helpful.

If OLE1.Class = "Excel.Sheet.8" Then
Set Excelobj = OLE1.object.Worksheets("sheet1&quot
Else
Set Excelobj = OLE1.object
End If

 

[lordhuh]

if you have excell 97 or later you can go into the excell vba and hit f1 it will bring up vb help(not all of it but some) and help specific to excel

hope that helps

Karl Pietri

Karl Pietri
lordhuh.pota.to

 

[Ruairi]

Excel.Sheet.8 is not referring to a certain worksheet number. it is the name of the worksheet object exposed by the version of excel you are using.

Ruairi
ruairi@logsoftware.com
Experienced with:

VB6, SQL Server, QBASIC, C(unix), MS Office VBA solutions

ALSO: Machine Control/Automation using GE and Omron PLC's and HMI(human machine interface) for industrial applications