<p><p><b>New in the second editon:</b></p><ul><li>Covers Excel 2000 to 2003 </li><li>Explains how to access Web Services from Excel programs </li><li>Shows you how to process lists and XML data with Excel 2003 </li></ul><p>Microsoft's Excel is not only a powerful spreadsheet and graphics toolit cont
Definitive Guide to Excel VBA
โ Scribed by Michael Kofler (auth.)
- Publisher
- Apress
- Year
- 2000
- Tongue
- English
- Leaves
- 873
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Table of Contents
Front Matter....Pages i-xiv
Front Matter....Pages 1-1
Writing Your First Macro....Pages 3-42
Whatโs New in Excel 2000....Pages 43-58
Front Matter....Pages 59-59
The Development Environment....Pages 61-78
VBA Concepts....Pages 79-169
Techniques of Programming....Pages 171-339
Debugging, Protection When Errors Arise....Pages 341-355
Forms (Microsoft Forms Library)....Pages 357-426
Menus and Toolbars....Pages 427-459
Front Matter....Pages 461-461
Templates, Smart Forms....Pages 463-492
Charts and Drawing Objects ( Shapes )....Pages 493-530
Data Management in Excel....Pages 531-578
Access to External Data....Pages 579-644
Data Analysis in Excel....Pages 645-686
VBA Programming for Pros, Office Developer....Pages 687-774
Front Matter....Pages 775-775
Object Reference....Pages 777-834
Back Matter....Pages 835-868
โฆ Subjects
Software Engineering/Programming and Operating Systems
๐ SIMILAR VOLUMES
Microsoft's Excel is not only a powerful spreadsheet and graphics tool-it contains a programming language called Visual Basic for Applications (VBA), which allows you to automate simple tasks and enables you to create full-featured applications that make Excel users even more productive. In the Defi
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge
<P style="MARGIN: 0px" align=left text-align="left">โAs Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. <I><B><I>Professional Excel Development </
Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While