基本语法和示例教程 [英] Basic Syntax and Examples Tutorial

问题描述

在工作中，我与MS-Office紧密合作.我设法生成了一些执行各种任务的脚本.虽然我可以很困难地将功能移植到VBA，但我还不完全了解VBA语言的基础.

At work I work closely with MS-Office. I have managed to generate some scripts that perform various tasks. While I can port functions to VBA with some difficulty, I do not fully understand the foundations of the VBA language.

我寻求基本语法和示例的项目包括:"hello world"程序，循环，流控制，变量声明，变量类型转换，对象(如果可能)，文件/用户输入/输出，以及"with"块可以使用，依此类推.

Items for which I seek basic syntax and examples include: 'hello world' program, loops, flow control, variable declaration, variable type conversions, Objects (if possible), file/user input/output, when 'with' block can be used, and so on.

有人可以给我提供VBA教程的链接，也许包含以上各项的详细信息吗?

Could someone provide me with a link to a VBA tutorial, perhaps with the details of the above items?

推荐答案

VBA post Office 2000的版本几乎与VB6相同.此 MSDN网站是一个很好的起点. VB6资源中心也可能有用.

The versions of VBA post Office 2000 are almost identical to VB6. This MSDN site is a great place to start. The VB6 resource center might also be of use.

这篇关于基本语法和示例教程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！