VBA兼容性问题:64位Windows7(缺少MSINET)和Trim函数兼容性问题 [英] VBA compatibility issues: 64-bit Windows7 (MSINET missing) and Trim function compatibility issues

问题描述

我正在尝试将在32位Windows XP上运行的VB Excel应用程序升级到Windows 7 64位操作系统.有两个问题影响这种操作.我发现这些主题并不罕见.

I'm trying to upgrading a VB Excel application working on Windows XP 32-bit to Windows 7 64-bit operating system. There are two issues affecting such operation. I have found that these topics are not uncommon.

1. VBA脚本必须连接到要求Microsoft Internet传输协议6.0(SP 6.0)-在System32目录中注册的MSINET的服务器.不幸的是，上述库只能在32位操作系统上运行，而没有针对64位版本的发行版.我尝试导入到参考列表:这似乎起作用，但是，一旦我重新启动应用程序，就找不到dll(仅是ocx文件-Active X).显然，该dll无法通过regsvr32应用程序注册.在64位版本的Windows上有类似于MSINET的东西吗?

1. The VBA script has to connect to a server requiring Microsoft Internet Transfer Protocol 6.0 (SP 6.0) - MSINET registered in System32 directory. Unfortunately the aforementioned library works on 32-bit operating systems only and no release is available for 64-bits. I've tried to import to Reference List: this seems to work, however once I restart the application no dll (merely a ocx file - Active X) could be found. Obviously the dll cannot be registered through regsvr32 application. There's something similar to MSINET working on 64-bit version of Windows?

我发现的第二个问题与上一个问题无关.应用程序需要解析输入字符串以删除空格.旧的VBA使用TRIM，我想我不必对此进行任何更改.但是，编译操作会导致以下错误:编译错误:找不到项目或库".没有引用丢失(MSINET除外).

The second issue I found is not related to the previous one. The application need to parse an input string removing white spaces. The old VBA uses TRIM and I suppose I have to make no changes about it. However the compiling operation results in the following error: "Compile error: Can't find project or library". No references are missing (except for MSINET).

我使用的是64位Windows 7，Office 2010，microsoft.office.interop.excel.dll 14.谢谢

I'm on a 64-bit Windows 7, Office 2010, microsoft.office.interop.excel.dll 14 installed. Thank you

推荐答案

1. 32位软件在64位系统上可以正常工作.您不想要64位ocx，则无论如何都无法使用它.Google上有大量手册，介绍如何在64位Windows 7上注册32位ocx，例如通过搜索自己找到答案.

但是，如果您拥有64位办公室，则将完全无法使用msinet控件，并且在删除对msinet的引用之前，不会重新出现修剪功能.

If, however, you have 64-bit office, you will not be able to use msinet control at all, and the trim function will not reappear until you remove the reference to msinet.

这篇关于VBA兼容性问题:64位Windows7(缺少MSINET)和Trim函数兼容性问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！