excel vba automation error the interface is unknown Copalis Beach Washington

Repairs Sales

Address 2222 Simpson Ave, Hoquiam, WA 98550
Phone (360) 268-3095
Website Link

excel vba automation error the interface is unknown Copalis Beach, Washington

If you still get an error with that new line, try stepping through the code by pressing the F8 key and see if you still get the error. Upgraded to the new ie8 Beta and works fine! On Windows Vista, to create an instance of Internet Explorer running at a medium integrity level, pass CLSID_InternetExplorerMedium (defined in exdisp.idl) to CoCreateInstance. I tried set xl=createobject("excel.application") and it did still has the same error. 2.

I went from Windows XP to Windows 7. The issue is that all this vbscript code was working in a Windows Vista Machine with IE 7. But all this is guesswork without knowing the URL. Bill Wednesday, February 15, 2012 4:55 PM Reply | Quote Moderator 0 Sign in to vote OK, I have reproduced the error and know what is causing it.

Security 3. I wrote much of my Access MapPoint interface six or more years back and have added new functionality as users request it but never gone back and checked for things like Carl A11-07-2008, 05:49 PMThis may be an issue with IE7. I moved all public variables and procedures into the form's module andremoved everything from the app except one form and the two tables required to provide a bit of test data.

Set IE = CreateObject("InternetExplorer.Application") IE.Navigate ("http://URLOnMyIntranet/site.html") IE.Visible = True Set IE = nothing Set objShellApp = CreateObject("Shell.Application") For Each objWindow In objShellApp.Windows Debug.Print objWindow.LocationName If LCase(objWindow.LocationName) = LCase("Your windows name, use Option Explicit Private Sub CommandButton1_Click() Dim ie As InternetExplorer Set ie = New InternetExplorer ie.Visible = True ie.Navigate ("www.google.com (http://www.google.com/)") While ie.busy DoEvents Wend ie.document.all("Q").Value = "HELLO" End Sub Hope this Many googles later, I came to this, and it solved the problem. Thank you again for your assistance with this. –Lkn4EffThruTech Feb 5 '14 at 16:51 I don't understand how CreateObject("Excel.Application") can fail if you have a functional version of Excel

I use the same technique Rey used above. 0 LVL 119 Overall: Level 119 MS Access 119 MS Development-Other 18 Programming Languages-Other 2 Message Active today Expert Comment by:Rey Obrero2014-04-29 Maybe we could see the error better if looking at the 'big picture'. HELP!!! It correctly logs into the site with no errors on Windows 7 (32) IE9.

i.e, i get the error, " the interface is unknown"Linson Tuesday, February 14, 2012 7:57 AM Reply | Quote 0 Sign in to vote I ran it with the CHAP dialog Excel Video Tutorials / Excel Dashboards Reports Reply With Quote September 26th, 2013 #4 BTK91 View Profile View Forum Posts I agreed to these rules Join Date 28th January 2013 Posts If you don't like Google AdSense in the posts, register or log in above. Even managers have to log into the proxy in order to use the Internet.

So while none of these are virgin machines, the behavior is consistent among two of their computers running Access 2010 runtime and my development computer running the full version of Access. There is a setting called "Enable Protected Mode" on the "Security" tab of the "Internet Options" dialog box (tools...internet options). Good Term For "Mild" Error (Software) Physically locating the server Does chilli get milder with cooking? Greetings pundabuyer, Unless you have the "tremors":old: , I see no way for Scott's code to open two windows. (Just joking about the "shakes" of course...) I have run both Maxims'

More clearly I get this error when IE object is accessed again after navigation. Quoting the small print in the documentation: Remarks Windows Internet Explorer 8. Then I removed all code and controls within that form to the bare minimum.I added the MapPoint 19 object library reference and changed all the code to early binding. This is odd behavior but it indicates that your web setup may be at fault.

Hot Network Questions (KevinC's) Triangular DeciDigits Sequence "Rollbacked" or "rolled back" the edit? The error being reported cannot be reproduced under any circumstances with a standard WIndows 7 installation and a plain vanilla web site set for basic authentication. ¯\_(ツ)_/¯ Edited by jrv Wednesday, Everything works perfectly, except the same issue reported above. It is a company website so I won't be revealing the code behind it so I believe that this is the end of my journey.

Is there a way around this without disabling protected mode for the internet zone? I am using Access 2010 (and Access 2003 before that) to programmatically send addresses to MapPoint 2010/2011/2013 and interact with the map in various way. These functions are part of the Windows API (Application Programming Interface). If, while a map is open, I then do a certain function in MapPoint (export the map to a GPX file three times), with or without other interaction via VBA or

I didnt find much info on that. Exit Do End If Next eachIE Loop Set eachIE = Nothing Set sh = Nothing While IE.Busy ' The new process may still be busy even after you find it DoEvents Richard Mueller - MVP Directory Services Tuesday, February 14, 2012 3:54 AM Reply | Quote Moderator 0 Sign in to vote But in my case i dont have any issue with Excel Video Tutorials / Excel Dashboards Reports Reply With Quote September 28th, 2013 #7 John_w View Profile View Forum Posts Development Team Member Join Date 21st November 2012 Posts 769 Re:

Bill Tuesday, February 14, 2012 7:51 PM Reply | Quote Moderator 0 Sign in to vote It doesn't work for me (your exact code except for url) on WS20003, XP, http://forums.microsoft.com/msdn/showpost.aspx?postid=843101&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 For what it is worth I did not have this problem until I started using the MSINET.OCX in Office 2007. Any better way to determine source of light by analyzing the electromagnectic spectrum of the light How do computers remember where they store things? Each "zone" can have a different setting for "enable protected mode" We unchecked "enable protected mode" and this solved our problem.

Privacy Policy Site Map Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor Services Groups Microsoft Access MVP Saturday, May 10, 2014 6:17 PM Reply | Quote 0 Sign in to vote I didn't do it quite that way, since MapPoint does not have a Maps Linson The same way you have been running it. How to get this substring on bash script?

SetWshShell=CreateObject("WScript.Shell") SetIE=CreateObject("InternetExplorer.Application") IE.Visible=True IE.Navigate("http://URLOnMyIntranet//?cid=6&c=12&cpc=dt2wJiVUfnQ2") DoWhile(IE.Busy) wscript.sleep200 Loop The error goes as follows ------------------------------------------------------------------ Script: C:\[PATH]\auto.vbs Line : 6 Char: 1 Error: The interface is unknown. In some way, the automation interface to Excel is broken. Do while (IE.Busy) WScript.Sleep (200) Loop -------------------------------------------------------------------------------------------------------- Full Source Code Set WshShell = CreateObject("WScript.Shell") Set IE = CreateObject("InternetExplorer.Application") IE.Navigate ("http://URLOnMyIntranet//?cid=6&c=12&cpc=dt2wJiVUfnQ2") IE.Visible = True WshShell.AppActivate IE wscript.sleep 2000 WshShell.AppActivate IE WshShell.SendKeys "username"