troubleshooting Question

Connection in VBA to a closed Excel 2003 file

Avatar of gahute
gahuteFlag for Canada asked on
Microsoft Excel
1 Comment1 Solution317 ViewsLast Modified:

I want to create a simple program into Excel 2003 VBA and use a network located closed Excel 2003 file and write to some informations.

I tried to use some code found on the net but dont' understand why I get an error message right at the beginning of the code.

At the code line "Dim Cn As ADODB.Connection" I get the error message "Compilation error, user defined type not defined" and don't understand what's wrong.

Is anydoby can give me a link to a complete explanation on how to connect to an Excel 2003 closed file and write into it?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros