• ▼MSDN Library - April 2000
    • ▶Welcome to the MSDN Library
    • ▶Visual Studio 6.0 Documentation
    • ▶Office Developer Documentation
    • ▶Windows CE Documentation
    • ▶Platform SDK
    • ▶SDK Documentation
    • ▶DDK Documentation
    • ▶Windows Resource Kits
    • ▼Knowledge Base
      • About the Microsoft Knowledge Base
      • ▶ACME Setup Program
      • ▶BackOffice
      • ▶Data Access
      • ▶Exchange
      • ▶Fortran Compiler
      • ▶FoxPro
      • ▶Hardware
      • ▶Internet Explorer
      • ▶Internet Development
      • ▶Macro Assembler
      • ▶Messaging
      • ▶Microsoft Developer Network
      • ▶Microsoft Mastering Series
      • ▶Microsoft Systems Journal
      • ▶NetShow
      • ▼Office
        • ▶Access
        • ▶Access 2000
        • ▶Access Distribution Kit
        • ▶Excel
        • ▶Excel 2000
        • ▶Excel 97
        • ▶Excel 98
        • ▶FrontPage
        • ▶FrontPage 2000
        • ▶FrontPage 98
        • ▶FrontPage Server
        • ▶Microsoft Office 2000 Developer
        • ▶Microsoft Office 98
        • ▶Microsoft Vizact 2000
        • ▶Office
        • ▶Office 2000
        • ▶Office 2000 Web Components
        • ▶Office 97
        • ▶Office Developer
        • ▶Office Server Extensions
        • ▶Outlook
        • ▶Outlook 2000
        • ▶Outlook 98
        • ▶PowerPoint 2000
        • ▶PowerPoint 97
        • ▶VBA articles for Excel 2000
        • ▶VBA articles for Excel 97
        • ▶VBA articles for Excel 98 Macintosh Edition
        • ▼VBA Articles for Office 2000 Products
          • ACC2000: 'Application-defined or object-defined error' Error
          • ACC2000: 'No Current Record' Setting Bookmark to LastModified
          • ACC2000: 'The Other Application Quit' Error with MS Excel 4.0
          • ACC2000: 'Too Few Parameters. Expected 1' Error Message
          • ACC2000: #Error with Aggregate Function on Form Based on ADO RS
          • ACC2000: Access 2000 Does Not Support the UserForm Object
          • ACC2000: Applications Run from Automation Do Not Always Close
          • ACC2000: Can't Access ShortCut Menus CommandBar from Code
          • ACC2000: Can't Use PrtDevMode or PrtMip Property with MDE Files
          • ACC2000: Cannot Set Attributes Property in Visual Basic Code
          • ACC2000: Cannot Use Code to Set the LogMessages Property
          • ACC2000: Compile Error After Converting Form Macros to VBA
          • ACC2000: Connecting to the First Available Network Drive
          • ACC2000: Converting Internet Shortcuts to Hyperlinks in a Table
          • ACC2000: Creating a Parameterized Jet Stored Procedure with DDL
          • ACC2000: Creating an Audit Trail of Record Changes in a Form
          • ACC2000: Creating an Updatable Unbound Word Object on a Report
          • ACC2000: DBEngine.Idle dbRefreshCache Refresh Is Not Immediate
          • ACC2000: Difference Between MaxRecords and TopValues Properties
          • ACC2000: Enumerating Local and Network Printers
          • ACC2000: Example Using a Callback Procedure with Balloons
          • ACC2000: Example Using TreeView Control Drag
          • ACC2000: FindEOM() Sample Function to Find Last Day of Month
          • ACC2000: Finding Minimum/Maximum Value Across Fields of Records
          • ACC2000: Flexible Input Mask for Entering 5- or 9-Digit ZIP Code
          • ACC2000: Form Controls to Increment and Decrement a Date
          • ACC2000: Function to Get Date of Monday Prior to Current Day
          • ACC2000: Function to Remove Alpha Characters from Numeric Field
          • ACC2000: Functions for Calculating
          • ACC2000: How to Automate Changes to Properties of a Graph Axis
          • ACC2000: How to Automatically Detect If a Form Is Being Edited
          • ACC2000: How to Call Excel Functions from Within Access
          • ACC2000: How to Capture Screen Shots of Your Forms
          • ACC2000: How to Change Area Codes Based on Phone Number Prefix
          • ACC2000: How to Change the Colors of a Chart Dynamically
          • ACC2000: How to Change User Passwords Programmatically Using DAO
          • ACC2000: How to Convert API Calls from 16-bit to 32-bit
          • ACC2000: How to Convert Currency or Numbers into English Words
          • ACC2000: How to Convert Julian Days to Dates in Access and Back
          • ACC2000: How to Convert Letters to Numbers in Phone Numbers
          • ACC2000: How to Convert Short Time Format to Different Formats
          • ACC2000: How to Convert Unsigned Integers to Long Integers
          • ACC2000: How to Count Values in Record or Recordset Across Field
          • ACC2000: How to Create a Function That Pauses Program Execution
          • ACC2000: How to Create a Jet CHECK Constraint
          • ACC2000: How to Create a Line That Can Shrink/Grow in a Report
          • ACC2000: How to Create a Table of Contents or Index for a Report
          • ACC2000: How to Create an AfterUndo Form Event
          • ACC2000: How to Create an MS Graph in PowerPoint Using Access
          • ACC2000: How to Create Command Bars by Using Visual Basic Code
          • ACC2000: How to Create Page Totals on a Report
          • ACC2000: How to Create Shortcuts from a Field of Hyperlinks
          • ACC2000: How to Create Your Own Custom Security Reports
          • ACC2000: How to Detect User Idle Time or Inactivity
          • ACC2000: How to Determine If a Form Is Maximized or Minimized
          • ACC2000: How to Determine If Specific Windows Program Is Running
          • ACC2000: How to Determine Startup Folder of a Program
          • ACC2000: How to Determine the Current Screen Resolution
          • ACC2000: How to Determine When a Shelled Process Ends
          • ACC2000: How to Dim Menu Items or Disable Toolbar Buttons in VBA
          • ACC2000: How to Disable or Enable Items on a Custom Command Bar
          • ACC2000: How to Display a Line After Specific Records on Report
          • ACC2000: How to Display Microsoft PowerPoint Slides on a Form
          • ACC2000: How to Dynamically Unlock a Control with a Message Box
          • ACC2000: How to Fax from Access Using SendObject Command
          • ACC2000: How to Fill a Combo Box with Table Names
          • ACC2000: How to Fill Table w/ Random Records from Another Table
          • ACC2000: How to Filter a Report from a Pop-Up Form
          • ACC2000: How to Find the Number of Days in a Month
          • ACC2000: How to Find the Windows and System Paths
          • ACC2000: How to Generate and Print a Report Without Saving It
          • ACC2000: How to Get Fiscal Year or Month of a Particular Date
          • ACC2000: How to Get Red, Green, Blue Components from RGB Value
          • ACC2000: How to Get the Name and Path of the Current Database
          • ACC2000: How to Get the Right and Down Measurements of a Form
          • ACC2000: How to Have List Box Respond to Entire String You Type
          • ACC2000: How to Load OLE Objects from a Folder into a Table
          • ACC2000: How to Loop Through References to View Their Properties
          • ACC2000: How to Make Empty/Null OLE Object Not Appear on Report
          • ACC2000: How to Move List Box Items to Another List Box
          • ACC2000: How to Open a Combo Box Automatically
          • ACC2000: How to Open Multiple Instances of a Form
          • ACC2000: How to Pass an Array as an Argument to a Procedure
          • ACC2000: How to Programmatically Add Controls to a Tab Control
          • ACC2000: How to Programmatically Display a Help File
          • ACC2000: How to Recover a Table Deleted from a Database
          • ACC2000: How to Replace a String with Another String
          • ACC2000: How to Replace the Default Input Mask Error Message
          • ACC2000: How to Round a Number Up or Down by a Desired Increment
          • ACC2000: How to Set Focus to a Subform Control Using a Macro
          • ACC2000: How to Shrink and Grow a Rectangle in a Report
          • ACC2000: How to Skip Used Mailing Labels and Print Duplicates
          • ACC2000: How to Strip Extra Characters from a String
          • ACC2000: How to Strip Specific Characters from a String
          • ACC2000: How to Sum a Column of Numbers in a Report by Page
          • ACC2000: How to Turn Off 'Break on All Errors' Option in Code
          • ACC2000: How to Use a Button to Hide and Display a Subform
          • ACC2000: How to Use Automation to Print Microsoft Access Reports
          • ACC2000: How to Use Automation to Send Microsoft Outlook Message
          • ACC2000: How to Use Collections to Manage Class Objects in VBA
          • ACC2000: How to Use Optional Arguments
          • ACC2000: How to Use Parameters with ActiveX Data Objects and Jet
          • ACC2000: How to Use the Circle Method on a Report
          • ACC2000: How to Use the GetSystemMetrics() API Call
          • ACC2000: How to Use the RefreshDatabaseWindow Method
          • ACC2000: How to Use Visual Basic for Applications to Fill Array
          • ACC2000: Invalid Use of Null or #Error Error in Custom Function
          • ACC2000: No Help in Object Browser for Items Starting with Mso
          • ACC2000: No Prompt to Save Module When Editor Closes
          • ACC2000: Previous/ActiveControl Name Property Not in Auto List
          • ACC2000: Problems w/ Using Instr() to Find Special Characters
          • ACC2000: Sample Code to Check for Table or Query in a Database
          • ACC2000: Sample Function to Create a Running Sum on a Form
          • ACC2000: Sample Function to Determine Current Page of a Form
          • ACC2000: Sample Function to Determine Language Version
          • ACC2000: Sample Function to Format Names Several Different Ways
          • ACC2000: Sample Function to Generate Random Temporary File Name
          • ACC2000: Sample Function to Open a Form to a Particular Record
          • ACC2000: Sample Function to Replace Special Characters in a MDB
          • ACC2000: Sample Function to Return a Random Record from a Field
          • ACC2000: Sample Functions to Check User and Group Information
          • ACC2000: Sending the Current Record to Word 2000 with Automation
          • ACC2000: Sorting Titles Without Leading Articles (The, A, or An)
          • ACC2000: Storing, Calculating, and Comparing Date/Time Data
          • ACC2000: Undo Method Causes IPF When Used Outside Form's Module
          • ACC2000: Unexpected Behavior Referencing Properties of an Object
          • ACC2000: Use NotInList Event to Add a Record to Combo Box
          • ACC2000: Using Automation to Create a Microsoft Excel Chart
          • ACC2000: Using Code to Dynamically Synchronize Two Forms
          • ACC2000: Using Eval Function with Parameters in Parameter Query
          • ACC2000:Can't Use Intrinsic Constants in Queries, Forms, Reports
          • ACC2000:Changing Active Control Background Color with Time Event
          • ACC2000:Determining How Many Instances of Application Are Active
          • ACC2000:Eliminating White Space in Reports with CanShrink
          • ACC2000:Fill Record with Data from Previous Record Automatically
          • ACC2000:How to Automate Importing All Files in a Specific Folder
          • ACC2000:How to Display Image in Form Without Storing It in Table
          • ACC2000:How to Move from Subform to Main Form Using TAB or ENTER
          • ACC2000:Reading, Storing,
          • ACC2000:RecordCount Property Returns Incorrect Number of Records
          • ACC2000:Sample Function to Determine Windows 95/98 or NT Version
          • OFF2000: 'Catastrophic Failure' Error Running Samples.xls Macro
          • OFF2000: Cannot Invoke Install On Demand via VBA
          • OFF2000: CommandBar Indexes Different from Office 97
          • OFF2000: Conversions for C Data Types in VBA
          • OFF2000: Error Or Unexpected Results Using SetFocus Method
          • OFF2000: Error Running Range Property Example
          • OFF2000: Help Topic for Refresh Method Is Incomplete for Chart
          • OFF2000: Invalid Page Fault in FM20.DLL When Showing UserForm
          • OFF2000: Macro for Listing Paper Names Supported by Printer
          • OFF2000: Macro to Get Windows and Windows System Folders
          • OFF2000: MsgBox Function Example Does Not Use vbMsgBoxHelpButton
          • OFF2000: New Behavior with MsgBox Function
          • OFF2000: New Round Function in Visual Basic for Applications 6.0
          • OFF2000: Program Shuts Down After Referencing Document
          • OFF2000: Programming Resources for Visual Basic for Applications
          • OFF2000: Run-Time Error 13 Coercing Euro to Currency Data Type
          • OFF2000: Run-Time Error 3085 Using DAO
          • OFFICESE: How to Count Number of Discussions in Document
          • OFFICESE: How to List Subject of Discussion in Document
          • OL2000: Adding Help Files to an Outlook Custom Form
          • OL2000: AddToPFFavorites Method Can Add Folder to Favorites
          • OL2000: All COM Add-in Run-Time Errors Must Be Trapped
          • OL2000: BeforeCheckNames Event Does Not Fire
          • OL2000: Body Property Limited to 64 KB on Windows 95/98
          • OL2000: Calling a VBA Procedure from VBScript
          • OL2000: Cannot Automate Visual Basic Editor from Outlook
          • OL2000: Click Event Behavior for Standard Controls
          • OL2000: CommandBars Not Available from Application Object
          • OL2000: Common Outlook Object Model Limitations
          • OL2000: Controls Unexpectedly Resize or Move on a Custom Form
          • OL2000: DistListItem Doesn't Prompt to Save When Closed
          • OL2000: Error Referencing Member of CommandBars Collection
          • OL2000: How to Automate Outlook from Another Program
          • OL2000: How to Automatically Close a Form When Calling an Action
          • OL2000: How to Create a Custom Rule Using Visual Basic
          • OL2000: How to Delete Items in a Collection
          • OL2000: How To Handle Unexpected Items in a Collection
          • OL2000: How to Populate a Combo Box with Your Contacts
          • OL2000: How to Populate a List Box or Combo Box
          • OL2000: How to Programmatically Create a Form
          • OL2000: How to Programmatically Determine Online/Offline State
          • OL2000: How to Programmatically Import Items from MS Access
          • OL2000: How to Programmatically Refer to Standard Fields
          • OL2000: How to Programmatically Set a Form's From Field
          • OL2000: How to Programmatically Set TextBox and CheckBox Values
          • OL2000: How to Properly Reference Members of a Collection
          • OL2000: How to Retrieve All Recurring Appointments with Code
          • OL2000: How to Sort a List Box or Combo Box
          • OL2000: How to Start Another Program from an Outlook Form
          • OL2000: How to Use Fields and Controls with VBScript
          • OL2000: Incorrect Count Property Using Recurring Appointments
          • OL2000: Incorrect Start Dates for Shared Recurring Appointments
          • OL2000: Item Created by Automation Doesn't Use Custom Form
          • OL2000: ItemAdd Event Doesn't Fire in Some Scenarios
          • OL2000: Items Collection Doesn't Support Varying Item Types
          • OL2000: MailItem's RemoteStatus Property Doesn't Work
          • OL2000: Managing and Distributing Outlook VBA Projects
          • OL2000: MsgBox, InputBox Titlebars Prefixed with 'VBScript'
          • OL2000: Next and Previous Unavailable Using Code to Display Item
          • OL2000: No Events Fire When Message or Notes Field Changes
          • OL2000: NoteItem.Move Actually Copies Item
          • OL2000: Office E-mail Messages Do Not Have Inspectors
          • OL2000: Office9bug OM: Most SaveAs formats don't save correctly
          • OL2000: Outlook View Control Cannot Access the File System
          • OL2000: Outlook View Control's Restriction Property Doesn't Work
          • OL2000: Outlook Won't Fully Exit Using COM Add-in
          • OL2000: PossibleValues Property Causes Form to Become One-Off
          • OL2000: PossibleValues Property Creates One-Off Form
          • OL2000: Programmatically Accessing Office Form Documents
          • OL2000: Programmatically Created Attachment Loses Icon
          • OL2000: Programmatically-created Item Doesn't Use Custom Form
          • OL2000: Programming Examples for Referencing Items and Folders
          • OL2000: Programming with EntryIDs and StoreIDs
          • OL2000: Published Form with Find Method Displays Macro Warning
          • OL2000: ReadOnly Property Causes One-off Form
          • OL2000: ReplyRecipients Property Is Read/Write, Not Read-only
          • OL2000: ReportItem.Body Returns Empty String
          • OL2000: Restrict May Not Work with Uncached Properties
          • OL2000: SelectionChange Event Fires When Switching Folders
          • OL2000: SetColumns Returns Incorrect Times When Used with Tasks
          • OL2000: Setting Body or HTMLBody Properties Changes Mail Format
          • OL2000: ShowFormPage, HideFormPage No Longer Create One-Off Item
          • OL2000: SyncObject Events Do Not Fire
          • OL2000: Troubleshooting Forms That Don't Run on Other Computers
          • OL2000: Using Address Books in an Outlook Solution
          • OL2000: Using Find and Restrict to Retrieve Items
          • OL2000: Using Outlook Events in Another Program
          • OL2000: Working with Keywords Fields from VBScript
          • OL2000: Working With the Message or Body of an Outlook Item
          • PPT2000: Add-in Rotates 3-D Objects in One-degree Increments
          • PPT2000: Can't paste text into MessageBox or Debug.Print methods
          • PPT2000: Cannot Display Built-in Dialog Boxes Using Object
          • PPT2000: Cannot Set Save Picture Preview Programmatically
          • PPT2000: Code Displays Each Word of Selection in Message Box
          • PPT2000: Code for Moving Objects On Screen During a Slide Show
          • PPT2000: Code to Change 'White Areas' of Graphic to Transparent
          • PPT2000: Code to Count the Placeholders on the Current Slide
          • PPT2000: Code to Detect if PowerPoint is Running on a Macintosh
          • PPT2000: Code to Display the Number of Slides or Shapes
          • PPT2000: CreateObject Does Not Create New PowerPoint Session
          • PPT2000: Creating and Altering a Graph During a Slide Show
          • PPT2000: Error Importing Form Into the Visual Basic Editor
          • PPT2000: Expressions Added to Watch Aren't Saved in
          • PPT2000: F1 Key May Not Start Help When in the Visual Basic
          • PPT2000: For Each Loop Doesn't Find All Shapes on a Slide
          • PPT2000: GoToSlide Method Uses Custom Show Slide Index
          • PPT2000: Graph8 Process Remains in Memory After Macro Ends
          • PPT2000: How to Activate a Media Object From a Macro Button
          • PPT2000: How to Add a Macro to a Toolbar
          • PPT2000: How to Auto Load a PowerPoint Add-In
          • PPT2000: How to Change Shape Properties During Slide Show
          • PPT2000: How to Create a PowerPoint Add-In
          • PPT2000: How to Create Application Level Event Handlers
          • PPT2000: How to Find the Name of an Object
          • PPT2000: How To Manipulate ActiveX Controls Through VBA Macros
          • PPT2000: How to Move Objects During a Slide Show
          • PPT2000: How to Record a Macro using PowerPoint
          • PPT2000: How to Use the AddLine Method
          • PPT2000: How to Use the AddPicture Method
          • PPT2000: How to Use the EntryEffect Property
          • PPT2000: How to use the Presentations.Open Method
          • PPT2000: How To Use the SaveAs Method
          • PPT2000: How to Use the Shell Function to Print a Presentation
          • PPT2000: How to Use the WindowState Property
          • PPT2000: Introduction to Macro Programming in PowerPoint 2000
          • PPT2000: Macro May Stop Running After Slide Show Ends
          • PPT2000: Macro Menus and Visual Basic Editor Require an Open
          • PPT2000: Macro Recorder Does Not Record Closing Slide
          • PPT2000: Macro Recorder Does Not Record Increase or Decreas
          • PPT2000: Macro Recorder Does Not Record Show Command
          • PPT2000: Macro Recorder Does Not Record Undo or Redo Actions
          • PPT2000: Macro Recorder Doesn't Record Activating Placeholder
          • PPT2000: Macro Recorder Doesn't Record Changes to Links Dialog
          • PPT2000: Macro Recorder Doesn't Record Changes to Options
          • PPT2000: Macro Recorder Doesn't Record Code Moving Command Bars
          • PPT2000: Macro Recorder Doesn't Record Find or Replace
          • PPT2000: Macro to Export PowerPoint Slides as Graphics
          • PPT2000: Paste Special Not Available in PowerPoint Object
          • PPT2000: PowerPoint 2000 Remains in Memory After Being Closed
          • PPT2000: Quitting VBE Changes the Active Presentation
          • PPT2000: Run-Time Error When Opening Shortcuts Programmat
          • PPT2000: Run-Time Error When Using the Execute Method
          • PPT2000: Sample Code Displays Message Box With AutoShape Type
          • PPT2000: Sample Code to Add a Media Object to a Running Slide
          • PPT2000: Sample Code To Add the Path and File Name to Each Slide
          • PPT2000: Sample Code to Animate All Graph Objects
          • PPT2000: Sample Code to Assign a Random Animation to all Objects
          • PPT2000: Sample Code to Center a Selection of Objects
          • PPT2000: Sample Code to Change Source of Linked Excel
          • PPT2000: Sample Code to Change the Chart Type of a Graph
          • PPT2000: Sample Code to Change the Language ID of a Text Box
          • PPT2000: Sample Code to Change the Zoom Percentage
          • PPT2000: Sample Code to Control Word from a PowerPoint Macro
          • PPT2000: Sample Code to Copy All Objects to a New Presentation
          • PPT2000: Sample Code to Copy Slide to Different Presentation
          • PPT2000: Sample Code to Copy Slides to Another Presentation
          • PPT2000: Sample Code to Create a Basic Organization Chart
          • PPT2000: Sample Code to Create Backup Presentations
          • PPT2000: Sample Code to Determine the Current View
          • PPT2000: Sample Code to Determine the Number of Open
          • PPT2000: Sample Code to Determine the Windows Display Resolution
          • PPT2000: Sample Code to Display the Selection Type
          • PPT2000: Sample Code to Expand Slides
          • PPT2000: Sample Code to Extract Text from an Organization Chart
          • PPT2000: Sample Code to Find Slides that Don't Follow Slide
          • PPT2000: Sample Code to Get Input From an Office Assistant
          • PPT2000: Sample Code to Get PowerPoint's Build Number
          • PPT2000: Sample Code to List Available Add-Ins
          • PPT2000: Sample Code to Name a Slide
          • PPT2000: Sample Code to Open a Web Site in Internet Explorer
          • PPT2000: Sample Code to Print All Open Presentations
          • PPT2000: Sample Code to Print Slide Numbers for a Custom Show
          • PPT2000: Sample Code to Reset Action Settings
          • PPT2000: Sample Code to Reset the Builds on a Slide
          • PPT2000: Sample Code to Retrieve or Set Slide Size
          • PPT2000: Sample Code to Retrieve the Fonts Used in a
          • PPT2000: Sample Code to Rotate 3D Shapes During a Slide Show
          • PPT2000: Sample Code to Save a PowerPoint Presentation as RTF
          • PPT2000: Sample Code to Save a Presentation in Multiple Formats
          • PPT2000: Sample Code to Update Links in a Graph Datasheet
          • PPT2000: Sample Code to Update Links in an Excel Chart
          • PPT2000: Sample Macro Code To Visit Every Open Slide
          • PPT2000: Sample Macro to Insert a Customized Slide
          • PPT2000: Sample VB Code Adds Multiple New Slides to Presentation
          • PPT2000: Sample VB Code Changes Source of Multiple Linked
          • PPT2000: Sample VB Code That Detects When a Slide Show Ends
          • PPT2000: Sample VB Code that Inserts Title Slide and Title Text
          • PPT2000: Sample VB Code That Uses DAO to Create Presentation
          • PPT2000: Sample VB Code to Check for Open Presentation
          • PPT2000: Sample VB Code to Count Graph 2000 Objects on Current
          • PPT2000: Sample VB Code to Create a Custom Slide Show
          • PPT2000: Sample VB Code to Create a Graph on a Slide
          • PPT2000: Sample VB Code to Create Shape Using FreeForm Tool
          • PPT2000: Sample VB Code to Delete a Custom Slide Show
          • PPT2000: Sample VB Code to Get Selected Text
          • PPT2000: Sample VB Code to Group Objects Together
          • PPT2000: Sample VB Code to Make the Selected Text Bold
          • PPT2000: Sample VB Code to Manipulate Command Bars
          • PPT2000: Sample VB Code to Print Current Slide from Slide Show
          • PPT2000: Sample VB Code to Retrieve Current Slide Number
          • PPT2000: Sample VB Code to Retrieve Summary Properties
          • PPT2000: Sample VB Code to Retrieve the Path to PowerPoint
          • PPT2000: Sample VB Code to Retrieve the Title of a Graph
          • PPT2000: Sample VB Code to Reverse Order of Slides
          • PPT2000: Sample VB Code to Turn Bullets On or Off
          • PPT2000: Sample VBA Code to Create a Graph from a Text File
          • PPT2000: Sample VBA Code to Insert an Image Full Size and Center
          • PPT2000: Sample Visual Basic Code Retrieves Total Number of Cust
          • PPT2000: Sample Visual Basic Code to Insert a Background Image
          • PPT2000: Table Converts to Autoshapes When Scaled Using VBA
          • PPT2000: Tag Name Always Returned As Upper Case String
          • PPT2000: Typing Is Slow When Recording a Macro
          • PPT2000: Unable to Change the ActivePrinter Property With VBA
          • PPT2000: Unable to Reference Renamed and Grouped Objects by Name
          • PPT2000: Using Macros Stored in Templates
          • VBA2000: CharacterWidth Property Returns 9999999
          • WD2000: Return Bookmarks Sorted by Location or Alphabetically
          • WD2000: Sample Macro to Remove a Submenu from a Menu
          • WD2000: 'For Each...Next' Loop Gives Wrong Result with Footnotes
          • WD2000: Acceptable Values of wdLineWidth Constant
          • WD2000: ActiveX Control Copy or Drag Between Applications Fails
          • WD2000: ArtWidth Sets Values in Points But Returns in Twips
          • WD2000: AutoClose Macro Is Executed Before Document Is Closed
          • WD2000: AutoClose Macro Prompts to Save When Document Is Closed
          • WD2000: AutoExit Macro Won't Remove Item Added by AutoExec Macro
          • WD2000: Avoid Save As Alert When Saving to Different File Format
          • WD2000: BreakLink Method Deletes Object Reference
          • WD2000: Can't Assign an Array to a Declared Array Variable
          • WD2000: Cannot Record Macro to Set Options in Customize Dialog
          • WD2000: Code to Determine Whether Open Document Is a Template
          • WD2000: Command to Display the Properties Dialog Box
          • WD2000: Commands on Web Toolbar Cannot Be Recorded in Macro
          • WD2000: Compile Error Message When Passing Function Call
          • WD2000: CPU Usage Increases Using Word as Your E-Mail Editor
          • WD2000: Creating a Password-Style Macro Dialog Text
          • WD2000: DefaultBorderColorIndex Does Not Apply Color to Border
          • WD2000: Determining the Current Page and Section Number
          • WD2000: ErrMsg: 'Cyclic References of Projects Not Allowed'
          • WD2000: Error '5941' Using Border Constants with Font.Borders
          • WD2000: Example Macro to Send E-mail Using MAPI Commands
          • WD2000: FileFind Command Does Not Open Advanced Find Dialog Box
          • WD2000: How to Add Path and File Name to Title Bar of Document
          • WD2000: How to Automate Inserting an Excel Chart into Word
          • WD2000: How to Automatically Update Fields
          • WD2000: How to Call ShellExecute Windows API Function
          • WD2000: How to Change the Default File Name and Directory
          • WD2000: How to Control the Tabbing Order in a Form
          • WD2000: How to Create a Macro to Change Printer or Fax Driver
          • WD2000: How to Create and Display Custom Dialog Box
          • WD2000: How to Create Ordinal (Legal) Dates in Form Fields
          • WD2000: How to Disable CTRL+BREAK Interruption Within a Macro
          • WD2000: How to Force User to Enter Data into a Form Field
          • WD2000: How to Get FormField CheckBox Value
          • WD2000: How to Implement Delay in Visual Basic for Applications
          • WD2000: How to Keep OnEntry Macro from Running at Document Open
          • WD2000: How to Pass a Parameter to a Macro Using Automation
          • WD2000: How to Perform Calculations with Dates and Times
          • WD2000: How to Play a .wav Sound File Using a Macro
          • WD2000: How to Print a Field Result on Last Page of Document
          • WD2000: How to Print a List of AutoCorrect Entries
          • WD2000: How to Programmatically Save Each Page or Section
          • WD2000: How to Quit Windows from Word Using ExitWindows
          • WD2000: How to Rename, Copy, or Delete a Macro
          • WD2000: How to Retain Information Typed into a Form Field
          • WD2000: How to Return Only File Names Using FileSearch Property
          • WD2000: How to Store and Retrieve Variables in Documents
          • WD2000: How to Use (OLE) Automation with Word
          • WD2000: How to Use Built-in (Predefined) Bookmarks
          • WD2000: How to Use the Name...As Statement to Rename Files
          • WD2000: Incorrect Value Returned Using ToolsCalculate Command
          • WD2000: Macro Examples to Calculate Cells Across Multiple Tables
          • WD2000: Macro Programming Resources
          • WD2000: Macro to Cascade Open Document Windows
          • WD2000: Macro to Count Number of Rows in a Table
          • WD2000: Macro to Count Sections in a Document
          • WD2000: Macro to Determine If a File Exists on Disk
          • WD2000: Macro to Determine Whether a Form Field Exists
          • WD2000: Macro to Determine Whether File Is Already Open
          • WD2000: Macro to Dock Toolbars That Are Outside Screen Borders
          • WD2000: Macro to Find Automatic (Soft) Page Breaks
          • WD2000: Macro to Find Tables in Word Documents
          • WD2000: Macro to Generate List of Available Fonts in Word
          • WD2000: Macro to Increment Invoice Number to New Form Document
          • WD2000: Macro to Insert Style Name in Each Paragraph
          • WD2000: Macro to List Custom Tab Stops in a Paragraph
          • WD2000: Macro to Move Insertion Point to Top of Page
          • WD2000: Macro to Place a Border on a Single Cell in a Table
          • WD2000: Macro to Remove a Folder or Directory
          • WD2000: Macro to Replace Font Formatting
          • WD2000: Macro to Retrieve Text from Each Cell in a Table
          • WD2000: Macro to Test for an Existing Macro Name
          • WD2000: Macros Not Listed After Creating New Doc in Explorer
          • WD2000: Macros to Move to Beginning and End of Paragraph
          • WD2000: Object Not a Collection Error in SynonymInfo.MeaningList
          • WD2000: Paragraph.Borders.Count Returns Five on a Paragraph
          • WD2000: Retrieving Settings from Word Dialog Boxes Using OLE
          • WD2000: Returning Object Counts for Parts of a Document
          • WD2000: Run-Time Error '424' Attempting to Ungroup Shape Objects
          • WD2000: Sample Code to Increment Through a Document Line by Line
          • WD2000: Sample Code to Insert Section, Page, and Column Break
          • WD2000: Sample Code to Scroll to Top or Bottom of Window
          • WD2000: Sample Code to Set, Retrieve .ini File or Registry Info
          • WD2000: Sample Macro That Uses a Loop to Find Text
          • WD2000: Sample Macro to Create Popup Toolbar
          • WD2000: Sample Macro to List All Files in a Folder
          • WD2000: Sample Macro to Print All Word Documents Found in Folder
          • WD2000: Sample Macro to Retrieve Page Number
          • WD2000: Sample Macro to Select or Go to a Table Cell
          • WD2000: Sample Macros to Turn True or False Property On or Off
          • WD2000: Sample VBA Code to Delete Built-In Style
          • WD2000: Sample VBA Code to Set, Retrieve Summary Information
          • WD2000: Sample Visual Basic Macro to Type All AutoText Entries
          • WD2000: Shell Command Does Not Wait for Application to Finish
          • WD2000: Simulating Macro Pause in Visual Basic for Applications
          • WD2000: Some Screen Items Update with ScreenUpdating Set to Zero
          • WD2000: StoryRanges Do Not Return Text Box Text in Header/Footer
          • WD2000: Temporary Parameter for Control Does Not Work
          • WD2000: TimeOut Argument Ignored by Some Dialog Boxes
          • WD2000: Use TextBox Control to Avoid 255-Character Limit
          • WD2000: Using the ASCII and ANSI Characters in Word for Windows
          • WD2000: Using the Open Statement in Word VBA
          • WD2000: VBA Code to Select or Clear Check Box in Dialog Box
          • WD2000: VBA Code to Switch a Document to Two-Page View
          • WD2000: VBA Command to Display Version Number of Word
          • WD2000: VBA Function to Check If File or Document Is Open
          • WD2000: VBA Macro Examples to Insert Text into a Document
          • WD2000: VBA Routines to Determine If Line or Document Is Empty
          • WD2000: VBA: How to Count the Occurrences of a Word or Phrase
          • WD2000: Visual Basic Example to Print Current Page
          • WD2000: wdParagraph, ColumnSelectMode Doesn't Select Text Column
          • XL2000: '255 Characters in Cell' Error When Copying Worksheet
          • XL2000: 'ActiveX component can't create object' Error w/ DAO 3.0
          • XL2000: 'Bad DLL Calling Convention' When Running a Macro
          • XL2000: 'Can't Execute Code in Break Mode' When Running Macro
          • XL2000: 'Can't Find Project or Library' When You Run a Macro
          • XL2000: 'Cannot jump to 'Application' because it is hidden.'
          • XL2000: 'Compile Error' Running Macro That Changes Margins
          • XL2000: 'Not Enough Memory' Opening Workbook with a Chart
          • XL2000: 'Out of memory' Error Running Sub Procedure
          • XL2000: 'PasteSpecial method of Range class failed' Error
          • XL2000: 'Subscript out of range' Error Saving as Web Page
          • XL2000: 'Subscript Out of Range' Using H or VPageBreaks.Location
          • XL2000: 'Type Mismatch' Comparing String Variable to Boolean
          • XL2000: All PageSetup Settings Are Recorded into Macro
          • XL2000: Application.SendKeys Does Not Wait for Key Processing
          • XL2000: Auto List Does Not List CommandText for PivotTable
          • XL2000: Auto_Close Macros Run When You Use Application.Quit
          • XL2000: Can't Tile Windows with Macro If a Window Is Minimized
          • XL2000: Can't Use PrintOut Method With Custom Dialog Box Visible
          • XL2000: Cannot Add Macros to the Tools Menu
          • XL2000: Cannot Import/Export UserForms Between VBA and VB
          • XL2000: Cannot Make Changes to Some Shortcut Menus
          • XL2000: Cannot Move or Copy Sheet After Last Sheet
          • XL2000: Cannot Open Add-In Error When Running a Macro
          • XL2000: Cannot Paste Array Formula in Its Original Cell
          • XL2000: Cannot Programmatically Close Referenced Workbook
          • XL2000: Cannot Use Page Setup Property If No Printers Installed
          • XL2000: Code 'Behind' Worksheet or Workbook May Not Work
          • XL2000: Color Palette Looks Different in Microsoft Excel 2000
          • XL2000: Compile Error Passing ParamArray
          • XL2000: Contents of the Samples.xls Workbook
          • XL2000: Copying from Object Browser May Not Copy Named Arguments
          • XL2000: Crash Running Macro When Object Set to Nothing
          • XL2000: CreateObject and GetObject Work Differently
          • XL2000: Custom Function Returns #VALUE! After Running Macro
          • XL2000: Cut and Paste in Visual Basic Procedure Hangs Excel
          • XL2000: DataType Property Returns xlNumber in OLAP PivotTables
          • XL2000: Date Returned in a Macro Is Four Years Too Early
          • XL2000: Defined Names Are Case Sensitive
          • XL2000: Deleting a Cell Changes the UsedRange Property
          • XL2000: Deleting Cells with a For Each...Next Loop
          • XL2000: Drawing Objects Behave Differently When Clicked
          • XL2000: Error Adding or Deleting a Menu Command in a Macro
          • XL2000: Error Applying Comment When Worksheets Are Grouped
          • XL2000: Error Changing Order of Option Buttons on a Dialog Sheet
          • XL2000: Error Deleting a Data Series From a PivotChart
          • XL2000: Error Getting the Value of a Name in Visual Basic
          • XL2000: Error Using ADODB Object Library
          • XL2000: Error When Function Contains a Breakpoint
          • XL2000: Error When Invalid Characters in Drawing Object Name
          • XL2000: Error When Passing an Array Value Between Macros
          • XL2000: Excel Hangs When You Programmatically Save a Workbook
          • XL2000: Format Function May Return an Incorrect Date
          • XL2000: How to Add the Workbook Path to the Footer
          • XL2000: How to Assign a Macro to an ActiveX Worksheet Control
          • XL2000: How to Check Spelling for Worksheet Objects Only
          • XL2000: How to Continue a VB Statement from One Line to the Next
          • XL2000: How to Control the AutoFilter with a Macro
          • XL2000: How to Create a Macro That Counts Comments
          • XL2000: How to Create a Macro That Opens Multiple Selected Files
          • XL2000: How to Create and Use a Workbook_BeforeClose Procedure
          • XL2000: How to Create Application-Level Event Handlers
          • XL2000: How to Create PivotTable from Word
          • XL2000: How to Create Yes and No Buttons for a Custom Message Bo
          • XL2000: How to Display Top 10 Records with a Macro
          • XL2000: How to Display UserForm Whose Name Is in Variable
          • XL2000: How to Force Macro Code to Wait for Outside Procedure
          • XL2000: How to Hide Sheets and Use xlVeryHidden Constant
          • XL2000: How to Programmatically Save a File to a Network Drive
          • XL2000: How to Run a Macro When Certain Cells Change
          • XL2000: How to Select Cells/Ranges Using Visual Basic Procedures
          • XL2000: How to Select Ranges Using VB for Apps (Novice Examples)
          • XL2000: How to Use a Custom Function in Another Workbook
          • XL2000: How to use a Macro to Enter Cell Note Text in a Text Box
          • XL2000: How to Use an Excel Database to Send E-Mail
          • XL2000: How to Use Dynamic Arrays in a Macro
          • XL2000: How to Use Input Boxes in Visual Basic for Applications
          • XL2000: How to Use the TextColumn Property
          • XL2000: Incorrect Classic PivotTable Constant Recorded in Macro
          • XL2000: Indexes for Methods and Collections Are Rounded
          • XL2000: Input # Statement Does Not Retain Trailing Spaces
          • XL2000: Insert and Delete Methods of Characters Class May Fail
          • XL2000: Inserting and Formatting Text in Headers and Footers
          • XL2000: Invalid Page Fault When Macro Closes Its Own Workbook
          • XL2000: Len Function Returns Only 1024 Characters in Cell
          • XL2000: Limitations for Naming Visual Basic Modules
          • XL2000: List of ID Numbers for Built-In CommandBar Controls
          • XL2000: Macro Cannot Scroll Chart Sheet
          • XL2000: Macro Examples to Delete Duplicate Items in a List
          • XL2000: Macro Fails to Apply Diagonal Cell Borders
          • XL2000: Macro Stops Running When Its Workbook Is Closed
          • XL2000: Macro to Change File Type to '(*.*)' in Open Dialog Box
          • XL2000: Macro to Change the Date/Time Format in a Header/Footer
          • XL2000: Macro to Delete Every Other Row
          • XL2000: Macro to Extract Data from a Chart
          • XL2000: Macro to Open All Linked Workbooks
          • XL2000: Macro to Search for Cell Formats: Font, Border, Interior
          • XL2000: Macro to Shade Every Other Row in a Selection
          • XL2000: Menu Added in Wrong Position on Menu Bar
          • XL2000: Menu Editor and Make Add-In Dialog Boxes Cause Error
          • XL2000: Modules.Count Method Always Returns Zero
          • XL2000: Named Argument Not Found Error with DAO
          • XL2000: No 'Record at Mark' Feature in Microsoft Excel
          • XL2000: No Automatic Type Coercion Between Variable Types
          • XL2000: No Data Validation Property for UserForm TextBoxes
          • XL2000: Overflow Error Occurs When Using Err Object
          • XL2000: Page Setup Command Does Not Exist in Modules
          • XL2000: ParamArray Must Be Declared as an Array of Variant
          • XL2000: ParamArrays Are Always Zero-Based
          • XL2000: Parentheses Around Object May Dereference the Object
          • XL2000: Passed Strings Longer Than 255 Characters Are Truncated
          • XL2000: Pointer Is an Hourglass When You Display a Message Box
          • XL2000: Private Functions Are Available to Worksheet
          • XL2000: Problems Disabling and Enabling Shortcut Menus
          • XL2000: Problems Using Code to Display ChartWizard on PivotTable
          • XL2000: Problems When Removing Line from Drawing Object
          • XL2000: Problems When You Use Macro to Add Control to UserForm
          • XL2000: Prompt to Save Changed Workbook Fails to Appear
          • XL2000: Prompted to Save Changes Although Saved Property Is True
          • XL2000: Range.PasteSpecial Changes Selection
          • XL2000: Recorded Macro Contains DrawingObjects Method
          • XL2000: Redraw Problem Changing Visibility of Object on Dialog B
          • XL2000: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened
          • XL2000: Run-time Error '1004' Accessing Locally Defined Name
          • XL2000: Run-Time Error Using FormulaArray Property
          • XL2000: Runtime Error 424 Clicking Cancel on InputBox
          • XL2000: Sample Macro Code to Change Case of Text
          • XL2000: Sample Macro Code to Loop Through a List on a Worksheet
          • XL2000: Sample Macro That Won't Allow User to Cancel Dialog Box
          • XL2000: Sample Macro to Add or Place Object in Relation to Range
          • XL2000: Sample Macro to Insert/Delete Rows on Multiple Sheets
          • XL2000: Sample Macro to Remove User Name from Comment
          • XL2000: Sample Macro to Sort List Based on Custom Sort Order
          • XL2000: Sample Macros for Customizing Menus and Submenus
          • XL2000: Sample Macros to Return ID for a CommandBar Control
          • XL2000: Sample Visual Basic Code to Create Color Index Table
          • XL2000: Select Method May Select More Cells Than Expected
          • XL2000: SendKeys Slower When Compared to MS Excel 7.0
          • XL2000: SetFocus Property on TextBox Does Not Work as Expected
          • XL2000: Showing Quotation Marks in Function Results and Macros
          • XL2000: Some Properties and Methods Missing in Object Browser
          • XL2000: Status Bar Text Not Displayed When You Point to Toolbar
          • XL2000: Structure and Windows Arguments of Protect Method
          • XL2000: Styles('X').Parent Different Than in Earlier Versions
          • XL2000: Text Property Limited to 1,024 Characters
          • XL2000: TextColumn Property Displays Only the First Column
          • XL2000: Unable to Show UserForms in Other Projects
          • XL2000: Unlocked Cells Not Underlined with Protection Enabled
          • XL2000: UserForm Allows Interactivity When ShowModal Is True
          • XL2000: UserForm Does Not Allow Interactivity with Workbook
          • XL2000: Using 'Checked', 'Gray', and 'Unchecked' in Macros
          • XL2000: Using Saved Property to Determine If Workbook Changed
          • XL2000: Using the SheetChange Event in Microsoft Excel
          • XL2000: VBA Macro Behavior Is Different from Excel 5.0 or 7.0
          • XL2000: Visible Property Does Not Apply to All CommandBars
          • XL2000: Visual Basic Example to Retrieve Value from Last Cell
          • XL2000: Visual Basic Example Using If and Case Statements
          • XL2000: Visual Basic Examples Using DDE
          • XL2000: Worksheet_Change Does Not Run When Worksheet Sorted
          • XL2000: XL Object Browser Missing Asterisks That Denote Defaults
        • ▶Word
        • ▶Word 2000
        • ▶Word 97 for Windows
      • ▶OLE
      • ▶Visual Basic
      • ▶Visual Database Tools
      • ▶Visual C++
      • ▶Visual InterDev
      • ▶Visual J++ and Java Language
      • ▶Visual SourceSafe
      • ▶Visual Studio
      • ▶Windows
      • ▶Windows Development
      • ▶Miscellaneous
    • ▶Technical Articles
    • ▶Backgrounders
    • ▶Specifications
    • ▶Books
    • ▶Partial Books
    • ▶Periodicals
    • ▶Samples