View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 38
Default 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