Microsoft Excel VBA and Macros 配套学习材料

1195

收藏 2020-01-22

下面2个附件分别是 Bill Jelen 和 Tracy Syrstad所著的2本书

Microsoft Excel 2019 VBA and Macros
和

Microsoft Excel 2016 VBA and Macros

的配套学习资料。

Microsoft Excel 2019 VBA and Macros 的配套学习资料：

2019 VBA and Macros Files.zip
大小:(25.47 MB)

只需: 1 个论坛币马上下载

Microsoft Excel 2016 VBA and Macros 的配套学习资料：

2016 VBA and Macros Files.zip
大小:(14.71 MB)

只需: 1 个论坛币马上下载

本附件包括：

ProjectFilesChapter27.xlsm
ProjectFilesChapter25.xlsm
ProjectFilesChapter23.xlsm
ProjectFilesChapter22.xlsm
ProjectFilesChapter20.xlsm
ProjectFilesChapter14.xlsm
ProjectFilesChapter13e.xlsm
ProjectFilesChapter13b.xlsm
ProjectFilesChapter13.xlsm
ProjectFilesChapter10.xlsm
ProjectFilesChapter09.xlsm
ProjectFilesChapter08.xlsm
ProjectFilesChapter07.xlsm
ProjectFilesChapter06.xlsm
ProjectFilesChapter03.xlsm
ProjectFilesChapter24-HandleErrors.xlsm
ProjectFilesChapter21-Access.xlsm
ProjectFilesChapter19-TextFiles.xlsm
ProjectFilesChapter19-LoadToDataModel.xlsm
ProjectFilesChapter18c-ContentMgtSystem.xlsm
ProjectFilesChapter18b-HTMLFileForEachCustomer.xlsm
ProjectFilesChapter18a-FirstWebQuery.xlsm
ProjectFilesChapter17b-SparklinesB.xlsm
ProjectFilesChapter17a-SparklinesA.xlsm
ProjectFilesChapter16-Visualizations.xlsm
ProjectFilesChapter15g-PivChart.xlsm
ProjectFilesChapter15c-ComboChart.xlsm
ProjectFilesChapter15b-FormattingCharts.xlsm
ProjectFilesChapter15a-Chart2013.xlsm
ProjectFilesChapter15-Waterfall.xlsm
ProjectFilesChapter15-FirstChart.xlsm
ProjectFilesChapter12d-AfterDataModel.xlsm
ProjectFilesChapter12c-BeforeDataModel.xlsm
ProjectFilesChapter12c-AfterDataModel.xlsm
ProjectFilesChapter12b-Timeline2.xlsm
ProjectFilesChapter12b-Slicer.xlsm
ProjectFilesChapter12a-PivotTablesVBABook2.xlsm
ProjectFilesChapter12a-PivotTablesVBABook.xlsm
ProjectFilesChapter11-AdvancedFilter.xlsm
ProjectFilesChapter05-R1C1.xlsm
ProjectFilesChapter04-Looping.xlsm
ProjectFilesChapter02-PartsOfSpeech2.xlsm
ProjectFilesChapter02-PartsOfSpeech.xlsm
ProjectFilesChapter01-MacroToImportInvoices.xlsm
ProjectFilesChapter13a.xlsm
ProjectFilesChapter13c.xlsm
ProjectFilesChapter13d.xlsm
ProjectFilesChapter13f.xlsm
ProjectFilesChapter13g.xlsm
Test.docx
24-StoreMap.jpg
Transfers.mdb
vba book cover.jpg
Automating Word.docx
sales.csv.txt
sales.prn
invoice4.txt
invoice3.txt
invoice.txt
invoice1.txt
Professional Memo.docx
SalesPipe.prn
LeftDash.gif
New Client.dotx
sales.txt
sales.csv

请大家根据您所用的Excel的版本选择。
..............................................................................................................
另外，
学习excel VBA ，一般建议的看书顺序（从左向右，入门，提高，最右边的那本是专业程序员的水平）如下：

(中） Excel 2016 (2019) Power Programming with VBA, Michael Alexander and Richard Kusleika .
(右）Professional Excel Development, Rob Bovey, Dennis Wallentin, Stephen Bullen and Hohn Green.