舉報

會員
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
推薦閱讀
- 零基礎學Visual C++第3版
- .NET之美:.NET關鍵技術深入解析
- Implementing Modern DevOps
- 軟件架構設計:大型網站技術架構與業務架構融合之道
- 騰訊iOS測試實踐
- JMeter 性能測試實戰(第2版)
- Learning Data Mining with R
- Java EE 7 Performance Tuning and Optimization
- 零基礎學單片機C語言程序設計
- Raspberry Pi Home Automation with Arduino(Second Edition)
- Natural Language Processing with Java and LingPipe Cookbook
- CoffeeScript Application Development Cookbook
- Go語言開發實戰(慕課版)
- Emotional Intelligence for IT Professionals
- Magento 2 Beginners Guide
- Java核心技術速學版(第3版)
- Apache Kafka 1.0 Cookbook
- Learning Puppet
- Learning IBM Bluemix
- Web 2.0策略指南
- UI設計參考手冊
- SQL優化核心思想
- Spring Boot開發實戰
- Mastering Software Testing with JUnit 5
- Java 9 Data Structures and Algorithms
- C#程序設計任務式教程
- C語言程序設計習題集與上機指導(第四版)
- Mastering Hibernate
- Python數據結構學習筆記
- Kali Linux Cookbook(Second Edition)