Читать книгу Excel Macros For Dummies онлайн

14 страница из 60

I make three assumptions about you as the reader:

 You've installed Microsoft Excel.

 You have some familiarity with the basic concepts of data analysis, such as working with tables, aggregating data, creating formulas, referencing cells, filtering, and sorting.

 You have an Internet connection so you can download the sample files.

In addition to the material in the print or e-book you’re reading, this product comes with more online goodies:

 Sample files: Each macro in this book has an associated sample file that enables you to see the macro working and to review the code. You can use the sample files also to copy and paste the code into your environment (as opposed to typing each macro from scratch). Download the sample files at:www.dummies.com/go/excelmacrosfd3eEach macro in this book has detailed instructions on where to copy and paste the code. In general terms, you open the sample file associated with the macro, open the Visual Basic Editor (by pressing Alt+F11), and copy the code. Then open your workbook, open the Visual Basic Editor, and paste the code in the appropriate location. Note that in some macros, you need to change the macro to suit your situation. For example, in the macro that prints all workbooks in a directory (see ssss1), you point to the C:\Temp\ directory. Before using this macro, you must edit it to point to your target directory. If a macro is not working for you, most likely a component of the macro needs to be changed. Pay special attention to range addresses, directory names, and any other hard-coded names.