n. 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,291 Interesting..thanks, were I added a lot more code to another routine. I very very very seldom work with ActiveSheet - most of the time I know exactly what object I'm working with. http://stackoverflow.com/questions/3100952/what-causes-ms-vb-run-time-error-2147417848-80010108-in-excel-macro
The query does complete, at least as far as I can see. 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 Here's the file in 2003.
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. If I then stop the code execution, I can't even see any of the Excel worksheets any longer. Powered by vBulletin Version 4.2.2 Copyright © 2016 vBulletin Solutions, Inc. Excel Vba Run Time Error 2147417848 Afterward, Excel us unresponsive and has to be closed with the Task Manager.
Tuesday, May 06, 2014 8:52 PM Reply | Quote 0 Sign in to vote I resolve this issue by deleting the worksheet and rebuilding it instead of just clearing it. Run Time Error 2147417848 80010108 Automation Error totSheets = Sheets.Count i = 1 sheetFound = False For i = 1 To totSheets If Worksheets(i).Name = FileName Then Worksheets(FileName).Activate sheetFound = True Exit For End If Next i Sheets.Add it doesn't work, it throws 'Object disconnected' kind of error. asked 4 years ago viewed 5048 times active 5 months ago Get the weekly newsletter!
The tool is used by others, and they experience the same issues that I see, so it isn't just my computer. Runtime Error 2147417848 Hotfix Application.ScreenUpdating = TrueRegards, OssieMac Marked as answer by Money Tree Wednesday, May 07, 2014 11:25 PM Unmarked as answer by Money Tree Wednesday, May 07, 2014 11:25 PM Wednesday, May 07, Script or function to return how many days from now until a given date Are there any OSes that verify program signatures before executing them? Assuming that's Sheet1, you could do this: Sheet1.Cells(x, y) = v If that still fails, then you can be even more specific about the Range object you're accessing and the property
Following suppresses Screen Updating while code is running. I have not found a pattern for when it works and when it does not work. Run-time Error '-2147417484 (80010108)' Automation Error 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 "run-time Error -2147417848 (80010108)" Excel p45cal - - - - -This is my signature, it appears after all my posts.
Browse other questions tagged excel vba runtime or ask your own question. I am using Excel ... Sign in Share More Report Need to report the video? I was looking for code that would close the connection between Excel and the Access database but couldn't find anything. Runtime Error 2147417848 (80010108)
Not the answer you're looking for? Results 1 to 11 of 11 Thread: Run-time error '-2147417848 (80010108)' Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Watch QueueQueueWatch QueueQueue Remove allDisconnect The next video is startingstop Loading... 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
There are other formatting related commands right before this font.bold command that don't have anything to do with the database. 2147417848 Automation Error That error is sometimes due to corruption in the worksheet/workbook.Regards, OssieMac Marked as answer by Money Tree Thursday, April 24, 2014 7:53 PM Unmarked as answer by Money Tree Monday, April share|improve this answer answered Apr 21 at 14:19 Daniil Koshelyuk 113 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign
If it finds one, then it updates ' that sheet. How can I diagnose possible problems with my breadboards? I select the range, show existing values and get the new value. Run Time Error 80010108 Automation Error The Object Invoked Has Disconnected From Its Clients This project's been on hold for a long time now, but I can finally move on past this.
See this example. Anxious about riding in traffic after 20 year absence from cycling Change permission of file Why can't I create a Permissions Level? Related 0VBA - Can anyone explain why I get object errors with Cells()?0Colleagues get error 5 in Excel-file with VBA, but same file works fine on my computer?0Object Library Invalid error During the debug I checked all values are defined and have values.
Please help? Why were weapons like Mandrakes and Acromantula, which kill indiscriminately, used in the Battle of Hogwarts? it all works fine now try to create controls within the frames created inside 'Frame1' and it still works fine. Odd, because the macro recording gave me the refresh outside the with statement so I assumed that would be ok, although I had considered moving it when re-writing.
I tried copying the code to a blank spreadsheet and it fixed the problem. Wednesday, April 30, 2014 7:06 AM Reply | Quote 0 Sign in to vote No, no need to reinstall. I tried this and it worked. Printer Channel 244 views 2:00 How to Fix Windows Update Errors - Duration: 9:55.
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 It was the first routine that I created for this spreadsheet. If you try to create a frame control at runtime within another frame (say FrameA) using .add("Forms.Frame.1"), it works only if there is no other frame added to userform after creation Thanks for your help.
The time now is 04:06 AM. Some of the captions and potential values are in Unicode in case it matters, though I tried putting it all in English as well. Edited by Money Tree Tuesday, May 06, 2014 4:06 PM Tuesday, May 06, 2014 4:01 PM Reply | Quote 0 Sign in to vote I have learned something new that may Watching worksheets get deleted, recreated, and reformatted can be distracting.
Now I need to figure out a way to make this visually quiet to the user. to elaborate... Thanks! –David C.
© Copyright 2017 mwdsoftware.com. All rights reserved.