Mastering VBA for Microsoft Office 2016 (Paperback)
暫譯: 精通 Microsoft Office 2016 的 VBA

Richard Mansfield

  • 出版商: Sybex
  • 出版日期: 2016-02-23
  • 售價: $1,990
  • 貴賓價: 9.5$1,891
  • 語言: 英文
  • 頁數: 984
  • 裝訂: Paperback
  • ISBN: 1119225388
  • ISBN-13: 9781119225386
  • 相關分類: Excel
  • 已過版

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

相關主題

商品描述

Enhance productivity in any Office application with zero programming experience

Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint.

Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight.

  • Expand Office 2016 functionality with macros
  • Learn how to work with VBA and the entire Office suite
  • Create effective code, even with no programing experience
  • Understand ActiveX, XML-based files, the developer tab, and more

VBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.

商品描述(中文翻譯)

在任何 Office 應用程式中提升生產力,無需程式設計經驗

精通 Microsoft Office 2016 的 VBA 幫助您使用應用程式的視覺基本語言 (VBA) 擴展整個 Office 套件的功能。即使您沒有程式設計經驗,您也能快速使用簡單而強大的 VBA 程式語言自動化日常計算過程。清晰且系統化的教程將初學者引導至基礎知識,而中級和高級內容則指導更有經驗的用戶尋找高效解決方案。本綜合指南從基礎開始,讓您熟悉 VBA,以便您能立即開始錄製巨集。然後,您將在此基礎上進一步利用該語言的全部功能,使用迴圈和函數、訊息框、輸入框和對話框來設計自己的 Office 自動化程式。附加元件、嵌入式巨集、內容控制等提供了增強生產力的高級工具,所有教學均以 Word、Excel、Outlook 和 PowerPoint 的實際專案為依據。

生產力是關鍵,自動化某些計算任務是對任何企業影響深遠的簡單解決方案。本書將逐步指導您如何實現,並提供專家的見解。


  • 使用巨集擴展 Office 2016 的功能

  • 學習如何使用 VBA 和整個 Office 套件

  • 即使沒有程式設計經驗也能創建有效的程式碼

  • 了解 ActiveX、基於 XML 的檔案、開發者選項卡等

VBA 設計上易於理解且對初學者友好,但功能強大到足以創建專門的商業應用程式。如果您準備開始探索可能性,精通 Microsoft Office 2016 的 VBA 將立即幫助您入門。