Microsoft Office Excel 2007 Programming: Your visual blueprint for creating interactive spreadsheets [Paperback]

Denise Etheridge (Author)

Book Description

ISBN-10: 0470132302 | ISBN-13: 978-0470132302 | Publication Date: September 11, 2007

Microsoft® Office Excel® 2007 Programming

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:

• Assigning digital signatures to macros

• Setting properties for a project

• Assigning values to a variable

• Changing the properties of an object

• Formatting a numeric expression

• Processing a runtime error

• Saving worksheets to another file

• Displaying a built-in dialog box

• Creating custom Ribbon tabs

• Building and debugging add-ins

Extra Apply It 

• "Apply It" and "Extra" sidebars highlight useful tips

• High-resolution screen shots demonstrate each task

• Succinct explanations walk you through step by step

• Two-page lessons break big topics into bite-sized modules

Editorial Reviews

From the Back Cover

Microsoft® Office Excel® 2007 Programming

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:

• Assigning digital signatures to macros

• Setting properties for a project

• Assigning values to a variable

• Changing the properties of an object

• Formatting a numeric expression

• Processing a runtime error

• Saving worksheets to another file

• Displaying a built-in dialog box

• Creating custom Ribbon tabs

• Building and debugging add-ins

Extra Apply It 

• "Apply It" and "Extra" sidebars highlight useful tips

• High-resolution screen shots demonstrate each task

• Succinct explanations walk you through step by step

• Two-page lessons break big topics into bite-sized modules

About the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books. You can visit www.baycongroup.com to view her online tutorials.

Product Details

• Paperback: 352 pages
• Publisher: Visual (September 11, 2007)
• Language: English
• ISBN-10: 0470132302
• ISBN-13: 978-0470132302
• Product Dimensions: 9.1 x 7.4 x 0.8 inches
• Shipping Weight: 1.5 pounds (View shipping rates and policies)
• Average Customer Review: 3.2 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #482,603 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

4.0 out of 5 stars VB programming within the Excel framework, October 5, 2007

By 

W Boudville (Terra, Sol 3) - See all my reviews
(VINE VOICE)    (TOP 1000 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

This review is from: Microsoft Office Excel 2007 Programming: Your visual blueprint for creating interactive spreadsheets (Paperback)

Excel is really Visual Basic with a powerful, though specialised, user interface. Where the latter is a spreadsheet. Of course, if you are an Excel user, you likely think of it primarily as a spreadsheet. But the lessons in this book show that Excel can be very flexible, if you are willing to write simple VB programs.

The lessons are formatted as 2 pages each. Brief. Examples include being able to access the file system, to delete files. But most of the examples naturally pertain to manipulating objects within a spreadsheet. Like changing properties of an object. Or creating it in the first place. The pedagogy also includes generous numbers of screen captures, for easier uptake.

The only drawback is that the author's format (or rather this series' format) of explaining each lesson in 2 pages means that more advanced functionality is not described.

1 of 1 people found the following review helpful:

3.0 out of 5 stars Foolproof reference. Instructionally poor., December 14, 2009

By 

Henry D. Bissonnette "Culture Hacker Extraord... - See all my reviews
(REAL NAME)   

This review is from: Microsoft Office Excel 2007 Programming: Your visual blueprint for creating interactive spreadsheets (Paperback)

This book is essentially a laundry list of things you can do when programming macros in excel.

If you're trying to write a specific macro and don't know how to make it do something, this book will probably help. You look up a topic (e.g. 'Access the Excel Object Model Reference,'), go to the section, read a couple of paragraphs telling you what the topic is all about, and then go through step-by-step instructions on how to do whatever-it-is (numbered bullets with everything from which ribbons and pull-downs to use, to precise VBA syntax). Each module includes several screen shots with each step indicated by a numbered arrow pointing to the relevant place on one of the shots.

That's all great, and I'm sure that this book will help me when writing macros in the future. What I was looking for however was a book that would teach me to be a better VBA programmer. I wanted to see example code that showed me how to use macros to do new and interesting things. If you just give someone a list of commands and syntax with short descriptions of what they do, they're unlikely to start writing more powerful or elegant code. This book contains no examples to work through or model programs to tinker with. Each topic is a stand-alone module, with, at most, a short snippet of code illustrating the syntax.

If you're looking for an instructional text, this isn't it. If you want a very accessible reference, this is probably a good choice.

1.0 out of 5 stars A poor guide, December 17, 2011

By 

Robert W. Klein - See all my reviews
(REAL NAME)   

This review is from: Microsoft Office Excel 2007 Programming: Your visual blueprint for creating interactive spreadsheets (Paperback)

This book skips over steps within lessons, and passes over lessons within whole processes. For a beginner, a bad introduction; for an advanced person, a dull primer.

Don't waste your money. There are tutorials all over online for basic and intermediate excel usage. For advanced stuff -- there are way better books that this.