Microsoft Excel can help you find solutions to all kinds of financial, scientific, engineering, and management problems. But most Excel users take advantage of only a small portion of Excel's flexibility. Writing Excel Macros explains how to use the customization features in Excel 97 and Excel 2000 to maximize their usefulness, even if you have no programming experience. Anyone with a bit of Excel familiarity will be able to follow this book.
Inside you'll find everything you need to know to write Excel macros. Readers find out, for example, how to make a dialog box appear that will prompt the user for a value and then insert that value into a key spreadsheet cell. Writing Excel Macros maintains its easy-to-follow style even as it gets into the Excel object model, which is how the program makes certain aspects of itself and its data files available for manipulation in macros. There are a lot of sample macros included too, and it's easy to copy them into your own documents (either by hand or by downloading them from the Web). –David Wall
Topics covered: Excel 97 and 2000 macros (and structure), using the Visual Basic Editor (VBE), values, variables, functions, loops, and conditional statements.
USA,Canada, EU and Russia
Download here
Other countries:
Download from easy-share
Download from rapidshare.com