Macro problem

B

Bernie R

I got an excel spreadsheet that pulls data from an access file via a VB
macro. They were 2003 files and we upgraded to 2007. We worked majority of
the issues; however, we can't get our link to the database to connect and
draw data even though the same link on my desktop connects. Got the db
address in the "Trusted Locations."

The VB module comes up with an error, "user-defined type not defined", that
occurs with this line, Dim cnn As New ADODB.Connection.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top