Office VBA开发人员的文档资源 [英] Documentation Resource for Office VBA developers

问题描述

在哪里可以找到有用的VBA编程文档？像SitePoint for HTML开发。
MSDN简单地列出并描述了类的操作和属性/方法，而不是说明它们使用什么，或何时使用它们。

Where do I find helpful documentation for VBA programming? something like SitePoint for HTML development. MSDN simply lists down and describes the operation and properties/methods of classes instead of explaining what they are used for, or when to use them.

图书也欢迎。

推荐答案

Excel / VBA在过去两年的开放和对基本文档的质量非常失望。 帮助文件几乎没有价值。同样的MSDN版本更好，因为它有更好的内部链接，但仍然相当薄。以下是我发现有用的一些资源：

I have been working with Excel/VBA on and off over the past two years and have been very disappointed in the quality of the basic documentation. The "help" file is almost worthless. The MSDN version of the same thing is better because it has better internal links, but still quite thin. Here are some resources which I have found helpful:

使用VBA编写Excel宏，第二版由Steven Roman编写。第5-8章有一个体面的旅游语言（您可以在Google图书中找到片段）：

Writing Excel Macros with VBA, 2nd Edition by Steven Roman. Chapters 5-8 have a decent "tour" of the language (you can find snippets in Google Books):

http://www.amazon.com/Writing-Excel-Macros-VBA-2nd/dp/0596003595#noop

VB 6.0程序员指南，主要也适用于VBA：

The VB 6.0 Programmer's Guide, which mostly also applies to VBA:

http://msdn.microsoft.com/en-us/library/aa716285（VS.60）.aspx

还有各种具有很多示例资料的Excel大师顾问网站。其中大部分是普通的Excel或非程序员，但对于一般的VBA来说仍然是非常有用的。两个这样的网站特别是来自 Chuck Chip Pearson和Charles Williams：

There are also various Excel "guru" consultant websites out there that have a lot of example material. Much of it is pitched Excel in general or to non-programmers, but can still be quite useful for picking up VBA in general. Two such sites in particular are from Chuck Chip Pearson and Charles Williams:

http://www.cpearson.com/excel/mainpage.aspx

http://www.decisionmodels.com/

我是即将发布一篇关于我从未如何发现VBA语言规范的贬低评论，但是我想我只会在一年前才再次出现Google：

I was about to type a disparaging comment about how I never found a VBA language spec, but I figured I'd Google it again and lo and behold, from only just about a year ago:

http://msdn.microsoft.com/en -us / library / dd361851（PROT.10）.aspx

这可能包含我通过实验和编码结果解决的一些问题的答案作为单元测试...

This might contain the answers to some questions I have resolved only by experimentation and encoding the results as unit tests...

这篇关于Office VBA开发人员的文档资源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！