Internet Explorer 9和Excel VBA [英] Internet Explorer 9 and Excel VBA

问题描述

编码员，

当我尝试使用效果很好的vba代码在IE8中加载网址时.但是，如果我使用IE9尝试相同的代码，则会出现类似无法指定项目或dll"的错误..

但是我已经启用了 Microsoft Internet Control 参考.

因此，如果有人知道解决方案，请回复我.

在此先感谢.

Hi coders,

When I try to load a url in IE8 using vba code that works well. But if I try that same code using IE9 I get the error like "can not specified the project or dll".

But I already enabled Microsoft Internet Control reference.

So please if anyone knows the solution reply to me.

Thanks in advance.

推荐答案

在我的项目中，"Microsoft Internet Controls"引用为:C:\ Windows \ SysWOW64 \ ieframe.dll，下面的代码正常工作. />

In my project "Microsoft Internet Controls" referenced to: C:\Windows\SysWOW64\ieframe.dll and code below works properly.

Option Explicit

Sub dsadas()
Dim ie As InternetExplorer

Set ie = New InternetExplorer
ie.Navigate "http://www.codeproject.com/Questions/238339/Internet-Explorer-9-and-Excel-VBA"
ie.Visible = True

Set ie = Nothing
End Sub

这篇关于Internet Explorer 9和Excel VBA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！