我继承了一个旧的 Excel 2003 应用程序，需要对其进行转换，以便它可以在 Excel 2007 中运行。该应用程序使用电子表格作为应用程序内部的“弹出窗口”来进行体积计算。在 Excel 2003 中，这可以按预期工作。在 Excel 2007 中，VBA 抱怨“需要对象”错误。
通过对象浏览器浏览，Excel 2003 将“VolSheet”列为电子表格对象。 Excel 2007根本找不到它。但是，如果循环遍历所有形状 (ActiveSheet.Shapes)，Excel 2007 确实会将“VolSheet”列为形状。
我的问题是：有没有办法强制 Excel 2007 将 VolSheet 识别为电子表格？我是否必须在某处将其调暗并找到一种将形状引用转换为电子表格的方法？我能否欺骗 Excel 2007 使其认识到它实际上已存在于其中一个工作表中？
I've inherited an old Excel 2003 application, and need to convert it so that it works in Excel 2007. The application makes use of a spreadsheet as a "popup" inside the application for doing volume calculations. In Excel 2003, this works as expected. In Excel 2007, VBA complains with an "Object Required" error.
Browsing through the Object Browser, Excel 2003 lists "VolSheet" as a Spreadsheet object. Excel 2007 can't find it at all. Excel 2007 does list "VolSheet" as a Shape if you loop through all shapes (ActiveSheet.Shapes), however.
My question is: Is there a way to force Excel 2007 to recognize VolSheet as a spreadsheet? Would I have to Dim it somewhere and find a way to convert the Shape reference to a spreadsheet? Can I trick Excel 2007 into recognizing that it does in fact already exist inside one of the Worksheets?
发布评论
评论（1）
似乎您需要更新 2007 计算机上的 OWC 安装
Office Web Components 版本 11 最初不支持 Office 2007，但已更新为在 SP1 中添加它。请参阅链接和安全补丁的链接。
Seems like you need to update your install of OWC on the 2007 machine
Office Web Components version 11 initially did not support Office 2007, but was updated to add it in SP1. See Link and Link for a security patch.