msdn有提供office用的vba类库吗？

Question

 我在用excel的宏进行一些开发的时候，在msdn找不到vba的一些函数参考手册。（P.S.新版的msdn看的我一塌糊涂……）只好在论坛上问一下了。

Answer 1

你好

好像沒有長詳的VBA 文章,有沒有想過用VSTO 寫一些ADD-ONS?

或者你可以參考以下URL

http://msdn.microsoft.com/zh-cn/library/ee814737.aspx

Please correct me if my concept is wrong

---

Chi

Answer 2

VBA参考是Office的文档的一部分，安装Office的时候没有装帮助么？

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP

Answer 3

我的本意是想有一个类似于C#，C++这些编程语言的函数参考手册，或者说类库。比如说，我可以搜索string，然后从这个类中找到format、mid等成员函数和用处。但我在网上找不到vba相类似的一个东西，所以想问一下。版主说的那个是宏的一个入门介绍，不太适合我。然后mvp说的那个我看了下，office帮助里面也是对宏仅仅一个简单的介绍。

网上倒是有一些技术文章，就是显得太零散了。

Answer 4

Offce的VBA参考是介绍Office的DOM的各种对象、属性和方法……

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP

Answer 5

1. Office附带的帮助文档中，有很详尽的描述。

2. 网络上搜索，可以下载到很多PDF、chm格式的相关内容。

VBA在Office里，占据的地位还是很重要的，要成为Office高手，必须掌握VBA，我喜欢VBA！让我的Office技能更上一层楼。

---

http://www.cnblogs.com/2gua

Answer 6

可是我在帮助文档中找不到任何有价值的东西啊……郁闷。你能给我一个网址链接吗？

Answer 7

VBA Language Reference

---

---

The following is signature, not part of post
Please mark the post answered your question as the answer, and mark other helpful posts as helpful, so they will appear differently to other users who are visiting your thread for the same problem.
Visual C++ MVP