menu 简单麦麦
account_circle

用VBA编写Excel宏-Writing Excel Macros with VBA文件编号:656

已经帮助了2584人找到了他们想要的文件
上传于 2020年2月25日 16:03
48次下载
2152次围观
评分:4.5/5 ★ ★ ★ ★ ★
标题(title):Writing Excel Macros with VBA
用VBA编写Excel宏
作者(author):Steven Roman, PhD
出版社(publisher):O'Reilly Media, Inc
大小(size):3 MB (2841516 bytes)
格式(extension):epub
注意:如果文件下载完成后为无法打开的格式,请修改后缀名为格式对应后缀

Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used by the other applicati.  Read more...
Abstract: Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used by the other applicati
Table of contents :
Content: Table of Contents
Preface
Preface to the Second Edition
The Book's Audience
Organization of This Book
The Book's Text and Sample Code
About the Code
Conventions in this Book
Obtaining the Sample Programs
How to Contact Us
Acknowledgments
Introduction
Selecting Special Cells
Setting a Chart's Data Point Labels
Topics in Learning Excel Programming
Part I
Preliminaries
What Is a Programming Language?
Programming Style
Comments
Readability
Modularity
The Visual Basic Editor, Part I
The Project Window
Project Names
Project Contents
The ThisWorkbook object
Sheet objects. Standard modulesClass modules
UserForm objects
The Properties Window
The Code Window
Procedure and Full-Module Views
The Object and Procedure List Boxes
A workbook or sheet object
A standard module
A UserForm object
The Immediate Window
Arranging Windows
Docking
The Visual Basic Editor, Part II
Navigating the IDE
General Navigation
Navigating the code window at design time
Tracing code
Bookmarks
Getting Help
Creating a Procedure
Run Time, Design Time, and Break Mode
Errors
Design-Time Errors
Compile-Time Errors
Run-Time Errors
Logical Errors
Debugging
Tracing. Stepping intoStep Over (Shift-F8 or choose Step Over from the Debug menu)
Step Out (Ctrl-Shift-F8 or choose Step Out from the Debug menu)
Run To Cursor (Ctrl-F8 or choose Run To Cursor from the Debug menu)
Set Next Statement (Ctrl-F9 or choose Set Next Statement from the Debug menu)
Breaking out of Debug mode
Watching Expressions
Quick Watch (Shift-F9)
The Locals and Watches windows
Macros
Recording Macros
Running Macros
Part II
Variables, Data Types, and Constants
Comments
Line Continuation
Constants
Enums
Variables and Data Types
Variable Declaration. The Importance of Explicit Variable DeclarationOption Explicit
Numeric Data Types
Boolean Data Type
String Data Type
Date Data Type
Variant Data Type
Excel Object Data Types
The generic As Object declaration
The Set statement
Arrays
The dimension of an array
Dynamic arrays
The UBound function
Variable Naming Conventions
Variable Scope
Procedure-level (local) variables
Module-level variables
Variable Lifetime
Static variables
Variable Initialization
VBA Operators
Functions and Subroutines
Calling Functions
Calling Subroutines
Parameters and Arguments
Optional Arguments. Named ArgumentsByRef Versus ByVal Parameters
Exiting a Procedure
Public and Private Procedures
Project References
Fully Qualified Procedure Names
Built-in Functions and Statements
The MsgBox Function
The InputBox Function
VBA String Functions
Miscellaneous Functions and Statements
The Is Functions
The IsDate function
The IsEmpty function
The IsNull function
The IsNumeric function
The Immediate If Function
The Switch Function
Units Conversions
The Beep Statement
Handling Errors in Code
The On Error Goto Label Statement
The Error Object
The On Error GoTo 0 Statement.

想了解更多信息?可向上传者提问。点击提问
欢迎您上传文件!
费劲心机找到了自己想要的文件?
不如上传简单麦麦!
分享给别人!还能赚取收益
下载须知
1.如有解压密码 提取码都在下面 注意查看
2.如果有问题 可以通过卖家联系方式 联系卖家 如果没有或无法解决可以联系官方客服
3.本文件为公益分享,文件由网上采集而来,如有侵权等问题,请及时联系客服删除

常见问题及官方客服联系方式:点击前往 售后问题处理方式:点击前往
-到底部了哦-
expand_less