H
Howard Kaikow
I found a workaround which seems to imply a bug in VB .NET.
Can others reproduce this behavior using the example in the Temporary Links
at http://www.standards.com/index.html#Temporary?
Using that example:
The following creates an Excel object and allows the code to properly
execute.
oXL = New Excel.Application() ' Works
The following does not allow the code to properly execute:
oXL = CreateObject("Excel.Application")
The following, or equivalent, allows the code to properly execute:
oXL = CreateObject("Excel.Application")'On Error Resume Next
If 1 <> 1 Then
oXL = New Excel.Application()
oXL = GetObject(, "Excel.Application")
End If
At first glance, the implication is that some library/code is not getting
loaded without including the code in the never executed If ... End If.
Can others reproduce this behavior using the example in the Temporary Links
at http://www.standards.com/index.html#Temporary?
Using that example:
The following creates an Excel object and allows the code to properly
execute.
oXL = New Excel.Application() ' Works
The following does not allow the code to properly execute:
oXL = CreateObject("Excel.Application")
The following, or equivalent, allows the code to properly execute:
oXL = CreateObject("Excel.Application")'On Error Resume Next
If 1 <> 1 Then
oXL = New Excel.Application()
oXL = GetObject(, "Excel.Application")
End If
At first glance, the implication is that some library/code is not getting
loaded without including the code in the never executed If ... End If.