怎么是这样的： Get Code from the Book
| Thank you for buying a copy of VBA & Macros for Microsoft Excel from MrExcel. 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. These samples are from the 1900 version of the Holy Macro! CD. Right-click here to download. 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.
MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations. |
Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc. All contents | 
沪公网安备 31011702000001号 沪ICP备11019229号-2
发表于 2006-4-2 18:20
