While I was try trying to query some data from SQL Server 2005 in Excel VBA Macro I get an error:

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

ADODB.Connection User-defined type not defined
---------------------------
OK   Help  
---------------------------

To fix this problem I just need to add a reference to the project. Here's how:

1. Click on Tools.

2. Click on References....

3. Ensure you have Microsoft ActiveX Data Objects selected.

Now try to run your Macro again and you should not encouter the error.

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

Message:

Security

Please input the anti-spam code that you can read in the image.

"