在Visual Basic 6.0中使用Microsoft(Office)365工具 [英] Using Microsoft (Office) 365 tools in Visual Basic 6.0

问题描述

我正在开发一个用Visual Basic 6.0编写的应用程序，该应用程序支持将listViews导出到Microsoft Excel文档.如果用户安装了较旧版本的Microsoft Office，则一切正常.

现在，我要添加对仅在系统上具有Microsoft/Office 365的用户的支持.在过去的几天里，我一直在搜索Google进入抑郁症的行列，因为我对dll/ocx文件或注册表知之甚少(或什至不了解).正如

我也曾尝试在注册表中搜索<​​code> Excel.Application ，如建议的此处所示，但是我找不到对应的ActiveX文件的路径(如果我正确理解的话，这可能意味着该文件未注册).

我该怎么办?任何帮助将不胜感激.

解决方案

没关系，我自己找到了答案.问题是，当我安装新的365软件包时，我安装了较早的Office版本，并且由于某些奇怪的原因，未注册365版本的.dll文件.当我删除那些较旧的版本时，所有可运行的.dll文件都与它们一起消失了.

我修复了365安装，现在可以正常运行了.

I'm developing an application written in Visual Basic 6.0 that supports exporting listViews to Microsoft Excel documents. Everything works perfectly fine if a user has an older version of Microsoft Office installed.

Now I want to add support for users who only have Microsoft/Office 365 on their systems. I've googled my way into depression in the past couple of days because I don't know much (or anything really) about dll/ocx files or registries. I'm not even sure if something like this can even be done because VB6 is really old, as noted here.

I've tried using this approach, but it didn't help me.

Right now, I'm getting a 429 runtime error

ActiveX Component can't create object

on line

Set objExcel = CreateObject("Excel.Application")

I only have Microsoft 365 trial version (no older ones) installed on the system and have these two things checked in my references:

I've also tried searching for Excel.Application in the registry, as suggested here, but I can't find the path to the corresponding ActiveX file (which probably means it is not registered if I understand this correctly).

What can I do? Any help would be greatly appreciated.

解决方案

Never mind, I found the answer myself. The problem was that I had older Office versions installed when I installed new 365 package and for some odd reason the .dll files for 365 version weren't registered. When I deleted those older versions all the working .dll files were gone with them.

I did a repair of the 365 installation and it's working perfectly now.

这篇关于在Visual Basic 6.0中使用Microsoft(Office)365工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！