VBA - create query with ADO in Access application

[michiel soede]

Hi everybody,

Hope somebody can help me out. I want to create a query with ADO in Excel in an Access application. I found some code on the website of Jon van der Heyden: http://jonvonderheyden.net/excel/add...ures-with-vba/

However when I use his code I get a compile error: user defined type not defined. I set my reference to ADO but it still does not work. Does anybode know why this error is popping up?

Attached an excel file with the code.

Thanks in advance,

Michiel

[skywriter]

I have a sheet I connect to an Access database with and I don't see any code that looks familiar. Where is the code? Which module?

[michiel soede]

Sorry I mistook for another file. See attached for the correct file.

Michiel

[skywriter]

What line is giving you the error?

[michiel soede]

It refers to this line:

Public Sub CreateQuery(ByVal strDBPath As String, _
ByVal strSql As String, ByVal strQueryName As String, _
ByVal vpType As ViewOrProc)

[skywriter]

I'm certainly not an expert, but I'm hoping I find something obvious. My first question would be where are you calling this procedure from? I ask because when I search the code I can't find where you have defined strDBPath, so I wonder where you are giving that a value to pass to this procedure.

Also I don't know if the references would be an issue because it looks like this code is late binding code.

[michiel soede]

All,

Thanks. Somehow part of the code was fallen away. Attached the proper file and code.

sorry for the inconvenience.

Michiel