Microsoft KB Archive/163435

From BetaArchive Wiki

Article ID: 163435

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Office 98 for Macintosh
  • Microsoft Office 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft PowerPoint 98 for Macintosh
  • Microsoft PowerPoint 97 Standard Edition
  • Microsoft Access 97 Standard Edition
  • Microsoft Outlook 97 Standard Edition
  • Microsoft Word 98 for Macintosh
  • Microsoft Word 97 Standard Edition



This article was previously published under Q163435

For a Microsoft Office XP version of this article, see 305326.


For a Microsoft Office 2000 version of this article, see 226118.

MORE INFORMATION

Online Help

The Help files included with Microsoft Office are useful for learning the syntax for specific Visual Basic for Applications methods or properties. To display the context-sensitive Help file for a particular Visual Basic command, type the command on a module sheet, and then press F1. This provides the syntax, a description, and an example of how the command is used.

Note If you selected Typical when you installed Office 97, you need to run Setup again to install the Help files associated with Visual Basic for Applications for the programs you will be working with.

For more information about how to install the VBA Help files, click the following article number to view the article in the Microsoft Knowledge Base:

176476 Office Assistant not answering Visual Basic questions


Back to Top

Microsoft Press and Third-Party Reference and Learning Materials

The third-party contact information that is included in this article is provided to help you find the technical support you need. This contact information is subject to change without notice. Microsoft in no way guarantees the accuracy of this third-party contact information.

Microsoft Office

Title: Microsoft Office 97 Visual Basic Step by Step
Author: David Boctor
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-389-7
Pages: 334
Includes: One CD

Title: Microsoft Office 97, Developer Edition, Resource Library
Author: Christine Solomon, Eric Wells, Timothy M. O'Brien, Steven J. Pogge, and Geoffrey E. White
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-606-3
Pages: 1888

Title: Microsoft Office 97 Developer's Handbook
Authors: Christine Solomon
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-440-0
Pages: 608
Includes: One CD
Web Site: http://www.wopr.com/books/solomon97.htm

Title: Microsoft Office 97/Visual Basic Programmer's Guide
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-340-4
Pages: 560

Title: VBA For Dummies, 2nd Edition
Author: Steve Cummings
Date: August 1999
ISBN: 0-7645-0567-X

Title: VBA Developer's Handbook
Author: Ken Getz and Mike Gilbert
Publisher: SYBEX, Inc.
ISBN: 0-7821-1951-4

Title: Teach Yourself Visual Basic for Applications 5 in 21 Days, Third Edition
Author: Matthew Harris
Publisher: SAMS
ISBN: 0-6723-1016-3

Title: Visual Basic for Applications Unleashed
Author: Paul McFedries
Publisher: SAMS
Date: 1997
ISBN: 0-6723-1046-5

Title: Special Edition Using Visual Basic for
Applications 5
Author: Paul Sanna
Publisher: QUE
Date: 1997
ISBN: 0-7897-0959-7

Microsoft Access

Title: Microsoft Access 97 Developer's Handbook
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-358-7
Pages: 624
Disk: One CD

Title: Microsoft Access 97/Visual Basic Step by Step
Author: Evan Callahan
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-319-6
Pages: 416
Includes: One CD

Title: Microsoft Jet Database Engine Programmer's Guide, Second Edition
Publisher: Microsoft Press
Date: December 1995
ISBN: 1-57231-342-0
Pages: 792
Includes: One CD

Title: Access 97 Expert Solutions
Author: Stan Leszynksi
Publisher: QUE
Date: 1997
ISBN: 0-7897-0367-X
Pages: 1200


Title: Access 97 Power Programming
Author: F. Scott Barker
Publisher: QUE
Date: 1997
ISBN: 0-7897-0915-5

Title: Access 97 Macro and VBA Handbook
Author: Susann Novalis
Publisher: SYBEX, Inc.
Date: February 1997
ISBN: 0-7821-1977-8
Web Site: http://www.sybex.com

Title: Access 97 Developer's Handbook
Author: Paul Litwin, Ken Getz and Mike Gilbert
Publisher: SYBEX, Inc.
Date: 1997
ISBN: 0-7821-1941-7
Web Site: http://www.sybex.com

Title: Mastering Access 97
Author: Alan Simpson and Elizabeth Olson
Publisher: SYBEX, Inc.
ISBN: 0-7821-1924-7
Web Site: http://www.sybex.com

Title: Alison Balter's Mastering Access 97 Development, Premier Second Edition
Author: Alison Balter
Publisher: SAMS
Date: 1997
ISBN: 0-672-30999-8

Title: Access 97 Programming For Windows For Dummies
Author: Rob Krumm
Publisher: IDG Books Worldwide, Inc.
Date: March 3, 1997
ISBN: 1-56884-696-7
Web Site: http://www.dummies.com

Microsoft Excel

Title: Excel 97 Programming For Windows For Dummies
Author: John Walkenbach
Publisher: IDG Books Worldwide, Inc.
Date: June 19, 1997
ISBN: 0-7645-0132-1
Web Site: http://www.dummies.com

Title: Special Edition Using Microsoft Excel 97
Author: Ron Person
Publisher: QUE
Includes: An introduction to Visual Basic for Applications

Microsoft PowerPoint

Title: Running Microsoft PowerPoint 97
Author: Stephen Sagman
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-324-2
Pages: 508
Includes: One CD; one chapter on Visual Basic for Applications.

Title: Special Edition Using Microsoft PowerPoint 97
Author: Nancy Stevenson
Publisher: QUE
Date: 1997

Microsoft Word

Title: Microsoft Word 97/Visual Basic Step by Step
Author: Michael Halvorson and Chris Kinata
Publisher: Microsoft Press
Date: April 1997
ISBN: 1-57231-388-9
Pages: 320
Includes: One CD

Title: Special Edition Using Microsoft Word 97
Author: Ron Person
Publisher: QUE

Title: Word 97 Macro and VBA Handbook
Author: Guy Hart-Davis
Publisher: SYBEX, Inc.
Date: April 1997
ISBN: 0-7821-1962-X
Includes: One CD

Microsoft Visual Basic

Title: Microsoft Visual Basic, Deluxe Learning Edition
Publisher: Microsoft Press
Date: March 1997
ISBN: 1-57231-551-2
Pages: 1278

Title: Microsoft Visual Basic 5 Step by Step
Author: Michael Halvorson
Publisher: Microsoft Press
Date: March 1997
ISBN: 1-57231-435-4
Pages: 416
Includes: One CD

Title: Microsoft Visual Basic 5.0 Developer's Workshop, Fourth Edition
Author: John Clark Craig, Webb
Publisher: Microsoft Press
Date: May 1997
ISBN: 1-57231-436-2
Pages: 752
Includes: One CD

Title: Advanced Microsoft Visual Basic 5
Author: The Mandelbrot Set, Ltd.
Publisher: Microsoft Press
Date: 1997
ISBN: 1-57231-414-1
Pages: 832

Title: Microsoft Visual Basic 5.0 Programmer's Guide
Publisher: Microsoft Press
Date: July 1997
ISBN: 1-57231-604-7
Pages: 912

Title: Visual Basic 5 Developer's Guide
Author: Anthony T. Mann
Publisher: SAMS
ISBN: 0-6723-1048-1

Title: Visual Basic 5 Interactive Course
Author: John Harrington, Mark Spenik, Heidi Brumbaugh, Cliff Diamond
Publisher: Waite Group Press
Date: March 1997
ISBN: 1-5716-9077-8

Title: Special Edition Using Visual Basic 5
Author: Mike McKelvy, Ronald Martinsen, Jeff Webb, Bob Reselman
Publisher: QUE
Date: March 1997
ISBN: 0-7897-0922-8

Title: Visual Basic Algorithms
Author: Rod Stephens
Publisher: Wiley Computer Publishing
Web Site: http://www.wiley.com/compbooks/stephens/vba.htm

Back to Top

Microsoft Knowledge Base on the World Wide Web

Many articles in the Knowledge Base contain sample code for common Visual Basic for Applications solutions. The advantage of accessing the articles online is that you can copy the code from your browser and paste it into a module. This saves you the time it would take to manually enter the code.

To access the Microsoft Knowledge Base on the World Wide Web, visit the following Microsoft Web site:

For more information about how to use the Microsoft Knowledge Base, click the following article number to view the article in the Microsoft Knowledge Base:

129725 Obtaining Knowledge Base articles on the World Wide Web


The following articles answer some frequently asked questions and can help you get started in developing your custom solutions in Visual Basic for Applications.

Microsoft Office

159748 How to protect VBA Code from unauthorized access


161923 Troubleshooting variables and data types


161014 How to animate the Office Assistant


161246 Sample code to get input from an Office Assistant balloon


142999 Tips for debugging Visual Basic for Applications code


253235 OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides sample code


Microsoft Access

147816 Using Microsoft Access as an automation server


95608 How to parse comma-separated text into multiple fields


89610 Tips on how to troubleshoot Microsoft Access macros


131583 Sending the current record to Word 97 with automation


Microsoft Excel

146197 How to find technical information about Microsoft Excel


157416 How to assign a macro to an ActiveX worksheet control


156942 How to create an add-in file in Microsoft Excel 97


159619 Sample macros for customizing menus and submenus


161215 How to programmatically create a collection


141691 Visual Basic example using If and Case staments


146055 Using Visual Basic to create a chart using a dynamic range


141762 How to use looping structures in Visual Basic for Applications


143345 Visual Basic macro to determine which button was selected


Microsoft Outlook

170783 Questions about customizing or programming Outlook


166368 Resources for custom forms and programming


160502 Using automation to add appointments to Microsoft Outlook


161012 How to create a new Contact item in Outlook with automation


161088 Using automation to send a Microsoft Outlook message


Microsoft PowerPoint

162102 Introduction to macro programming in PowerPoint 97


162555 How to use the Presentations.Open method


161390 Sample code to display the selection type


162180 Sample code to assign a random animation to all objects


Microsoft Word

161407 VB macro examples to insert text into a document


159547 Retrieving settings from Word dialog boxes using OLE


162490 How to access sample macros for Word 97


146899 Sample macros to scroll to top or bottom of document window


Back to Top

Microsoft TechNet

There is a wealth of valuable information available on the TechNet compact disc. For a good example of the type of information you can find on TechNet, click the hyperlink below to visit the TechNet web site:

TechNet often includes information about Visual Basic for Applications.

Back to Top

Internet Newsgroups

The following peer-to-peer newsgroups are available to help you interact with other users of Visual Basic for Applications:

microsoft.public.access.devtoolkits
microsoft.public.access.formscoding
microsoft.public.access.macros
microsoft.public.access.queries
microsoft.public.excel.programming
microsoft.public.excel.sdk
microsoft.public.officedev
microsoft.public.outlook97.program_forms
microsoft.public.vb.ole.automation
microsoft.public.vb.database.dao
microsoft.public.vb.database.odbc
microsoft.public.vb.database.rdo
microsoft.public.word.vba.addins
microsoft.public.word.vba.beginners
microsoft.public.word.vba.customization
microsoft.public.word.vba.general
microsoft.public.word.vba.userforms


For more information about Microsoft Internet newsgroups, please see the following Microsoft World Wide Web site:

Other Web Resources

The following Web sites are also of interest to Visual Basic for Applications programmers:

Office Development Web site at the following Web address:

Developer Publications at the following Web address:

Microsoft Visual Basic Web site at the following Web address:

Microsoft Developer Network online at the following Web address:

Summit Web site for Microsoft VBA at the following Web address:


Additional query words: 8.00 URL help xlvbainfo kbref ppt97 powerpnt ppt8 OFF97 acc acc97 acc8 access97 access8 excel97 xl xl97 XL98 OFF98 vbwin ol97 ACC98 ACCESS98 PPT98 EXCEL98 WORD98 OutSol OutSol97O utSol98 VBA

Keywords: kb3rdparty kbinfo kbprogramming KB163435