本书《VBA Automation for Excel 2019 Cookbook》由Mike Van Niekerk撰写，旨在教你如何通过VBA自动化Excel和其他MS Office应用，提升工作效率。代码示例可在GitHub上获取，书中强调了事件代码应存储在工作簿对象中，而非模块对象，并介绍了公共和私有过程、行续接符的使用、变量声明等关键概念。
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.47元/天 解锁文章
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
