Automation Error Object Is Not Connected To Server
Contents |
Forums Excel Questions Userform date pop-up options Results 1 to 3 of 3 Userform date pop-up optionsThis is a discussion on Userform date pop-up options within the Excel Questions forums, part of the Question Forums category; ... LinkBack LinkBack URL About LinkBacks Bookmark & Share automation error the object invoked Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display automation error the object invoked has Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 7th, 2013,12:12 PM #1 vristang New Member Join Date Nov 2013 Posts 5 Userform calendar control missing in excel 2010 date pop-up options Been finding answers to questions for years here, but had to join and post for this one... I need to have a date entered in a userform. I see 2 options: Calendar Control 12.0Microsoft Office Outlook Date Control
800401fd
The first option works fine in my userform, but the size of it is making it difficult to arrange things. 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 to run the userform: Run-time error ‘-2147220995 (800401fd)’: Automation error Object is not connected to server I’m using Excel 2007. Any suggestions for fixing the 'not connected to server' error? Are automation error vba there other options I'm not seeing? I greatly prefer the Outlook Date Control, if it will work properly Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 7th, 2013,01:12 PM #2 jamcall Board Regular Join Date Sep 2013 Location Virginia, USA Posts 271 Re: Userform date pop-up options Microsoft MonthView Control is another option. As far as spce considerations, you could use a small command button (calendar icon) - next to the textbox for your date - to popup a second user form with just the calendar control and return the selected date to the date text box. HTH, ~ Jim Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 8th, 2013,10:52 AM #3 vristang New Member Join Date Nov 2013 Posts 5 Re: Userform date pop-up options Ended up using a button which pops up a calendar box with the selected date being returned to the text box... Seems kinda cheesy, but it is working. Thanks for the direction! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Share it with others Like this thread? Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On [VIDEO] code
General > Object is not connected to server Thread Tools Display Modes #1 07-30-2002, automation error object is not connected to server excel vba 03:02 AM gerconn Regular Join Date: Jun 2002 Location: Ireland Posts:
Run-time Error 2147220995
60 Object is not connected to server I get the following error when I try to run
Vba Date Picker
an executable: Run-time error '-2147220995 (800401fd)': Automation Error Object is not connected to server Anyone any ideas? gerconn View Public Profile Find all posts by gerconn #2 http://www.mrexcel.com/forum/excel-questions/737801-userform-date-pop-up-options.html 07-30-2002, 03:04 AM AtonalPanic Contributor Join Date: Jul 2002 Location: Houston, Texas Posts: 445 What exactly are you tring to do? AtonalPanic View Public Profile Visit AtonalPanic's homepage! Find all posts by AtonalPanic #3 07-30-2002, 03:14 AM gerconn Regular Join Date: Jun 2002 Location: Ireland Posts: 60 Take info from Foxpro tables and put http://www.xtremevbtalk.com/general/34312-object-connected-server.html into an excel spreadsheet. Works fine on my own pc but when I try to run it on a server I get all these problems. gerconn View Public Profile Find all posts by gerconn #4 07-30-2002, 03:25 AM AtonalPanic Contributor Join Date: Jul 2002 Location: Houston, Texas Posts: 445 humn...I don't have much knowledge there. AtonalPanic View Public Profile Visit AtonalPanic's homepage! 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 using ADO, DAO or whatever? You have to be more specific if you want us to help you. Flyguy View Public Profile Find all posts by Flyguy #6 07-30-2002, 05:17 AM gerconn Regular Join Date: Jun 2002 Location: Ireland Posts: 60 I have something like the following: Public xlbook As Excel.Workbook Set xlbook = GetObject("E:\MYFOLDER\TEMPLATE.XLS") The error appears when I GetObject gerconn View Public Profile Find all posts by ger
One games Xbox 360 games PC https://support.microsoft.com/en-us/kb/186063 games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security automation error Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft automation error object Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft