OpenDatabase-Problem
 

Tom,

You can use the CallByName function to call the OpenDatabase
function. E.g.,

#If VBA6 Then
If CInt(Application.Version) = 10 Then
CallByName Workbooks, "OpenDatabase",vbMethod ', other
arguments
End If
#End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Tom" wrote in message
...
Hi

I have a problem with the OpenDatabase-Method. This method
works with xlXP+
but fails with xl97 & xl2K.

The following script works fine with all XL versions except
xl2K:

Sub Test()
#If VBA6 Then
Workbooks.OpenDatabase ...
#End If
End Sub

Any ideas to get this work with xl2K?

Tom

OpenDatabase-Problem
 

Thanx





"Chip Pearson" schrieb im Newsbeitrag
...
Tom,

You can use the CallByName function to call the OpenDatabase
function. E.g.,

#If VBA6 Then
If CInt(Application.Version) = 10 Then
CallByName Workbooks, "OpenDatabase",vbMethod ', other
arguments
End If
#End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Tom" wrote in message
...
Hi

I have a problem with the OpenDatabase-Method. This method
works with xlXP+
but fails with xl97 & xl2K.

The following script works fine with all XL versions except
xl2K:

Sub Test()
#If VBA6 Then
Workbooks.OpenDatabase ...
#End If
End Sub

Any ideas to get this work with xl2K?

Tom