I am trying to get an Excel sheet to read/write to an Access DB. My code starts as shown below.
When running it, I get the error: "Compile error. User-defined type not defined" it will not let me proceed until i have sorted out the "Global cnPubs As ADODB.Connection" line.
I am also guessing that the line below it "Global rsPubs As ADODB.Recordset" will also throw up the same error as it generally doesn't like it.
i initially had an error come up run time erro '429' active X component can't create object and figured out that the right library wasn't selected. In tools-references i now have Microsoft ActiveX data objects (multi-dimensional) 2.8 library is selected and that run time error has now gone away and the above has now happened.
Although I have been doing VB coding for some years now I an brand spanking new to the linking into access thing, I am looking after any compatibility issues with excel 2003 sheets moving onto 2010 as we are about to upgrade and this is one that has thrown up a problem so i thought I would try and fix it, I am regretting that now! Just to confirm I didn't write this and the person that did is no longer with the business.
Any thoughts on how to solve this would be welcome
Please Login or Register to view this content.