舉報

會員
VBA Automation for Excel 2019 Cookbook
VisualBasicforApplications(VBA)isaprogramminglanguagedevelopedbyMicrosofttoautomatetasksinMSOfficeapplications.ThisbookwillhelpyoutofocusontheessentialaspectsofyourrolebyautomatingmundanetasksinExcelandotherOfficeapplications.WithcomprehensivecoverageofVBAdeliveredintheformofpracticeproblemsandbite-sizedrecipes,thisbookwillhelpyoutohitthegroundrunning.Unlikemostbooksthatassumepriorprogrammingexperience,thisbookstartswiththefundamentalsandgraduallyprogressestosolvingbiggerproblems.You’llstartbybecomingfamiliarwithVBAsothatyoucanstartrecordingmacrosrightaway.Withthisfoundationinplace,you’lladvancetousingthefullcapabilitiesofthelanguageasyouapplyloops,functions,andcustomdialogboxestodesignyourownautomationprograms.You'llalsogettogripswithembeddedmacrosandotheradvancedtoolstoenhanceproductivityandexploretopicsrelatingtoappperformanceandsecurity.ThroughoutthisVBAbook,you’llcovermultiplepracticeprojectsinExcel,Word,andPowerPointwhileexploringtipsandbestpracticestohoneyourskills.Bytheendofthisbook,you’llhavedevelopedtheskillsyouneedtouseVBAtocreateyourownprogramsthatcontrolMSOfficeapplications.
目錄(138章)
倒序
- 封面
- 版權信息
- Why subscribe?
- Contributors About the author
- About the reviewer
- Packt is searching for authors like you
- Preface
- Who this book is for
- What this book covers
- To get the most out of this book
- Code in Action
- Download the color images
- Conventions used
- Sections
- Get in touch
- Reviews
- Chapter 1: Getting Started with VBA
- Technical requirements
- Investigating VBA code
- Recording a macro
- Testing the macro
- Using the VBA Editor
- Editing the code by changing cell references
- Saving the file with an embedded macro
- Using the Trust Center for macro security
- Creating a customized ribbon
- Chapter 2: Working with the VBA Editor
- Technical requirements
- Identifying activating and closing components in the VBA Editor
- Creating a module for storing a Sub procedure
- Creating a basic procedure in the code window of the Editor
- Creating VBA code in the code window in three different ways
- Customizing the Editor tab to suit your preferences
- Chapter 3: The VBA Object Model
- Technical requirements
- Understanding and identifying objects in VBA
- Objects as a collection and changing the attributes of the entire collection
- Modifying object properties
- Associating methods with objects
- Using events to activate objects
- Using the Object Browser in the VBA Editor
- Chapter 4: Working with Procedures
- Technical requirements
- Creating Sub and Function procedures
- Executing Sub procedures directly
- Executing Sub procedures from the Macro dialog box
- Executing Sub procedures using buttons
- Executing Sub procedures using a shortcut key
- Executing Function procedures using a worksheet formula
- Executing Function procedures by calling from a Sub procedure
- Chapter 5: Next Level Recording
- Technical requirements
- Setting the macro recorder for absolute or relative reference
- Recording options
- Chapter 6: VBA Language Elements
- Technical requirements
- Adding comments
- Declaring variables
- Declaring constants
- Working with data types in variables and constants
- Scoping variables
- Declaring arrays
- Chapter 7: Working with Ranges
- Technical requirements
- Referring to ranges
- Using the Range object properties
- Adding the Range object's methods
- Making ranges work
- Chapter 8: Using Functions
- Technical requirements
- Using built-in VBA functions
- Using worksheet functions
- Creating custom functions
- Chapter 9: Implementing Program Flow
- Technical requirements
- Exploring program flow
- Changing the flow using the GoTo statement
- Using If and If-Then structures to make decisions
- Using the Select Case structure
- Using loops
- Chapter 10: Implementing Automation
- Technical requirements
- Writing event handler procedures
- Discovering events
- Creating workbook-related events
- Creating worksheet-related events
- Creating non-object events
- Chapter 11: Handling Errors
- Technical requirements
- Handling different types of errors
- Correcting a runtime error
- Testing to find errors
- Using the On Error statement
- Resuming after an error
- Chapter 12: Debugging
- Technical requirements
- Exploring various bugs
- Debugging techniques
- Using the debugger in Excel
- Chapter 13: Creating and Modifying Dialog Boxes
- Technical requirements
- Using the MsgBox function
- Using the InputBox function
- Using the Application.InputBox method
- Chapter 14: Creating UserForms
- Technical requirements
- Inserting the form
- Changing properties
- Adding controls
- Using Frames
- Chapter 15: UserForm Controls
- Technical requirements
- Assigning controls
- Unloading a form
- Loading the form
- Using the Combo Box control
- Using the SpinButton control
- Setting the tab order
- Chapter 16: Creating Custom Functions
- Technical requirements
- Writing functions
- Calling functions
- Adding function arguments
- Displaying function and argument descriptions
- Chapter 17: Creating Word Documents with Excel VBA
- Technical requirements
- Creating a new instance of Word
- Writing and formatting text
- Copying data into Word
- Using templates and bookmarks
- Chapter 18: Working with PowerPoint in Excel VBA
- Technical requirements
- Creating a new instance of PowerPoint
- Creating presentations and slides
- Adding text to textboxes
- Copying Excel content into PowerPoint
- Other Books You May Enjoy
- Leave a review - let other readers know what you think 更新時間:2021-06-11 18:16:56
推薦閱讀
- Cocos2D-X權威指南(第2版)
- UML和模式應用(原書第3版)
- Computer Vision for the Web
- Photoshop智能手機APP UI設計之道
- C# Programming Cookbook
- 深入理解Java7:核心技術與最佳實踐
- Object-Oriented JavaScript(Second Edition)
- C++ 從入門到項目實踐(超值版)
- Java 11 Cookbook
- 零基礎學Python網絡爬蟲案例實戰全流程詳解(高級進階篇)
- 深入RabbitMQ
- 深入實踐Kotlin元編程
- Simulation for Data Science with R
- Python Projects for Kids
- Python面向對象編程(第4版)
- Microsoft XNA 4.0 Game Development Cookbook
- Swift Essentials(Second Edition)
- Pandas入門與實戰應用:基于Python的數據分析與處理
- 零基礎入門Python數據分析與機器學習
- 信息安全技術(第2版)
- Instant PhoneGap
- HTML5從入門到精通(第3版)
- The PHP Workshop
- HTML5+CSS3從入門到精通(微課精編版)
- 大數據可視化編程和應用
- Selenium 1.0 Testing Tools: Beginner's Guide
- MATLAB 2020 圖形與圖像處理從入門到精通
- Oracle公有云實用指南
- C 語言程序設計能力教程(第四版)
- QlikView for Developers