Inet对象的Excel VBA参考 [英] Excel VBA reference for Inet objects

问题描述

Excel VBA代码无法在此Dim语句中编译：

Excel VBA code is failing to compile on this Dim statement:

将FTP作为Inet

Dim FTP as Inet

显然，其他人已经解决了这个问题，包括对我所做的Microsoft Internet Controls的引用。这个引用指向：

Apparently, others have solved this problem by including a reference to Microsoft Internet Controls, which I have done. This reference is pointing to:

C：\Windows\SysWOW64\ieframe.dll

C:\Windows\SysWOW64\ieframe.dll

考虑到dll可能没有注册，我跑了

Thinking that the dll might not be registered, I ran

regsvr32 ieframe。 dll

regsvr32 ieframe.dll

具有管理权限，但收到错误消息，该模块已加载，但DllRegisterServer的调用失败，这可能是单独的问题。

with administrative privileges but got an error message that the module was loaded but "the call to DllRegisterServer failed", which might be a separate issue.

这是Inet对象使用的正确引用吗？如果是这样，我应该怎么做来编译这段代码？

Is this the right reference to use for Inet objects? If so, what should I do to compile this code?

请注意。

推荐答案

INet对象是Microsoft Internet Transfer Control 6.0（SP6）的成员，而不是Microsoft Internet Controls。 INet参考。可以在C：\Windows\SysWOW64\msinet.ocx中找到正确的控件。您可能必须在参考窗口中将文件类型框更改为ActiveX控件（* .oxc）。

The INet object is a member of the Microsoft Internet Transfer Control 6.0 (SP6), NOT Microsoft Internet Controls. INet Reference. The correct control can be found in C:\Windows\SysWOW64\msinet.ocx. You will likely have to change the "Files of type" box to "ActiveX Controls (*.oxc)" in the references window.

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