Please help!!!! The line Set tempConn = New ADODB.Connection produces the run-time error! it's about learning to dance in the rain Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home I have excel 2003, bo 6.5 regards Back to top Mark PForum DevoteeJoined: 03 Feb 2003Posts: 10295Location: Manchester, UK Posted: Wed Apr 13, 2011 6:20 amPost subject: Re: Solution to VBA
Although this is temporary, this should work forever if you chose this workaround, since the downloaded typelib is basically the same as the one shipped in Win7 RTM (with LIBID changed, Print Article Not endorsed by or affiliated with SAP Register| Login Follow BOB on Twitter! (Opens a new window) Index|About Sponsors| Contact Us| Calendar| FAQ| Rules and Guidelines| skilly2 View Public Profile Find More Posts by skilly2
The problem only appears on other machines not on my machine (which is another reason i am looking into the references). The unexpected interface could be from a reference in your exe that is different from your package contained dependancy file(s). do i need to add those in the list that u provided while i do PDW? Select File - Close and Return to Word.
Reply With Quote Mar 29th, 2011,04:29 AM #32 cayoga View Profile View Forum Posts New Member Join Date Mar 2009 Posts 1 Re: "Runtime error '430' class does not support Automation I thought it was the solution!