excel automation error object is not connected to server Chittenden Vermont

Address 56 1/2 Merchants Row, Rutland, VT 05701
Phone (802) 774-6500
Website Link http://teconic.com

excel automation error object is not connected to server Chittenden, Vermont

At line 'set objXL = new excel.application', error #-2147221163 "Automation error: Interface not recognised" Sorry to be repetetive, but I'm losing track of what works, & what doesn't. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Why would a password requirement prohibit a number in the last character? To start viewing messages, select the forum that you want to visit from the selection below.

I'm running the program in PPT 2007 on Windows XP. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. RE: Drop down Calendar Excel 2010 Marsdbginner (TechnicalUser) (OP) 8 Jul 13 13:16 Hey Skip, Great suggestion, however I can only guess at the exact function you're speaking of. Automation error OutputTo Word/Excel 2003 Causes Fatal Error Calling a C# assembly from Excel or Word (VBA) => Automation Error Automation error, cannot create ActiveX object on .net ASP.NET & Outlook

The second option would make it very easy to incorporate into my userform, but it does not seem to display properly, and I get the following error each time I try AtonalPanic View Public Profile Visit AtonalPanic's homepage! Please Mark your Thread "Resolved", if the query is solved Microsoft MVP: 2011 - 2015 IMP Links : Acceptable Use Policy, FAQ MyGear: ACER R7 (Win 8.1+Office 2013+VS2013) || Sony VPCCB-45FN However my two declarations for the recordset being passed are: Dim db As DAO.Database Dim rs As DAO.Recordset Have I just exchanged one problem for another??

All contents Copyright 1998-2016 by MrExcel Consulting. Could you elaborate on this, please? However, now as soon as I get to using copyfromrecordset, I get the error #430 "Class does not support Automation or does not support expected interface". Error: Object server not correctly registered (Error 336) 3.

Find all posts by AtonalPanic #5 07-30-2002, 04:50 AM Flyguy Lost Soul Super Moderator* Guru * Join Date: May 2001 Location: Vorlon Posts: 19,124 Are you Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. From this article: http://support.microsoft.com/default...b;en-us;246335 it seems that such an error msg means I am passing an ADO recordset... Try Dim'ing rs "as object", not "as DAO.recordset", & see if that helps.

Hi again TC, I have checked again, and I definitely have the library "Microsoft Excel 9.0 Object Library" selected. Any suggestions for fixing the 'not connected to server' error? Join UsClose Register Help Remember Me? After digging for a while in several forums and finding others reaching the same dead-end, it looks like this control wasn't carried into Excel 2010..

Referring back to a previous post where I had this error, I wrote: From this article: http://support.microsoft.com/default...b;en-us;246335 it seems that such an error msg means I am passing an ADO recordset... Hi TC, Comments below: > Is this correct: > > - You have the library "Microsoft Excel 9.0 Object Library" selected in > Tools:References. HTH, TC Ange T wrote in message news:b7**************************@posting.google.c om... I have also tried using the declaration Dim objXL as Object and then using the lines suggested.

cntr+R will activate the Project Explorer In the Project Explorer you will see a Forms object. What servers am I connected to ? 10. Got a question on Linux? Yes - This code works ok: dim objXL as object set objXL = createobject ("excel.application") Yes Can you please repeat the following two tests, & say if they work ok, or

I dont answer coding questions via PM or EMail. Also, just as an aside, I tried to open and run everything for a third completely different machine, and it all worked perfectly first time. By joining you are opting in to receive e-mail. Could I be missing a crucial file or has my Office XP installation gone bad?

Powered by vBulletin Version 3.8.9Copyright ©2000 - 2016, vBulletin Solutions, Inc. --> current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log I have an app that opens an existing Excel WB (a template) with the following code I swiped from Helen Feddema's Access Archon article: Dim objXL as Excel.Application set objXL = Thanks so much, Ange "TC" wrote in message news:<[email protected]>... ie click the button and the form pops up; various other drop downs are populated such as Name, ProjectID, Task Description, Hours worked, and Comments and then the user clicks submit

Thanks again, Ange. I am no expert in COM (the Microsoft technology behind your problem), but I believe the problem might be, that Excel is not properly registered on the bad PC(s). ("Registration" is Hi Ange Your previous posts have disappeared from my newsserver, & unfortunately I can't remember what error you got on that line. (It is always good to repeat the relevant information, When you've done that, double-check that the reference you have selected in Tools:References (in your database), is the right one for the latest version of Excel on that PC.

All times are GMT -5. Sorry if it feels I'm going in circles... Good grief! Got a question on Linux?

HTH, TC Ange T wrote in message news:b7**************************@posting.google.c om... Also CopyFromRecordset will fail if the recordset contains an OLE Also see this link to save time... So, it is creating the Excel object fine using the Dim objXL as excel.application. I did the re-registering thing you suggested below, and it (mostly) worked!

Also, which OS and PP versions? Try this on the bad PC(s). It's just a snip of the Additional Controls window that i uploaded to imageshack. You may have to register before you can post: click the register link above to proceed.

Ange Nov 12 '05 #6 P: n/a TC Ange, I am researching this & will get back to you within the hour (perhaps), or tomorrow (Wednesday, where I live). Nov 12 '05 #2 P: n/a TC Ange Try the following an the bad pc. Why did it take 10,000 years to discover the Bajoran wormhole?