While running VBA code on the .open event I get the
following error: Automation Error the specified procedure
could not be found. -Z147024769. Can you let me know
what causes this.

Suggest you post a chunk of the code - indicating which line it is failing on

So, for one user, the code fails on the open method for
the connection object (.Open line below), but for a
different user, it works just fine. Both users have the
XP operating system and Office 2002. Both users have the
same version of MDAC (2.7) and the same references checked
(Microsoft ActiveX Data Objects 2.7 Library, Microsoft
Forms 2.0 Object Library, Microsoft Office 10.0 Object
Library, OLE Automation, Microsoft Excel 10.0 Object
Library and Visual Basic for Applications). Any ideas for
me?

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = sName & _
"Extended Properties=Excel 8.0;"
.Open
End With

-----Original Message-----
Suggest you post a chunk of the code - indicating which
line it is failing on
.

What is the contents of the variable sName? It could be crucial. For
example, is the workbook on a nwtwork share, is it using a drive
letter that isn't mapped to the same UCN as the other machines, ...?

--

"Tiffany A. Keane" wrote in message ...
So, for one user, the code fails on the open method for
the connection object (.Open line below), but for a
different user, it works just fine. Both users have the
XP operating system and Office 2002. Both users have the
same version of MDAC (2.7) and the same references checked
(Microsoft ActiveX Data Objects 2.7 Library, Microsoft
Forms 2.0 Object Library, Microsoft Office 10.0 Object
Library, OLE Automation, Microsoft Excel 10.0 Object
Library and Visual Basic for Applications). Any ideas for
me?

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = sName & _
"Extended Properties=Excel 8.0;"
.Open
End With

-----Original Message-----
Suggest you post a chunk of the code - indicating which
line it is failing on
.

sname is "Data Source=" and a path and filename. The path
is the same as the path for the open workbook (which calls
this code) which is the user's local C:\ drive. The file
name is "United States.xls". Does anything look funky?

-----Original Message-----
What is the contents of the variable sName? It could be
crucial. For
example, is the workbook on a nwtwork share, is it using
a drive
letter that isn't mapped to the same UCN as the other
machines, ...?

--

"Tiffany A. Keane"
wrote in message news:<153ca01c41cfa$99cb8470
...
So, for one user, the code fails on the open method for
the connection object (.Open line below), but for a
different user, it works just fine. Both users have
the
XP operating system and Office 2002. Both users have
the
same version of MDAC (2.7) and the same references
checked
(Microsoft ActiveX Data Objects 2.7 Library, Microsoft
Forms 2.0 Object Library, Microsoft Office 10.0 Object
Library, OLE Automation, Microsoft Excel 10.0 Object
Library and Visual Basic for Applications). Any ideas
for
me?

Dim cn As ADODB.Connection
Set cn = New ADODB.Connection
With cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = sName & _
"Extended Properties=Excel 8.0;"
.Open
End With

-----Original Message-----
Suggest you post a chunk of the code - indicating
which
line it is failing on
.

.