VBA更改Excel 2002 - > Excel 2007 [英] VBA changes Excel 2002 -> Excel 2007

问题描述

在哪里可以从Excel XP（2002）到Excel 2007中找到VBA中完整的更改列表？我有一本非常依赖VBA的工作簿，我在2002年一直在努力，当我在2007年打开它时，我注意到有些事情发生了变化。例如，我的工作簿做了大量的3D旋转;我发现， Shape.ThreeD.RotationX 已经成为 Shape.ThreeD.RotationY ，反之亦然。我还发现我必须否定旋转值，以便

Where can I find a complete list of changes in VBA from Excel XP (2002) to Excel 2007? I have a workbook that relies heavily on VBA which I have been working on in 2002, and when I opened it in 2007, I noticed that some things had changed. For instance, my workbook does lots of 3d rotation; I discovered that Shape.ThreeD.RotationX has become Shape.ThreeD.RotationY and vice-versa. I also discovered that I have to negate the rotation values, so that

Shape.ThreeD.RotationX = 90

成为

Shape.ThreeD.RotationY = -90

我相信还有其他的变化，我有大概错过了我没有看到上面的变化在任何地方详细说明，所以我想知道：

I am sure that there are other changes as well, which I have probably missed. I haven't seen the above changes detailed anywhere, so I would like to know:

哪些网站详细介绍了如上所述的更改？

Which sites detail changes such as the ones I have outline above?

推荐答案

1. 打开Excel 2007并进入VBA编辑器（Alt + F11）


2. 打开帮助（F1）


3. 点击新功能


4. 点击对象模型更改自Microsoft Office XP（2002）

1. Open Excel 2007 and go into the VBA editor (Alt+F11)
2. Open up Help (F1)
3. Click What's New
4. Click Object Model Changes Since Microsoft Office XP (2002)

Voila！

这个列表是相当全面的以及互动的，所以我不会在这里重现。但是，自97，2000和2003版本起，它也有变化。

This list is fairly comprehensive as well as interactive, so I won't reproduce it here. But it also has changes since the 97, 2000, and 2003 versions.

这篇关于VBA更改Excel 2002 - > Excel 2007的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！