Microsoft KB Archive/213353

= XL2000: You Receive "User-Defined Type Not Defined" Error Message When Using Data Access Objects =

Article ID: 213353

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213353





SYMPTOMS
When you run a Microsoft Visual Basic for Applications subroutine using data access objects (DAOs), you may receive one of the following compile error messages:

User-Defined Type Not Defined

-or-

Sub or Function Not Defined



CAUSE
You may receive the error message when a subroutine contains code that uses the Microsoft DAO Object Library, and the library is not referenced.



RESOLUTION
To avoid the error message, follow these steps:  In the Visual Basic Editor, click References on the Tools menu. In the References dialog box, under Available References, select Microsoft DAO 3.5 Object Library, and then click OK.

If Microsoft DAO 3.5 Object Library is not listed in the list box under Available References, click Browse, and then navigate to the Dao350.dll file. It should be found in the following location:

\Program Files\Common Files\Microsoft Shared\Dao\Dao350.dll

Select the file, and then click OK. This returns you to the References dialog box. Click OK.



MORE INFORMATION
When you run a subroutine using DAO, and the DAO Object Library is not referenced, you receive one of the messages listed in the "Symptoms" section, depending on what code is written. If your code declares variables, for example

Dim Db as Database

Dim Rs as Recordset

you receive the

User-Defined Type Not Defined

error message, and the subroutine fails in the variable declaration section.

If you did not declare your variables, you receive the following error message

Sub or Function Not Defined

and the subroutine fails at the first use of a statement that requires the DAO Object Library. This line is usually:

Set Db = Workspaces(0).OpenDatabase(Path, )

In this case, the subroutine fails when it encounters the "Workspaces" term.

Additional query words: XL2000

Keywords: kberrmsg kbprb kbprogramming KB213353

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.