When running it, I get the error: "Compile error. Excel 2010 VBA gives error on "Dim Conn As ADODB.Connection" Rate Topic Display Mode Topic Options Author Message Cindy HallumCindy Hallum Posted Thursday, January 12, 2012 5:15 PM SSC-Addicted Group: General I had to go into the design view and then view code and not go the Alt F11 route. it's nonsense to ask help for those who doesn't want to help... http://thetechvoice.com/compile-error/compile-error-user-defined-type-not-defined-vba-adodb-connection.html
This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. However this is what I see that is close to what you described...which one should I select? Posts: 13 Thanks: 0 Thanked 0 Times in 0 Posts ADODB.Connection user-defined type not defined When I type Dim cnn As ADODB.Connection to connect to another excel from within excel I If you don't like Google AdSense in the posts, register or log in above. http://p2p.wrox.com/excel-vba/39128-adodb-connection-user-defined-type-not-defined.html
To start viewing messages, select the forum that you want to visit from the selection below. I did not write this code. Thread Tools Rating: Display Modes 07-16-2013, 09:15 AM #1 lowanam1 Newly Registered User Join Date: Jan 2012 Posts: 106 Thanks: 3 Thanked 0 Times in 0 Posts MS Error Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page...
The reference on my machine is Microsoft ActiveX Data Objects 2.5 Library. Lotte Please Login or Register to view this content. ... Post your question and get tips & solutions from a community of 418,854 IT Pros & Developers. Private dbParts as Database Private dbParts as Recordset Firstly, You Can't Have Two Variables With The Same Name !
Jun 28 '07 #9 reply Expert 5K+ P: 8,435 Killer42 If they're still teaching ten year old VB6, maybe they expect the students to use DAO. The time now is 11:28 AM. Microsoft Access Help General Tables Queries Forms Reports Macros Modules & VBA Theory & Practice Access FAQs Code Repository Sample Databases Video Tutorials Sponsored I unchecked the reference, Saved, Closed, Restarted the workbook. https://support.microsoft.com/en-gb/kb/184609 You cannot upload attachments.
The time now is 03:28 PM. http://www.sqlservercentral.com/Forums/Topic1235320-391-1.aspx lowanam1 View Public Profile Find More Posts by lowanam1
I also notice that while String and Integer are syntax highlighted in blue, Range, ADODB.Connection and ADODB.Recordset remain black. weblink Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Excel VBA Discuss using VBA for Excel programming. You cannot delete your own posts. Check the tick box next to this entry and then click ok.
They should be built in the outer loop, not the inner loop so you would need to reverse the loops. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find You may have to register before you can post: click the register link above to proceed. navigate here You cannot send emails.
kid in winter My boss asks me to stop writing small functions and do everything in the same loop Is the following sentence correct? 'The time when the church dates back Jun 27 '07 #3 reply Expert 5K+ P: 8,435 Killer42 are u connecting your VB to Database? Tools >> references >> lists up to 2.8 on the development system (Office 2003).
You may also want to check out these from the Access Code Archive forum: Who's logged on to networked db and Who is logged into mdb? Find the "Recursive Size" of a List Do American foods contain unsafe levels of glyphosates How worried should I be about getting hacked with PoisonTap? Thank you again lowanam1 View Public Profile Find More Posts by lowanam1 07-16-2013, 11:47 AM #12 DrallocD Newly Registered User Join Date: Jul 2012 Welcome to the p2p.wrox.com Forums.
Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Home Bookstore/E-Books P2P Programmer Forums Wrox Blogs Connect with Wrox Code Resources International IT Certifications Navigation Register Now View Active Topics View Archives View Unanswered Topics Wrox Programmer Forums share|improve this answer edited Apr 23 '14 at 6:49 answered Mar 19 '11 at 11:45 Jean-Francois Corbett 24.1k1681116 @Jean-FrancoisCorbett Seems like the only way I can get this working his comment is here I'm determined to win.
You cannot edit your own posts. Catharines, ON (Canada)You need a reference to Microsft ActiveX Data Objects 2.x Library to use ADO. So do you get Access denied if you start a blank project and try to add a reference to Microsoft ActiveX Data Objects 2.x Library and just click ok? User-defined type not defined" To get replies by our experts at nominal charges, follow this link to buy points and post your thread in our Commercial Services forum!
Here's some comparisons between DAO/ADO if it's of any benefit to you: http://www.gab2001uk.com/visualbasic/daovsado/ Jun 30 '07 #16 reply Expert 5K+ P: 8,435 Killer42 Anyway, now that we've established that we are The comment refers to the ADO Ref Library which is what I want, though it does not specify version. There Isn't One. Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel