View Single Post
  #3 (permalink)  
Old June 6th, 2003, 09:41 AM
walgie walgie is offline
Registered User
Join Date: Jun 2003
Location: Jacksonville, FL, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Hi gbianchi;

Is the Excel object that you speak of in the Office folder where I find Excel.exe.

I have created an install package that contains Excel.exe and Excel8.olb and still get the Activex message.

The code that gives the message is;

    Dim fso As scripting.FileSystemObject
    Dim hHeading As String
    Dim X As Integer

    Set oXL = CreateObject("Excel.Application")
    Set oXL.Workbooks.Add
    oWB.Sheets(1).Name = "Report_Extract"

    MsgBox ("Excel Version: " & oXL.Version)

Could you give me a little more information on how I go about using the Excel object.


William R. Algie
Reply With Quote