Automation Error

[Denise A. Monasteri]

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.

 

[Guest]

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

 

[Tiffany A. Keane]

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

 

[onedaywhen]

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, ...?

--

 

[Guest]

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, ...?

wrote in message [email protected]>...