下面2个附件分别是 Bill Jelen 和 Tracy Syrstad所著的2本书
Microsoft Excel
2019 VBA and Macros
和
Microsoft Excel
2016 VBA and Macros
的配套学习资料。
Microsoft Excel 2019 VBA and Macros 的配套学习资料:
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.