VBA Automation for Excel 2019 Cookbook by Mike Van Niekerk

本书《VBA Automation for Excel 2019 Cookbook》由Mike Van Niekerk撰写,旨在教你如何通过VBA自动化Excel和其他MS Office应用,提升工作效率。代码示例可在GitHub上获取,书中强调了事件代码应存储在工作簿对象中,而非模块对象,并介绍了公共和私有过程、行续接符的使用、变量声明等关键概念。
摘要由CSDN通过智能技术生成

VBA Automation for Excel 2019 Cookbook

Solutions to automate tasks and increase productivity with Excel and other MS Office applications

By Mike Van Niekerk

The code bundle for the book is also hosted on GitHub at https://github.com/PacktPublishing/VBA-Automation-for-Excel-2019-Cookbook. In case there’s an update to the code, it will be updated on the existing GitHub repository.

https://static.packt-cdn.com/downloads/9781789610031_ColorImages.pdf


The first thing to remember about events is that the code is not stored in a module object, but in the workbook object. Place the code anywhere else and it will simply not work.


A

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Microsoft Excel 2019 VBA and Macros (Business Skills) By 作者: Bill Jelen – Tracy Syrstad ISBN-10 书号: 1509306110 ISBN-13 书号: 9781509306114 Edition 版本: 1 出版日期: 2019-01-07 pages 页数: (1580) Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值