2147417848 80010108 automation error the
One games Xbox 360 games PC automation error the object invoked has disconnected from its clients games Windows games Windows phone games Entertainment All run time error 2147417848 (80010108) Entertainment Movies & TV Music Business & Education Business Students & "run-time error -2147417848 (80010108)" excel educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about run time error 2147417848 80010108 automation error hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Excel Vba Run Time Error 2147417848Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/33850202/run-time-automation-error-2147417848-80010108 and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it automation error only takes a minute: Sign up “Run-time automation error -2147417848 (80010108)” up vote 0 down vote favorite I use VBA excel to parse a long list of local .htm files. The problem is that I get an error even before the programm starts to parse the HTM-files. Error is: VBA code: Enum READYSTATE READYSTATE_UNINITIALIZED = 0 automation error the READYSTATE_LOADING = 1 READYSTATE_LOADED = 2 READYSTATE_INTERACTIVE = 3 READYSTATE_COMPLETE = 4 End Enum Sub ImportHTM() 'Dim ie As InternetExplorer Dim ie As InternetExplorerMedium Dim html As HTMLDocument Set ie = New InternetExplorerMedium 'Set ie = New InternetExplorer ie.Visible = False ie.navigate "d:\Cloud\Dropbox\3.htm" Do While ie.READYSTATE <> READYSTATE_COMPLETE Application.StatusBar = "Loading Profile..." 'PROBLEM SEEMS TO BE HERE SOMEWHERE! DoEvents Loop Set html = ie.document Set ie = Nothing Application.StatusBar = "" 'code code code --> which at this point isn't executed because the error occures before Do you have any ideas what could cause the problem? Do you have any solution suggestions? Also the command: ie.Visible = False doesn't seem to have any effect whatsoever since it opens the HTM-file in a new IE window. excel vba excel-vba share|improve this question edited Nov 22 '15 at 0:17 pnuts 33.7k63569 asked Nov 22 '15 at 0:14 user3185735 1068 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Move the status bar update out of the loop. Application.StatusBar = "Loading Profile..." Do While ie.Busy Or ie.READYST