如何处理缺少的VBA引用（到Excel） [英] How to handle a missing VBA reference (To Excel)

问题描述

大家好，


我正在将一些访问项目迁移到2010年（从2003年开始）并遇到了另一个问题，


背景：我们将一些PC升级到Office 2010，但不是全部，有些已经删除了办公室（我们正在使用查看器和访问运行时）。


问题：在一个项目中，我有一个Excel（11.0）的引用，所以我可以直接导出一些东西excel，现在如果没有安装excel，它不能说参考，我能做些什么来克服这个问题？ （删除引用会使代码对象无效，并且它会得到所有狡猾的）


我在想某种方式封锁 excel代码/模块，如果无法找到引用，那么我不必运行前端的两个版本。


任何想法？


干杯

解决方案

你可以尝试识别在安装了该软件的PC上找到的文件（工具 | 参考文献列出了找到文件名的实际文件的位置。）并将这些文件复制到任何PC没有安装软件。


我恐怕不能告诉你这是否符合许可证，因为我真的不知道。我不能想象它会发生冲突，但我无法确定。

我想到了，但引用的文件是excel.exe本身，所以我想，它不会不行，但我可以尝试

在这种情况下，我很确定这将是对许可的侵犯，我无法推荐。

Hi guys,

I am in the process of migrating some access projects to 2010 (from 2003) and have hit another problem,

The background: we have upgraded some PC to office 2010, but not all, and some have had office removed (and we are using the viewers and access runtime).

Problem: in one project i have a reference to Excel (11.0) so that i can export some things straight to excel, now if excel isn''t installed, it cant comit that reference, is there anything i can do to overcome this? (removing the reference invalidates the code objects, and it gets "all shouty")

i was thinking of somehow "blocking off" the excel code/modules if the reference couldn''t be found, so that i didnt have to run two versions of the Front End.

Any ideas?

Cheers

解决方案

You could try identifying the files found on the PCs where the software is installed (Tools | References lists where the actual files are found with the file names.) and copying just these files to any PC that doesn''t have the software installed.

I''m afraid I can''t tell you if this is in accordance with the license as I really don''t know. I don''t imagine it conflicts, but I can''t be certain.

I thought about that, but the file referenced is excel.exe itself, so I imagined, it wouldn''t work, but I could try

In that case I''m pretty sure it would be an infringement of the license and I couldn''t possibly recommend that.

这篇关于如何处理缺少的VBA引用（到Excel）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！