Microsoft KB Archive/163435

= Programming resources for Visual Basic for Applications =

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.



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:

http://support.microsoft.com/search

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:

http://technet.microsoft.com/default.aspx

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:

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

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:

http://msdn.microsoft.com/office/

Developer Publications at the following Web address:

http://www.microsoft.com/learning/books/

Microsoft Visual Basic Web site at the following Web address:

http://www.msdn.microsoft.com/vbasic/

Microsoft Developer Network online at the following Web address:

http://msdn2.microsoft.com/en-us/default.aspx

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

http://www.microsoft.com/europe/vba/

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.