VBA and Macros for Microsoft Excel
Download files for VBA and Macros for Microsoft Excel
Thanks for buying VBA and Macros for Microsoft Excel.
As an exclusive benefit to you, I've made all of the code from the book available for download.
Right-click on the following link and choose "Save As" to download a 4MB self-extracting file to your computer. The file includes one Excel file for each chapter. The files contain macro code and sample data so that you can try out the concepts and then view the code. As a bonus, I've also included 6 new pages to discuss program flow, and 25 bonus macro samples.
Thank you again for buying the book.
Note
Chapter 1 of the book talks about four different versions of a file called invoice.txt. Since there is not a good way to include all of those versions, I have pre-loaded invoice.txt into four tabs of the Chapter 1 workbook, and then commented out the one line of code that imports each day's invoice.txt. This will allow you to see the real point of the chapter - that the macro recorder does a lousy job of finding the last row of data.
Mac Users
Several Mac users noted that they can not use the .exe version of the files. You can download the chapter by chapter examples from macvba.zip.