Home > Time Error > Run-time Error '-2147417484 (80010108)' Automation Error

Run-time Error '-2147417484 (80010108)' Automation Error

Contents

It is occurring on a line of code that simply says: Range("B6").Font.Bold = True If I break the code at this line and then step through it, it steps through fine. Thanks, Srikanth Reply With Quote 05-21-2010,06:19 AM #9 p45cal View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Oct 2005 Location Surrey UK Posts 3,205 Interesting..thanks, were Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? If you are using 2007 you will have to remove "control As IRibbonControl" from the parenthesis before stepping through the sub (unless somebody knows another way if so please advise as Source

Interlace strings Securing a LAN that has multiple exposed external Cat 6 cable runs? My accountSearchMapsYouTubePlayGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Privacy statement Help us improve MSDN. it doesn't work, it throws 'Object disconnected' kind of error.

Run-time Error '-2147417484 (80010108)' Automation Error

Reply With Quote 05-21-2010,04:34 AM #8 srikanthp View Profile View Forum Posts View Blog Entries View Articles VBAX Newbie Joined May 2010 Posts 2 Location More research Hi, I guess no You may have to register before you can post: click the register link above to proceed. Hope this helps! All rights reserved.

  • You will be able to at least see what the last message was, which in turn can give you a clue as to where to look for the culprit code...
  • Both PC and laptop are using Microsoft Windows XP Service Pack 2.
  • PCMag Digital Group AdChoices unused Developer Network Developer Network Developer :CreateViewProfileText: Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free downloads Office resources SharePoint
  • Edits are subject to review by community moderators.
  • let’s start with a blank userform..
  • I really hope someone can help me about this.
  • It works nicely on PC but fail to run when i installed it in the laptop.
  • Original answer by Andrija Vrcan Jun 9, 2010 Contributors: Top Please attach a part of code that generate error.

Here is the FAQ for this forum. + Reply to Thread Results 1 to 2 of 2 Run-time error '02147417848 (80010108) Thread Tools Show Printable Version Subscribe to this Thread… Mark Does anyone have an explanation? i think i gonna us another version of vb and cr any way thanks for ur help Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Run Time Error 2147417848 80010108 Automation Error I am using xl2007.

Range("A1").Activate share|improve this answer answered Feb 7 '14 at 17:59 Robert 1 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google I hope this Helps !!Good Luck,Tom El Hindi < Microsoft VB MVP > "When there is the will !!! If you are in the sliding part of the panel you get the crash, if you are in the frozen bit everything works fine. http://www.vbforums.com/showthread.php?561283-run-time-error-quot-214717848-quot-(80010108) Reply With Quote 09-01-2009,10:37 AM #3 nst1107 View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2008 Location Monticello Posts 245 Location Not a problem.

Copyright © 2004 - VBA Express Register Help Remember Me? Excel Vba Run Time Error 2147417848 Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. Any workaround suggestion is welcome. but I havn't done extensive checking...

Run Time Error 2147417848 (80010108)

Start a new thread here 3559493 Related Discussions RunTime error 2147417848 (80010108) caused by xlSheetVeryHidden in Excel VBA How to Hide Excel Sheets With Macro Option How to change 'Book1' to In that case you should be able to see which line in your code is causing the problem???? Run-time Error '-2147417484 (80010108)' Automation Error Connect with top rated Experts 13 Experts available now in Live! Run Time Error 80010108 Excel Never be called into a meeting just to get it started again.

Here is an easy way in VB6 using ADO to remove duplicate row… Visual Basic Classic Simulating VB Controls in VBA Code Article by: aikimark Introduction While answering a recent question this contact form It does not appear to be part of the code. Visit our UserVoice Page to submit and vote on ideas! Probability of throwing a die Seasonal Challenge (Contributions from TeXing Dead Welcome) Reverse list in Apex my matrix doesnt fit the page Why is this C++ code faster than assembly? "run-time Error -2147417848 (80010108)" Excel

It appears I closed something at the wrong time leading to the deletion. Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... To get to the P & D wizard, Click on Start, Programs, Microsoft Visual Basic 6, Microsoft Visual Basic 6 tools and then just click on Package and Deployment wizard to have a peek here Robert Kernahan replied Jun 9, 2010 Andrija, that is just my problem.

This is how video conferencing should work! Runtime Error 2147417848 Hotfix I haven't encountered the error myself so I'm not sure so... When the workbook is started a User Form is displayed for the user to select the product to be priced and then select a command button to start that products price

Is it required that I upgrade to Sierra Does the Raspberry Pi 3 regulate the voltage on its 5V pins?

Robert Kernahan replied Jun 9, 2010 Andrija, (and others)thank you for your comments. How can I avoid being chastised for a project I inherited which was already buggy, but I was told to add features instead of fixing it? Andrija Vrcan replied Jun 9, 2010 Please attach a part of code that generate error. 2147417848 Automation Error asked 6 years ago viewed 18542 times active 21 days ago Blog Stack Overflow Podcast #93 - A Very Spolsky Halloween Special Visit Chat Related 2Excel VBA Run-time error '424': Object

Error 462: The remote server machine does not exist or is unavailable. I had packaged the file using the package & deployment wizard and then install it to the clients. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. http://techkumar.com/time-error/run-time-error-91-object-variable-or-with-block-not-set.html Toolbox.com is not affiliated with or endorsed by any company listed at this site.

For information on your options, please click here-> http:/help/closing.jsp#1 EXPERTS: Post your closing recommendations! 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 so the synopsis is.. Covered by US Patent.

I'm very suspicious that some failure is arising in the db or in the link between the db and xl and that this is locking up the worksheet. At this point nothing else falls on my mind. PS I am increasing this question to 545 points 0 LVL 1 Overall: Level 1 Message Author Comment by:jward19802003-07-11 Sorry, check that 500 points, can't do any more 0 Suggested Solutions Title # Comments Views Activity VB6: Trouble getting correct Volume Serial Number from Windows API function GetVolumeInformation 17 47 115d Updates not working for MS Windows 7 12 92

now add another frame 'Frame2' (name doesn't matter) to userform. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Pretty sure I haven't tried that yet. At first I thought it was a timeout issue, but it also occurs when the databse is being accessed.

Small part of an INI parser Trick or Treat polyglot What would be the value of gold and jewelry in a post-apocalyptic society? What's curious to me, however, is why it fails here. Best Regards Andrija Vrcan Top White Papers and Webcasts Popular 5 Best Practices for Business Intelligence Related 3 Essential Components for a Strong Enduser Security ... When the message appears, in most cases the application is still visible and the status bar is not covered.