Mastering VBA for Microsoft Office 365, 2019 Edition (Paperback)

Richard Mansfield

  • 出版商: Sybex
  • 出版日期: 2019-07-30
  • 定價: $1,800
  • 售價: 8.0$1,440
  • 語言: 英文
  • 頁數: 984
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1119579333
  • ISBN-13: 9781119579335
  • 相關分類: Excel
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Customize and ramp-up Office 365 applications

The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint.

Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have been modified during the three years since the last version of this book. Various elements within VBA have been deprecated or replaced, and the surface UI changed as well. The updated 2019 edition covers topics such as:

- Recording macros and getting started with VBA

- Learning how to work with VBA

- Using loops and functions

- Using message boxes, input boxes, and dialog boxes

- Creating effective code

- XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security

Written for all levels of Microsoft Office 365 users, Mastering VBA Microsoft Office 365: 2019 Edition explains how to customize and automate the Office suite of applications.

商品描述(中文翻譯)

「自訂和提升 Office 365 應用程式」

2019 年修訂版的《精通 VBA Microsoft Office 365》提供了一本易於理解的指南,展示如何使用 VBA 程式設計來擴展 Office 365 應用程式的功能。本書以清晰易懂的語言撰寫,包含系統性的教學,並提供中級和高級內容,適合有經驗的 VB 開發人員使用。本書的設計目標是全面性,不僅涵蓋一個 Office 應用程式,而是整個 Office 套件。為了增強理解,本書以 Word、Excel、Outlook 和 PowerPoint 等實際專案來探索內容。

由於 Office 應用程式中的技術程式設計方法不斷演進,更新的 2019 年版回顧了程式的變化。自上一版書籍以來的三年間,每個 Office 程式的程式庫、API 和物件模型都有所修改。VBA 內的各種元素已被棄用或替換,使用者介面也有所變化。更新的 2019 年版涵蓋了以下主題:

- 錄製巨集和開始使用 VBA
- 學習如何使用 VBA
- 使用迴圈和函數
- 使用訊息方塊、輸入方塊和對話方塊
- 創建有效的程式碼
- 基於 XML 的檔案、ActiveX、開發人員選項卡、內容控制項、附加元件、嵌入式巨集和安全性

《精通 VBA Microsoft Office 365: 2019 年版》適用於所有層次的 Microsoft Office 365 使用者,解釋了如何自訂和自動化 Office 套件的應用程式。