Loading...

Mastering VBA for Microsoft Office 365

Richard Mansfield

  • Categorie: Computers & Informatica
  • EAN: 9781119579335
For Microsoft Office 365
Inhoud
Taal:en
Bindwijze:Paperback
Oorspronkelijke releasedatum:03 september 2019
Aantal pagina's:944
Illustraties:Nee
Betrokkenen
Hoofdauteur:Richard Mansfield
Hoofduitgeverij:Sybex Inc.,U.S.
Overige kenmerken
Editie:4
Extra groot lettertype:Nee
Product breedte:188 mm
Product hoogte:53 mm
Product lengte:234 mm
Studieboek:Ja
Verpakking breedte:184 mm
Verpakking hoogte:51 mm
Verpakking lengte:229 mm
Verpakkingsgewicht:1789 g


Productbeschrijving

Automate and customize Office 365 and Office 2019 applications using VBA

Visual Basic for Applications is the underpinning of Microsoft Office and the essential tool for tailoring Office to do your exact bidding. This 2019 Edition of Mastering VBA for Microsoft Office 365 and Office 2019 features clear, step-by-step tutorials to show both inexperienced and veteran programmers how to customize and automate each of the major Office 365 applications: Word, Excel, PowerPoint, Outlook, and Access.

Each new incarnation of Office incorporates changes as the technology evolves, and this edition of Mastering VBA for Microsoft Office 365 (2019 Edition) covers every update, including those to code libraries, the API, and object models. It begins with VBA basics, recording macros, and learning how to use the Visual Basic editor. As you move forward, you'll explore VBA syntax; understand with variables, constants, and enumerations; find the objects and methods you need; and make decisions using loops and functions. You will create effective user interfaces with message boxes, input boxes, custom dialog boxes, and complex forms. And you'll master the skills of building and debugging modular code. Throughout, you'll apply what you've learned by creating powerful macros. You'll be able to increase productivity by automating hundreds of tasks—opening up a whole new world of control over how Office applications behave. You'll even know how to do many things that are impossible any other way—such as have Word fetch data from an Excel workbook and insert it into a Word document. Automatically.

Mastering VBA for Microsoft Office 365 (2019 Edition) is your complete and comprehensive guide to:

  • Getting started with VBA and recording macros
  • Using loops and functions
  • Creating code with the Visual Basic Editor
  • Using array variables and built-in functions
  • Getting user input with input boxes and forms
  • Building modular code and using classes
  • Handling errors and debugging your code
  • Managing Office VBA security features
  • Advanced for each Office application

Automate Office 365 and 2019 Applications

Create Custom Apps for Word, Excel, PowerPoint, Outlook, and Access

Master Basic to Advanced VBA Macro Programming

Build Your Skills with Useful, Real-World Examples and Projects