Skip to Content
Special Edition Using® Microsoft® Office 2003
book

Special Edition Using® Microsoft® Office 2003

by Ed Bott, Woody Leonhard
September 2003
Beginner to intermediate content levelBeginner to intermediate
1368 pages
56h 14m
English
Que
Content preview from Special Edition Using® Microsoft® Office 2003
1197
Code Snippets You Can Use
The .Format = True setting in the Find loop in Listing 44.6 ensures that Word looks for
paragraphs with the specified formatting.
Using VBA to Loop Through Collections
VBA abounds with collections. All the files currently open in an application, for example,
define one common collection. Other collections include all the bookmarks in a document,
or all the named ranges in a workbook.
Sometimes you know exactly which member of a collection you’re trying to find. For exam-
ple, the VBA/Excel command
Workbooks(“Book1.xls”).Activate
scans the Workbooks collection, and brings up the workbook called Book1.xls.
At other times, however ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Special Edition Using Microsoft® Office XP

Special Edition Using Microsoft® Office XP

Ed Bott, Woody Leonhard
Special Edition Using Microsoft® PowerPoint® 2002

Special Edition Using Microsoft® PowerPoint® 2002

Patrice-Anne Rutledge, Tom Mucciolo

Publisher Resources

ISBN: 0789729555Purchase Link