The John Green Collection includes Printz Award–winning Looking for Alaska, Printz Honor book An Abundance of Katherines, Edgar Award–winning Paper Towns, and #1 New York Times–bestselling The Fault in Our Stars.

In addition to his many literary accolades, John Green is one half of the Vlogbrothers (youtube.com/vlogbrothers), one of the most popular online video projects in the world. You can join the millions who follow John on Twitter (@realjohngreen) and tumblr (fishingboatproceeds.tumblr.com) or visit him online at johngreenbooks.com.

Quentin Jacobsen has spent a lifetime loving the magnificent Margo Roth Spiegelman from afar. So when she cracks open a window and climbs back into his life—summoning him for an ingenious campaign of revenge—he follows. When their all-nighter ends and a new day breaks, Margo has disappeared. But Q soon learns that there are clues—and they’re for him. Embarking on an exhilarating adventure to find her, the closer Q gets, the less he sees the girl he thought he knew.

#1 Bestselling author of The Fault in Our Stars John Green crafts a brilliantly funny and moving coming-of-age journey about true friendship and true love.

 

Love, friendship, and a dead Austro-Hungarian archduke add up to surprising and heart-changing conclusions in this ingeniously layered comic novel about reinventing oneself.

Hilarious, poignant, and deeply insightful, John Green and David Levithan’s collaborative novel is brimming with a double helping of the heart and humor that have won them both legions of faithful fans.

A New York Times Book Review Editor’s Choice
An ALA Stonewall Honor Book
 
 “Will Grayson, Will Grayson is a complete romp. [It is] so funny, rude and original that by the time flowers hit the stage, even the musical-averse will cheer.” —The New York Times Book Review 
 
★“Will have readers simultaneously laughing, crying and singing at the top of their lungs.”—Kirkus Reviews, starred review 
 
“It is such a good book. [Green and Levithan] are two of the best writers writing today.” —NPR’sThe Roundtable

 

The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.

The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.

The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).

VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment.

Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support.

Based on the successful content and format of Excel 2000 VBA Programmer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community.

What does this book cover?

The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models.

Here are just a few of the things you'll learn in this edition:

Who is this book for?

This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.