Help on excel

[Siddharthmark]

Hi,

I have written a VBA procudure in excel using Microsoft office 10.0 Object library. But I am not able to run this on other comps. since the Object library is different (11.0). I guess this is the reason for the procedure to not work. Can someone please help troubleshoot this problem. Is these a way to make this procedure compatiable across all computers irrespective of version differences?????

Thanks in advance
Siddharth

[RobDog888]

You need to use Late Binding instead of Early Binding. Late binding does not require a reference to Excel at all allowing the use of different versions. You do need to be careful to only use properties, methods, and functions that are supported by the versions of Excel you need to support.

Option Explicit
 
Private Sub Form_Load()
    Dim oApp as Object
    Dim oWB as Object
    Set oApp = CreateObject("Excel.Application")
    Select Case oApp.Version
        Case "10.0", "11.0", "12.0"
            'Valid supported version or ???
        Case Else
            MsgBox "Excel Version not supported!"
            'Exit your application or disable features.
    End Select
    Set oWB = oApp.Workbooks.Open("C:\BVook1.xls")
    oWB.Sheets("Sheet1").Cells(1, 1) = "Test"
    oWB.Save
    oWB.Close
    Set oWB = Nothing
    oApp.Quit
    Set oApp = Nothing
 
End Sub