Home > Time Error > I-configure Runtime Error -214741848 (80010108):

I-configure Runtime Error -214741848 (80010108):

Contents

Thanks for your help. Maybe something else is happening not related to your actual code. The form fills out the Vendor Name based on a user entered Vendor Number. Big numbers: Ultrafactorials PRNG for generating numbers with n set bits exactly "Draw a million dots:" How to respond to a ridiculous request from a senior colleague? http://analysedesgeeks.com/time-error/how-to-fix-runtime-error-2147417848-80010108.html

Do I need the Do Events? By setting the page length to 6 inches (instead of 2), it solved the issue. Not sure if the problem is in my copy or in the 2013 in general. Register Help Remember Me?

Run Time Error 2147417848 80010108 Automation Error

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 Haven't checked this on 2003. But I see you're making Range calls, which are also implicitly calling into the ActiveSheet.

Theorems demoted back to conjectures What does 契約期間:2年 mean? Option Explicit Sub ShowMenu(ButtonName As String, ButtonLeft As Single, ButtonTop As Single, ButtonHeight As Single) Dim img As MSForms.Image, lbl As MSForms.Label, frm As MSForms.Control Dim fMenu As MSForms.Frame Dim fillRange HiB Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jan 6th, 2015,06:19 AM #8 GTO MrExcel MVP Join Date Dec 2008 Location Phoenix, Arizona Posts 5,793 Re: Excel Vba Run Time Error 2147417848 I literally added this line: ActiveSheet.Cells(1, 1).Clear Then I perform the copy and insert, and it works just fine.

The reason for the VendorName value etc, is because I wanted the message to be vbcritical. "run-time Error -2147417848 (80010108)" Excel asked 8 months ago viewed 957 times active 8 months ago Blog Stack Overflow Podcast #97 - Where did you get that hat?! Reply With Quote Feb 3rd, 2014,06:04 AM #3 Sardokar New Member Join Date Feb 2014 Posts 20 Re: Method 'Insert' of object 'Range' failed ( Run-time error '-2147417848 (80010108) ) Originally Yes we resolved the issue by modifying the Zebra label printer Properties.

now again try creating a frame control within 'Frame1'... Runtime Error 2147417848 Hotfix Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though) If I've helped and you can't be bothered to acknowledge You can create a new one: Dim target As Worksheet Set target = ThisWorkbook.Worksheets("pl") ...Or you can give the sheet a code name in the properties toolwindow (F4): That (Name) property When I removed the copies *not* in WINNT/system32, the program still crashed with error -2147417848, etc.

"run-time Error -2147417848 (80010108)" Excel

I added this line: iHerring = ActiveSheet.UsedRange.Rows.Count And it worked fine. I've looked around, but don't see any help for this specific problem. Run Time Error 2147417848 80010108 Automation Error I thought using the error handler would be a quick way to get to the answer. Run-time Error '-2147417848 (80010108)' Automation Error Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc.

All went well untill I actually got to adding value to the range. weblink If you want to insert/copy ti in a protected worksheet you first need to unprotect it. The VBA code triggers the error when the dll i(red font) is called, but the rest of the code is there even though I do not send the VBA Form. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Runtime Error 2147417848 (80010108)

So... But this only solved the issue when it was called from an undo command on a different spreadsheet. lets start with a blank userform.. http://analysedesgeeks.com/time-error/how-to-repair-a-runtime-error-2147417848-80010108.html Woud that be it ? : Code: Private Sub Workbook_Open() With Sheet1 .Unprotect Password:="Mypassword" .Protect Password:="Mypassword", UserInterfaceOnly:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True .EnableOutlining = True End With End Sub Share Share this post

One the PC which runs the code, WINNT\system32\Mscomm32.ocx and WINNT\system32\MSCOMCTL.OCX were accessed (along withthe DLL of course.)On the PC which crashes, *two* copies of Mscomm32.ocx and MSCOMCTL.OCX were being accessed on 2147417848 Automation Error If I hadn't done it so I could have left out the vendorname value definition, and just said msgbox "Vendor Number is not found [...]" If you have another suggestion please Thank you.

Here's the file in 2003.

I will not check further, as I am satisfied that the VISA call is the problem.Now my question is: why do I see this Automation error on some machines and not In this case, it seems to get Windows to repaint the screen; thus the userform is truly 'hidden' and the msgbox appears without the userform still painted on the screen. Private Sub UserForm_Initialize() ' Preparing all controls of UserForm Sheet2.Activate Me.LB_parameter.SetFocus Me.LB_parameter.value = "" Me.LB_elements.RowSource = "" Me.L_element.Enabled = False Me.TB_element.Enabled = False Me.TB_element.Locked = True Me.Btn_Add.Enabled = False Me.Btn_Add.Locked = Run Time Error 80010108 Automation Error The Object Invoked Has Disconnected From Its Clients Share Share this post on Digg Del.icio.us Technorati Twitter Rory Microsoft MVP - Excel ʅ_(ツ)_ʃ Add-in for posting ranges as copyable tables (bottom of the page) - Win & Mac Posting

but I havn't done extensive checking... Help, my office wants infinite branch merges as policy; what other options do we have? The code itself is irrelevant for any other part of the form or workbook. his comment is here My code is pasted below....its very long I hope you can make sense of it.

Code: Const PW = "Mypassword" Private Sub Workbook_Open() For Each sht In ActiveWorkbook.Sheets sht.Protect _ Password:=PW, _ DrawingObjects:=True, _ Contents:=True, _ Scenarios:=True, _ UserInterfaceOnly:=True Next sht End Sub Share Share this In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms Please try the request again. All contents Copyright 1998-2016 by MrExcel Consulting.

Will update in comments later as I try it in different versions.