'Built-in Constants in Visual Basic for Applications' (WC0993)

'Can't Assign Array...' Passing Argument to Subroutine

'Cannot Find VBAEN.OLB' Creating New Macro or Module Sheet

'Invalid Data Format' Referencing File that Contains Procedure

'Method not Applicable....' When Referring to Excel Objects

'OLE Automation Run-time Error 440' When Displaying Time

{CLEAR} Keystroke Is Supported Using SendKeys Command

ACC: 'Could Not Find Object' Error Importing MS Excel File

ACC: 'Expected Function or Variable' Error Message

ACC: 'Expected: =' Error When ? Is Missing in Debug Window

ACC: 'Invalid Use of Null' or '#Error' Err in Custom Function

ACC: 'Object invalid or no longer set' Error Using CurrentDb

ACC: 'Syntax Error in String' Error Using DDE() and DDESend()

ACC: 'Too Many Fields Defined' Error Message Saving Table

ACC: #Num Appears in Linked Microsoft Excel Spreadsheet

ACC: Adding '(all)' to a Combo Box or List Box Control

ACC: Assigned Values Not Displayed When Form Opened As Dialog

ACC: Automation Does Not Close Microsoft Excel

ACC: Automation Object Disappears When Code Finishes Executing

ACC: Automation to Create and Manipulate an Excel Workbook

ACC: Bound Multi-Selection List Box Always Returns Null

ACC: Canceling a DoCmd Print Returns Error Messages

ACC: Cannot Change RecordsetType Property in Form View

ACC: Cannot Check to See If Database Was Opened Exclusively

ACC: Cannot Close Form from Control's OnExit Property

ACC: Cannot Connect DDE from MS Word to Microsoft Access

ACC: Cannot Open Recordset on SQL Server Inside Transaction

ACC: Cannot Perform OpenTable Method on Linked/Attached Table

ACC: Cannot Set LogMessages Property Using Code

ACC: Cannot Use Counter to Determine If Record Is New Record

ACC: Cannot Use Intrinsic Constants in Queries, Forms, Reports

ACC: Change Active Control Background Color with Timer Event

ACC: Change Border Properties for Chart Using OLE Automation

ACC: Changing Application Title Using Visual Basic (95/97)

ACC: Changing Column Headings in a Crosstab Query Using Code

ACC: Compile Error After Converting Form Macros to VBA

ACC: Conditionally Run AutoExec Macro in Automation Database

ACC: Connecting to the First Available Network Drive (95/97)

ACC: Conversions for C Data Types in Visual and Access Basic

ACC: Converting Julian Dates with Visual or Access Basic Code

ACC: Converting Macros to MS Visual Basic for Applications

ACC: Converting Unsigned Integers to Long Integers

ACC: CreateControl Creates Empty Container for OLE Controls

ACC: CreateControl() and CreateReportControl() Functions

ACC: Creating a Snapshot Is Slower Than Creating a Dynaset

ACC: Creating Functions Similar to DFirst and DLast (95/97)

ACC: Data Type of Value Overrides Data Type of Variable

ACC: Database Grows Rapidly When You Modify SQL Statements

ACC: DateAdd() 'w' Interval Does Not Work as Expected

ACC: DateDiff() Function's 'W' Option Does Not Work

ACC: DeleteControl, DeleteReportControl, and CreateGroupLevel

ACC: Determining How Many Instances of Application Are Active

ACC: Do Not Jump into WITH Statement Blocks

ACC: Dynamically Synchronizing Two Forms using Code (95/97)

ACC: Eliminating White Space in Reports with CanShrink

ACC: Enumerating Local and Network Printers

ACC: Err Msg 'The Other Application Quit' with MS Excel 4.0

ACC: Error Message 'Method or Data Member not Found'

ACC: Errors Concatenating Variables or Controls (2.0/7.0/97)

ACC: Explanation of 'Option Compare Database' Statement

ACC: Exporting Right-Aligned Fields to a Text File (95/97)

ACC: Field Object Type Property Returns 'Invalid Operation'

ACC: Fill Record w/Data from Prev. Record Automatically (95/97)

ACC: FindEOM() Sample Function to Find Last Day of Month

ACC: Finding a Bookmark in a Word 97 Document Using Automation

ACC: Finding a Location in a Word Document Using Automation

ACC: Form and Report Modules Are Public by Default (95/97)

ACC: Form Is Editable Even When AllowEdits Property Set to False

ACC: Form Is Inaccessible When Debugging Run-Time Error

ACC: Form Name Err Msg Using Data Outline Control (95/97)

ACC: Function to Get Date of Monday Prior to Current Day

ACC: Functions for Calculating and Displaying Date/Time Values

ACC: Global Variable Limitations - Exceeds 64K Segment

ACC: Hourglass May Not Change After Illegal Function Call

ACC: How to Add a User to a Group with CreateUser Method

ACC: How to Add Appointments to Schedule+ using Automation

ACC: How to Alter Field's Data Type at Run Time Using Code

ACC: How to Automate Changes to Properties of a Graph Axis

ACC: How to Automate Importing All Files in a Specific Folder

ACC: How to Automatically Detect If a Form Is Being Edited

ACC: How to Avoid Abandoned Group Headers in Reports

ACC: How to Base a Report on a Recordset Object

ACC: How to Calculate a Credit Card Expiration Date

ACC: How to Calculate Averages Excluding Zero Values

ACC: How to Call Functions from Microsoft Excel

ACC: How to Call Functions Using a String Variable

ACC: How to Capture Screens of Your Forms (95/97)

ACC: How to Change a Graph Chart Type Using OLE Automation

ACC: How to Change Area Codes Based on Telephone Number Prefix

ACC: How to Change the Owner of a New Table

ACC: How to Change User Passwords Programmatically Using DAO

ACC: How to Compact Databases at a Scheduled Time

ACC: How to Compute Moving Averages in Visual or Access Basic

ACC: How to Concatenate a List of Items from a Many-Side Table

ACC: How to Convert API Calls from 16-bit to 32-bit

ACC: How to Convert Between Julian Days and Dates

ACC: How to Convert Currency or Numbers into English Words

ACC: How to Convert Letters to Numbers in Phone Numbers

ACC: How to Convert Short Time Format to Different Formats

ACC: How to Convert Twips to Pixels

ACC: How to Count Values in Record or Recordset Across Fields

ACC: How to Create a Collection of Collections

ACC: How to Create a Custom Database Version Using DAO

ACC: How to Create a Customized 'Attach ODBC Table' Form

ACC: How to Create a Dot Leader Between Fields

ACC: How to Create a Function That Pauses Program Execution

ACC: How to Create a MS Office Binder Using Automation

ACC: How to Create a Multiuser Custom Counter (95/97)

ACC: How to Create a Parameter In() Statement

ACC: How to Create a Password Protected Form or Report

ACC: How to Create a PowerPoint Presentation Using Automation

ACC: How to Create a Schema.ini File Programmatically

ACC: How to Create a Stopwatch Form (95/97)

ACC: How to Create a Table of Contents or Index for a Report

ACC: How to Create a Top N Values per Group Query

ACC: How to Create a Version 2.0 Database Using Access 95/97

ACC: How to Create a Word 97 Merge Document Using Automation

ACC: How to Create an AfterUndo Form Event

ACC: How to Create an SQL Pass-Through Query in Code

ACC: How to Create Floating Pop-Up Menus (95/97)

ACC: How to Create Pop-up Context-Sensitive Help (95/97)

ACC: How to Create Tasks in MS Project for Windows Using DDE

ACC: How to Cycle Through the Controls on a Form Using Code

ACC: How to Delete Items from Combo/List Box After Selection

ACC: How to Delete Multiple Tables Quickly (2.0, 95, 97)

ACC: How to Delete Table Set in RecordSource When Form Closes

ACC: How to Detect User Idle Time or Inactivity

ACC: How to Determine If a Database Is Open Exclusively

ACC: How to Determine If a Date Falls on a Weekend or Holiday

ACC: How to Determine If a Form Exists in a Database

ACC: How to Determine If a Form Is Maximized or Minimized

ACC: How to Determine If a Specific Windows Program Is Running

ACC: How to Determine If a Table or Query Exists

ACC: How to Determine Number of Working Days Between Two Dates

ACC: How to Determine Startup Folder (Directory) of a Program

ACC: How to Determine the Current Screen Resolution (95/97)

ACC: How to Determine When a Shelled Process Ends

ACC: How to Dial a Phone Number Using MS Access 95/97

ACC: How to Display Image in Form Without Storing It in Table

ACC: How to Display Line Numbers on Subform Records

ACC: How to Display Microsoft PowerPoint Slides on a Form

ACC: How to Dynamically Unlock a Control with a Message Box

ACC: How to Embed a Bitmap Object in a Report at Run Time

ACC: How to Explore an Internet Site from MS Access 2.0 or 95

ACC: How to Export All Modules in a Database to Text Files

ACC: How to Fax from Microsoft Access Using SendObject Command

ACC: How to Fill a Combo Box with Table Names

ACC: How to Fill a List Box with Database Object Names

ACC: How to Fill a Multiple-Column List Box Using Code

ACC: How to Fill an Array Using Visual or Access Basic

ACC: How to Fill Text Boxes on a Report Using Visual Basic

ACC: How to Find a Record Using a Bound Control (95/97)

ACC: How to Find If an Object Exists in a Database

ACC: How to Find Out If Replica Is the Design Master

ACC: How to Find the Number of Days in a Month

ACC: How to Find the Windows and System Paths (95/97)

ACC: How to Flag Out-of-Sequence Numbers on a Report

ACC: How to Float MS Access Windows On Top of Other Windows

ACC: How to Format Dates Regardless of Regional Settings

ACC: How to Format Fax Numbers to Merge with Microsoft Word

ACC: How to Format Phone Number Fields Using an Update Query

ACC: How to Get Form's Right and Down Measurements (95/97)

ACC: How to Get Red, Green, or Blue Components from RGB Value

ACC: How to Get the Fiscal Year/Month of a Particular Date

ACC: How to Get the Name and Path of the Current Database

ACC: How to Hide Duplicate Group Header Information on Report

ACC: How to Import a Data File to a Control on a Form

ACC: How to Import a Microsoft Windows Cardfile Data File

ACC: How to Import Several dBASE Databases at Once 95/97

ACC: How to Index an Existing Field with DAO (95/97)

ACC: How to Limit Number of Characters to Size of Text Box

ACC: How to List SQL Server Objects Using Automation

ACC: How to Load OLE Objects from a Folder into a Table

ACC: How to Make Empty or Null OLE Object Not Appear on Report

ACC: How to Minimize, Maximize, and Restore MS Access 95/97

ACC: How to Move from Subform to Main Form Using TAB or ENTER

ACC: How to Move List Box Items to Another List Box (7.0/97)

ACC: How to Negate CTRL+ENTER in a Text Box or Memo Control

ACC: How to Open and Close Word Documents with OLE Automation

ACC: How to Open Multiple Instances of a Form

ACC: How to Pad Character Strings on Left and Right Side

ACC: How to Parse Comma-Separated Text into Multiple Fields

ACC: How to Pass an Array as an Argument to a Procedure

ACC: How to Place the User Login Name on Form or in Title Bar

ACC: How to Position Microsoft Access on the Screen (95/97)

ACC: How to Prevent Users from Creating New Databases

ACC: How to Print a Constant Number of Lines Per Group

ACC: How to Print Labels Only on the Left Margin of a Report

ACC: How to Print RecordSource Property Value for All Reports

ACC: How to Programmatically Change a Control Type

ACC: How to Record and Play Sounds from MS Access (95/97)

ACC: How to Recover a Table Deleted from a Database

ACC: How to Reference Classes That Exist in Multiple Libraries

ACC: How to Relink Back-End Tables with Common Dialog Control

ACC: How to Remove Excess Characters from Contents of a String

ACC: How to Replace a String with Another String

ACC: How to Replace the Default Input Mask Error Message

ACC: How to Retrieve Information from the Clipboard (95/97)

ACC: How to Retrieve Path or File Name from the Name Property

ACC: How to Retrieve the MS Access Window Handle

ACC: How to Retrieve Workgroup Information Under Win32

ACC: How to Return an UNC Path from an Existing Drive Letter

ACC: How to Rotate a 3-Dimensional Chart Using Automation

ACC: How to Run Schedule+ from MS Access Using Automation

ACC: How to Run Visual or Access Basic Functions with DDE

ACC: How to Save a Copy of an Embedded MS Word Document

ACC: How to Send Information to the Clipboard (95/97)

ACC: How to Set a Keystroke+Click to Activate a Command Button

ACC: How to Set AllowZeroLength Property to Yes in All Tables

ACC: How to Set Focus and Close Instances of Report Objects

ACC: How to Set Graph Trend Lines Using Automation

ACC: How to Set Subreport's RecordSource Property at Run Time

ACC: How to Shade Every Other Detail Line on Reports

ACC: How to Shrink and Grow a Rectangle in a Report

ACC: How to Simulate Parameters in an SQL Pass-Through Query

ACC: How to Skip Used Mailing Labels and Print Duplicates

ACC: How to Sort Records in Case-Sensitive ( ASCII) Order

ACC: How to Specify a Custom Starting Page Number for a Report

ACC: How to Strip Specific Characters from a String

ACC: How to Sum a Column of Numbers in a Report by Page

ACC: How to Test a User-Defined Filter in Filter By Form

ACC: How to Trap Keystrokes That Leave a Control on a Form

ACC: How to Turn Off 'Break on All Errors' Option in Code

ACC: How to Use a Function to Quit Windows

ACC: How to Use a Microsoft Access Macro to Quit Windows

ACC: How to Use a Multi-Select List Box to Filter a Form

ACC: How to Use a Toggle Button to Hide and Display a Subform

ACC: How to Use Automation to Fill a List Box

ACC: How to Use Automation with Microsoft Project

ACC: How to Use Code to Derive a Statistical Median

ACC: How to Use Code to Derive the Statistical Mode

ACC: How to Use DAO to Assign or View Permissions

ACC: How to Use DAO to Link an Excel Spreadsheet

ACC: How to Use DAO to Retrieve a Field's Description

ACC: How to Use DDE to Pass Information to MS Access 2.0, 95

ACC: How to Use DSum to Create a Running Sum on a Form

ACC: How to Use Dynamic Data Exchange (DDE) to Fill a List Box

ACC: How to Use OpenDatabase to Open 3rd Party Database Files

ACC: How to Use Optional Parameters

ACC: How to Use Schema.ini for Accessing Text Data

ACC: How to Use Seek Method with Multiple-Field Index

ACC: How to Use the Attributes Property for TableDef Objects

ACC: How to Use the Circle Method on a Report

ACC: How to Use the ColumnWidth Property

ACC: How to Use the GetSystemMetrics() API Call

ACC: How to Use the Quit Macro Action

ACC: How to Use the ReplicationConflictFunction Property

ACC: How to Use the Seek Method on Linked Tables

ACC: How to Use the Status Bar Progress Meter

ACC: How to Use the TabStrip ActiveX Control

ACC: Imported MS Excel Carriage Returns Become Vertical Bars

ACC: Importing an Entire Sheet from a MS Excel Workbook

ACC: Introduction to Windows Programming for MS-DOS Programmer

ACC: Limiting Number of Characters Typed into Unbound Text Box

ACC: Line Numbers Not Automatically Returned by Erl Variable

ACC: Listing Object Names Using Data Access Objects (DAO)

ACC: Maximized Form Shows Control Box, Min/Max/Restore Buttons

ACC: Maximizing One Form Maximizes All Forms (95/97)

ACC: Memo and OLE Fields in a Snapshot Are Not Static

ACC: Microsoft Access Is Visible When Started Through Automation

ACC: No Difference Between dbConsistent and dbInconsistent

ACC: Number of Times a Custom Function Runs in a Query

ACC: OLE Automation Error Using Insert Method into MS Word

ACC: Overnight Batch Considerations and Sample Code

ACC: Parameter Limit for Functions in ValidationRule Property

ACC: Parsing File Names Selected from Common Dialog Control

ACC: Part 1: DDE in Visual Basic to Request MS Access Data

ACC: Part 2 DDE in Visual Basic to Request Data from MS Access

ACC: Passing a Null Pointer to an External DLL

ACC: Permissions and AllPermissions Properties

ACC: Printing a Microsoft Word Document Using Automation

ACC: Problems Quitting Microsoft Access

ACC: Problems Using Instr() to Find Special Characters

ACC: Programmatically Add Counter Field to Table Using DAO

ACC: Programmatically Link or Embed an Object in a Form (95/97)

ACC: Query by Form (QBF) Using Dynamic QueryDef (95/97)

ACC: Query with Criteria Causes ApplyFilter to Fail Silently

ACC: Reading, Storing,

ACC: Record Count Incorrect with Multiuser Tables

ACC: RecordCount Property Returns Incorrect Number of Records

ACC: RecordsAffected Property Incorrect for SQL Pass-Through

ACC: Referring to a Field in the Previous or Next Record

ACC: Regsv32a.exe Available on MSL

ACC: Retrieving the Path of Linked MS Access 95/97 Tables

ACC: Round or Truncate Values to Desired Number of Decimals

ACC: Rounding a Number Up or Down by a Desired Increment

ACC: Rounding Errors Using Floating-Point Numbers

ACC: Running a Microsoft Word 97 Macro Using Automation

ACC: Running a Microsoft Word Macro Using Automation

ACC: Running a MS Access Macro from Visual Basic Using DDE

ACC: Same Named Module

ACC: Sample Code for Running Temporary SQL Pass-Through Query

ACC: Sample Function to Create a Running Sum on a Form

ACC: Sample Function to Determine Current Page of a Form

ACC: Sample Function to Determine Language Version

ACC: Sample Function to Fill a ListView Control

ACC: Sample Function to Format Names

ACC: Sample Function to Generate a Random Temporary File Name

ACC: Sample Function to Open a Form to a Particular Record

ACC: Sample Function to Provide Password for Attached Tables

ACC: Sample Function to Remove Alphas from a Numeric Field

ACC: Sample Function to Replace Special Characters

ACC: Sample Function to Retrieve File Version Info (95/97)

ACC: Sample Function to Return a Random Record

ACC: Sample Function to Reverse a String

ACC: Sample Functions to Check User, Group Info

ACC: Sample OLE Automation for MS Word and MS Excel

ACC: Sample Procedure to Fill a TreeView Control Recursively

ACC: Screen.ActiveForm Returns Main Form, Not Subform

ACC: Seek Method Is Faster Than Find Method

ACC: Sending the Current Record to Word 97 with Automation

ACC: Sending the Current Record to Word with OLE Automation

ACC: SendObject Action Replaces Comma with Semicolon

ACC: Set the RowSource Property of a Report Graph Dynamically

ACC: Simulating a Control Array in Visual and Access Basic

ACC: Sorting Titles Without Leading Articles (The, An, etc.)

ACC: Speeding Up Iterative Processes in Visual or Access Basic

ACC: Start Files or Hyperlinks with Windows API ShellExecute()

ACC: Storing, Calculating, and Comparing Date/Time Data

ACC: Strange Characters Appear in Imported dBASE IV Database

ACC: Text Import Wizard Doesn't Import Data Correctly

ACC: Tips for Debugging Visual Basic for Applications Code

ACC: Trapping ODBC Login Error Messages

ACC: Two Functions to Calculate Age in Months and Years

ACC: Type Mismatch When Comparing Bookmarks

ACC: Use NotInList Event to Add a Record to Combo Box (95/97)

ACC: Using Automation to Add a Task/Reminder to MS Outlook

ACC: Using Automation to Add Appointments to Microsoft Outlook

ACC: Using Automation to Print Microsoft Access Reports

ACC: Using Automation to Run Word 97 Mail Merge from MS Access

ACC: Using Automation to Send a Microsoft Exchange Message

ACC: Using Automation to Transfer Data to Microsoft Excel

ACC: Using Code to Set Control's Colors

ACC: Using CreateForm(), CreateReport() Functions

ACC: Using DAO in Visual Basic Code to Import Relationships

ACC: Using DAO to Open Password-Protected Database (95/97)

ACC: Using DAO to Set and Retrieve Custom Database Properties

ACC: Using dBASE-Style REPORT FORM Command in Code

ACC: Using Eval Function with Parameters in Parameter Queries

ACC: Using IsVisible Property to Show or Hide Report Controls

ACC: Using Microsoft Access as an Automation Server

ACC: Using OLE Automation to Change a Graph's Type

ACC: Using SendKeys to Simulate Hot Keys Fails If in Uppercase

ACC: Using TAPI to Dial a Phone Under Win95/NT 4.0 (95/97)

ACC: Using the PrtDevMode Property to Verify Custom Page Size

ACC: Using Variables in the Criteria Row of the QBE Grid

ACC: Using Visual Basic to Determine Windows 95 or NT Version

ACC: Using Win32 API to Connect to Network Resources (95/97)

ACC: Validation Rule to Accept Only Alphabetic Characters

ACC: VB Example to Open an MS Access Database via DDE

ACC: Version Argument for DoMenuItem (2.0/95)

ACC2: How to Close Datasheet Form Without Saving Design Changes

ACC95: Access Keys Do Not Work with Tabs on TabStrip Control

ACC95: Can't Requery Microsoft Graph Object on Report

ACC95: Can't Update a Memo Field Using Visual Basic Code

ACC95: Can't Use Visual Basic Procedure to Reference Project

ACC95: Cannot Export Run-Time Font Style Changes to RTF

ACC95: Constants in the Microsoft Access 95 Object Library

ACC95: Constants in the Microsoft DAO 3.0 Object Library

ACC95: Create and Date Stamp a Word Document Using OLE Automatio

ACC95: GetObject Sample Function Does Not Detect Excel 7.0

ACC95: How to Bind a RichTextBox Control to a Field in a Table

ACC95: How to Create a Custom Toolbar Using a Form

ACC95: How to Create a FindRecord Form Method

ACC95: How to Import Microsoft Word Tables Using OLE Automation

ACC95: How to Run a Function from a Custom Toolbar Button

ACC95: How to Run an MS PowerPoint 95 Slide Show in Access 95

ACC95: How to Use OLE Automation to Create a Word Document

ACC95: Incorrect GetAccessReportList in 'Building Applications'

ACC95: Microsoft Jet Database Engine 3.0 Reserved Errors List

ACC95: Missing Variable Declarations in Rate Function Example

ACC95: Opening Multiple Instances of Report Binds Data Too Soon

ACC95: RegisterDatabase Example in Help Causes Error

ACC95: Running Word Mail Merge from Access Using OLE Automation

ACC95: TransferDatabase/CopyObject in Runtime May Corrupt Object

ACC95: Using MS Word's FileClose/DocClose Statements in OLE

ACC95: Using OLE Automation to Import Microsoft Exchange Message

ACC95: What Is New and Obsolete with DAO in MS Access 95

ACC97: ASP Files Display Hyperlinks as Text in Web Browser

ACC97: Can't Access ShortCut Menus CommandBar from Code

ACC97: Can't Use OutputTo Method with Form or Report Modules

ACC97: Can't Use PrtDevMode or PrtMip Property with MDE Files

ACC97: Cannot Use RunCommand acCmdSaveModuleAsText in Code

ACC97: Cannot View Class Module in a Referenced Database Library

ACC97: Changing Project Name Doesn't Enable Compile Menu Command

ACC97: CommitTrans Help Topic Uses dbFlushOSCacheWrites Constant

ACC97: Compile Error Converting a Module with Line Continuation

ACC97: Compile Error with Converted Macro with RunSQL Stmt

ACC97: DAO Property Retrieval Slow with Linked Table Objects

ACC97: Data in ASP Fields with Spaces Not Committed to Access DB

ACC97: Debug Window Is Not Displayed After Using Echo Method

ACC97: DOC: Unload Statement Does Not Apply to Microsoft Access

ACC97: Error 'The Save operation failed' When Saving a Module

ACC97: Error: 'There Isn't Enough Disk Space or Memory'

ACC97: Errors in 'GetObject Function' Example in Help

ACC97: Example Using a Callback Procedure with Balloons

ACC97: Example Using Animation ActiveX Control in MS Access 97

ACC97: Example Using the Internet Transfer ActiveX Control

ACC97: Example Using TreeView Control Drag-and-Drop Capabilities

ACC97: Form Control Format Property Ignored when Exported to ASP

ACC97: Form_MyForm Referencing Breaks After Converting from 95

ACC97: Format Properties Ignored When Exporting Queries to ASP

ACC97: How to Animate the Office Assistant

ACC97: How to Change a Chart's Colors Dynamically

ACC97: How to Create a Data Entry Form in ASP Format

ACC97: How to Create an MS Graph in PowerPoint Using MS Access

ACC97: How to Create Command Bars Using Visual Basic Code

ACC97: How to Create Custom Navigation Buttons on an ASP Page

ACC97: How to Create Hyperlink Fields in ASP Forms

ACC97: How to Create Shortcuts from a Field of Hyperlinks

ACC97: How to Create Your Own Custom Security Reports

ACC97: How to Dim Menu Items or Disable Toolbar Buttons in Code

ACC97: How to Get a Calendar Control to Work on an ASP Page

ACC97: How to Modify ASP Forms to Allow Deleting from Text Boxes

ACC97: How to Print a Report to Different Paper Trays

ACC97: How to Programmatically Add Controls to a Tab Control

ACC97: How to Revert MS Graph 5.0 Graphs That Have Been Upgraded

ACC97: How to Set Number of Copies for Report w/ PrintOut Method

ACC97: How to Use Collections to Manage Class Objects in VBA

ACC97: How to Use Percent, Plus, and Caret Symbols in ASP Forms

ACC97: How to Use the RefreshDatabaseWindow Method

ACC97: How to View Images from OLE Object Field in IDC/ASP Files

ACC97: Introduction to Stand-Alone Class Module Programming

ACC97: Invalid FileName Causes Untrappable Error In Assistant

ACC97: IsMissing() Returns False for Non-Variant Data Types

ACC97: Listview Control Loses Data When Changing Properties

ACC97: Long File Names Used for Saving Multiple HTML Pages

ACC97: Macro to VBA Uses Unexpected Syntax with Form References

ACC97: Migrating from Data Outline Control to TreeView Control

ACC97: Only One Menu Bar Can Be Visible at a Time Using Code

ACC97: Overlapping List Box Controls Show Through One Another

ACC97: Reference Library Not Available in Enabled 97 Database

ACC97: Removing All Pages from Tab Control Removes the Control

ACC97: Run-Time Error '3027' Using ODBCDirect to Open RecordSet

ACC97: Sample Procedure to Attach a Microsoft Outlook Folder

ACC97: Setting Default Control Properties in Visual Basic

ACC97: Tips for Converting Applications to Using ODBCDirect

ACC97: TransferDatabase Causes Page Fault If Object Exists

ACC97: Two Examples Using the Winsock ActiveX Control

ACC97: Uninitialized String in FollowHyperlink Method Causes Err

ACC97: Using a File DSN or DSN-Less Connection with ASP files

ACC97: Using Automation to Send a Microsoft Outlook Message

ACC97: Visual Basic Example for CommonDialog Control Won't Work

ACC97: Why a Calculated Control Is Blank

ACC97:Transaction in ODBCDirect Workspace Causes Corrupted Index

Activating an Embedded Chart Using a Macro

Assigning Help Files and Topic IDs in a Visual Basic Project

Automation Error Using Excel Object in Visual Basic Procedure

BUG: Shell Returns Invalid Proc Call Even If App Starts

BUG: Cannot Reference Excel 8.0 Object Library from VB 4.0x

BUG: Excel Displays Only First Column in Embedded Worksheet

BUG: Format Function Returns Incorrect Date or Number

BUG: GPF in Excel After Using Excel Spreadsheet in OLE Control

BUG: Is Operator in VBApp Incorrectly Evaluates Excel Objects

BUG: Multiple SendKeys Statements Turn Off NumLock Key

BUG: OLE Container Launches Word When Resized

BUG: String/Currency Conversion Broken with Sci. Notation

BUG: VBApp FileCopy Updates Destination File's Date

Calling Macros Using OLE from MS Visual Basic for Applicatons

Calling MS Excel Macros and Functions from AppleScript

Can Use Property Get Statement with User-Defined Type

Can't Change Working Time After Running Macro to Edit Calendar

Can't Run Macro That Calls 16-bit DLL in 32-bit MS Excel

Can't Shut Down or Restart Computer After Creating Binder Object

Can't Use Arguments to Call Sub When Another Procedure Running

Can't Use SQLRetrieve/SQLRequest to Return Over 248 Columns

Cannot Implement ListBox Control ColumnHeads Property

Cannot Modify a Visual Basic Procedure in Break Mode

Cannot Unhide Module Sheet If Visible Property Is xlVeryHidden

CDbl Function Returns Wrong Value with Currency Data Type

Change in Tools References Dialog Box Not Saved in GLOBAL.MPT

Close Button on a Message Box Is Unavailable Under Windows 95

Closing Shared Files Using a Macro May Cause Infinite Loop

Converting Microsoft Excel Values to Text in an Excel Macro

DAO 3.0 CopyFromRecordset Method Not Compatible With XL97

DataSource Property Unavailable for Bound Controls

Date, Time, Currency Formats Different from International

Definition of DoEvents in Visual Basic for Applications

Differences Between VB 3.0 and Applications Edition

DocErr: EnableCancelKey Property Uses xlDisabled Constant

Err Msg Using CInt() Function: Type Mismatch

Err Msg: 'Invalid Number of Arguments' with DialogFrame

Error in Recorded QueryGetData Function with ODBC 2.0 Drivers

Error Message If Array Contains More Than 2,730 Elements

Error Messages in Macro (How to Create a Reference)

Error Referencing Foreign Language Object Library

Error Using Call Statement with Function Procedure

Error Using Returned Values as Input with Fourier Analysis

Excel: Auto Save Add-In Macro Halts If No Files Are Open

Excel: Cannot Open an Alias from a Macro

Excel: Counting the Number of Words or Characters in a Cell

Excel: Duplicate NOTE or DEFINE.NAME in Recorded Macro

Excel: Editing a Chart SERIES Formula with a Macro

Excel: Exiting Windows from a Command Macro

Excel: Functions Recalculated If New Data or Cells Entered

Excel: How to Use a Custom Dialog Box as a Startup Screen

Excel: Macro Error when Adjusting an Embedded Chart

Excel: Macro Recorder Generates Error with Embedded Chart

Excel: Removing Chart Links to a Worksheet in a Macro

Excel: Running FLATFILE.XLA from a User-Defined Macro

Excel: Solver Macro Commands Change the Echo Status

Excel: User-Defined Function Category Limit

Excel: Using EXEC with Document Name Causes Macro Error

Excel: Using Functions that Return References

Excel: Wrapped Button Text on Dialog Sheet Is Truncated

FAQ: Non-technical Questions About Visual Basic 5.0

FILE: Help File for VB OLE Automation w/ Word for Windows

FILE: How to Identify the Jet Database Engine Components

FILE: Integrating a PowerPoint 7.0 Slide Show w/Visual Basic

FILE: OLE Automation Methods/Properties Supported by OLE App

FILE: VB4 16-Bit OLE Clients Receive Error -2147319784

FIX: ActiveX Control Incorrectly Reports ScaleWidth/ScaleHeight

FIX: Compiling VB5 Applications with Large UDTs May Crash

FIX: Microsoft Excel 95 Doesn't Respond Correctly to GetObject

General Protection Fault Using DateValue or TimeValue()

Global Versus Public in Visual Basic

GP Fault Setting Property Value to Array of Custom Data Type

GP Fault Using MAPI.DLL Calls in Visual Basic Procedure

GRAPH97: Visual Basic Help for Microsoft Graph Not Installed

How to Compare Two Cells Ignoring Leading and Trailing Spaces

How to Create a GIF File from a Microsoft Excel Chart

How to Create Next and Previous Buttons in a Custom Dialog Box

How to Dimension a Variable as Name Type

How to Display Quotation Marks in Function Results and Macros

How to Fill a UserForm ListBox with Database Values

How to Fill the Microsoft Visual Basic 5.0 FlexGrid Control

How to Install Simple MAPI in Your VBApp Application

How to Manipulate Object's Properties w/ Property Set/Let/Get

How to Retrieve Request Items Using DDERequest to MSQuery

How to Run VB for Apps Code from an MS Excel 4.0 Macro Sheet

How to Save Personal Macro Workbook When MS Excel Is Open

How to Search Microsoft VBA

How to Sort Schedule+ 7.0 Contacts List Using VB for Apps

How to Use Looping Structures in Visual Basic for Applications

HOWTO: Add a New Appointment in Schedule Plus

HOWTO: Automate the Microsoft Office Binder Object through OLE

HOWTO: Call a Visual Basic 4.0 OLE Server from Excel 5.0

HOWTO: Call a Visual Basic Application from Excel

HOWTO: Call LanMan Services from 32-bit Visual Basic Apps

HOWTO: Call LoadModule() API Function from Visual Basic

HOWTO: Capitalize the First Letter of Each Word in a String

HOWTO: Change the Short Date Format from Visual Basic

HOWTO: Check For a Running Instance of Word 95 From VB

HOWTO: Convert a Database Table into an Excel Spreadsheet

HOWTO: Create a New Contact in Schedule Plus from Visual Basic

HOWTO: Create a Parameter Query via Data Access Objects

HOWTO: Create a Report in Word w/Excel Chart via OLE Automation

HOWTO: Create an Incremental Search ComboBox

HOWTO: Create Excel Chart w/OLE Automation from Visual Basic

HOWTO: Create Pie Charts Using the Circle Method in VB

HOWTO: Display a Closed Message

HOWTO: Dynamically Create Excel 5.0 Charts in OLE 2.0 Control

HOWTO: Evaluate Numeric Expressions Stored as a String

HOWTO: Extract Appointment Information from Schedule Plus

HOWTO: Extract Appointment Information from Schedule Plus 7.0

HOWTO: Fill a 32-bit VBA Array of UDType via a Visual C++ DLL

HOWTO: Find Articles About VB 3.0, Applications Edition

HOWTO: Find Articles About Visual Basic Applications Edition

HOWTO: Get a Window Handle Without Specifying an Exact Title

HOWTO: Get List of Documents

HOWTO: Get the Unread Message Count from an Outlook Folder

HOWTO: Have a VB Program Change a Word Document's Page Layout

HOWTO: Improve String Concatenation Performance

HOWTO: Invoke Word 6.0 Font Dialog for Word Object from VB

HOWTO: Navigate Excel Objects from Visual Basic

HOWTO: Open Another User's Schedule Programmatically

HOWTO: Optimize OLE Calls in Visual Basic

HOWTO: Optimize OLE Server Instance Usage by Using GetObject

HOWTO: Parse a Person's Name into Multiple Variables

HOWTO: Parse City, State, and Zip Code into Separate Values

HOWTO: Prepare Visual Basic Applications for the Year 2000

HOWTO: Print Multiline Text Box Using Windows API Functions

HOWTO: Print Two Excel Charts on Single Page w/OLE Automation

HOWTO: Programmatically Restart or Log Off a Computer

HOWTO: Read or Modify User-Defined DAO Properties

HOWTO: Retrieve Individual Bytes from a Multi-Byte Type in VB

HOWTO: Run a Word 97 Macro that Requires Arguments

HOWTO: Run a Word Macro While Editing a Word Object in VB

HOWTO: Save an Embedded Word Document in Visual Basic

HOWTO: Scroll VB Text Box Programmatically and Specify Lines

HOWTO: Search for the Last Occurrence of a Substring

HOWTO: Use DDE to Run a Word for Windows Macro from VB

HOWTO: Use Events to Determine When Word Quits

HOWTO: Use OLE Automation with Microsoft Outlook 97

HOWTO: Use Optional Arguments in Intrinsic Data Types

HOWTO: Use QueryPerformanceCounter to Time Code

HOWTO: Use Spaces in Enumerated Types

HOWTO: Use the DrawText API Call from Visual Basic

HOWTO: Use the Registry API to Save and Retrieve Setting

HOWTO: Use the Word 6.0 SpellChecker Via OLE Automation in VB

HOWTO: VB Can Determine if Specific Windows Program Is Running

HOWTO: VB Uses OLE Automation with Excel Version 5.0

HOWTO: VB Uses OLE Automation with Word Version 6.0

HOWTO: VB3: Adjust FontSize at Run-time for Diff. Video Drivers

HOWTO: VB3: Create Excel Chart with OLE Automation from VB

HOWTO: VB3: Dynamically Create Excel 5 Charts in OLE 2 Control

HOWTO: VB3: Navigate Excel Objects from Visual Basic 3.0

HOWTO: VB3: Use the Word SpellChecker Via OLE Automation

HOWTO: Write C DLLs and Call Them from Visual Basic

Improving Performance of Macro That Has a Repetitive Function

Incorrect Value Returned for Custom Property Linked To Content

INFO: Common Remote OLE Automation Errors

INFO: Differences Between Exclamation Mark (!)

INFO: Do Not Define Functions in DLLs that Raise an Exception

INFO: Example of calling EnumFontFamilies from a DLL

INFO: Format Function and International Settings

INFO: How Null String Pointers Behave in Visual Basic 4.0

INFO: Late, ID, Early Binding Types Possible in VB for Apps

INFO: LenB Returns in-Memory Size of User-Defined Type

INFO: Microsoft Consulting Services Naming Conventions for VB

INFO: Multiple vbCancel Constants Defined with VB 4.0

INFO: OLE Automation Objects with GetObject and CreateObject

INFO: PERFORM.TXT: Performance Tuning Tips for VB and Access

INFO: Summary of Sample Applications on the ODK 1.0

INFO: User-Defined Collections Are 1-Based Not 0-Based

INFO: VB5 FAQ: Visual Basic 5.0 Control Creation Edition

INFO: VBA Versions in Different Microsoft Products

INFO: Visual Basic SendKeys Statement Is Case-Sensitive

INFO: Where to Get Developer Support for VBA5 SDK

IS Operator Does Not Work with Microsoft Excel Objects

KB Help File for Visual Basic for Applications

Line Numbers Greater Than 65529 Not Supported

Lotus Macros That Do Not Directly Translate into Excel

Macro Error After PASTE() Function in Excel

Macro to Add Data Point Labels to a Chart in Excel

Macro to Change Default *.XL* to *.* in Open Dialog Box

Macro to Display Each Sheet in Workbook in a Separate Window

Macro to Open or Activate a Sheet in Microsoft Excel

Macro to Place Filenames in Given Directory on Worksheet

Macro to Save All Open Worksheets in Excel

Macro to Show Named Ranges Containing the Active Cell

Making a Multiple Selection from a Macro in Excel

Menus.Count Returns Different Number When Workbook Maximized

Microsoft Excel Event Properties Are Global for Each Session

Module Language Translated on Move or Copy into New Project

More Data Pasted Than Expected with SELECTION.OFFSET.SELECT

MSQuery: DDE Activate Command Does Not Activate Window

MSQUERY: DDE Commands Available Only on System Channel

MSQUERY: FieldDef Request Item Returns Dimensional Array

MSQuery: Obtaining Login String from DDE Request to Query

MSQUERY: Undocumented DDE Request Items TierType and FileExt

Multiple References with Same Name in References Dialog Box

MXL: Check Box Assigned to Macro May Fail

MXL: How to Move the Selection After Return with ENTER Key

MXL: Problems Using the SAVE.AS and SaveAs Macro Functions

MXL5: 'Not Enough Memory' Using SHOW.BAR Function in Macro

MXL5: Cannot Publish Chart Object from a Visual Basic Macro

MXL5: Error Pasting to Word Document Using OLE Automation

MXL5: Option Button and Check Box Labels Don't Update Properly

MXL5: Running VBA Procedures from AppleScript

No Macro Function to Access Solver Dialog Box

Null Character Truncates String in Visual Basic

Object Is Not Visible After Using CreateObject Method

ODE: How to Create a Shortcut on the Desktop with ODE

ODE97: Some Properties of ActiveX Controls Not Supported

OFF: Error When You Remove Forms Object Library Reference

OFF: How to Add and Use the Comment Block Command

OFF: Office Assistant Not Answering Visual Basic Questions

OFF97: Activate Event for UserForm May Not Be Triggered

OFF97: ActiveX Control Copy or Drag Between Applications Fails

OFF97: Automation Error After Using RegClean 3.0 or 4.0

OFF97: Can't Dimension Word as Application from Other Program

OFF97: Compile Error Using the Visible Property of UserForms

OFF97: Custom Office Assistant Balloon Cannot Be Dismissed

OFF97: Displaying UserForm Designer Resets Global Variables

OFF97: Error in Macro Referencing Remote Data Objects

OFF97: How to Change the ToolTip for a Custom Toolbar Control

Off97: How to Create and Use a Global Array in VBA Procedures

OFF97: How to Prevent Customization of Menus and Toolbars

OFF97: How to Run Sample Code from Knowledge Base Articles

OFF97: How to Show a 'Now Processing' Dialog While Macro Runs

OFF97: Kill Statement May Delete All Files in a Folder

OFF97: Macro That Retrieves the Number of Files in a Directory

OFF97: Unable to Record Adding To Favorites in Open Dialog Box

OFF97: Using Automation to Run Microsoft Access

Off97: Visual Basic Help File For Microsoft Graph Available

OFF97: Visual Basic Modules Cannot Be Hidden or Protected

OFF98: Activate Event for UserForm May Not Be Triggered

OFF98: Compile Error Using the Visible Property of UserForms

OFF98: CurDir Function Doesn't Include Trailing Path Separator

OFF98: Displaying UserForm Designer Resets Global Variables

OFF98: How to Display ComboBox List When UserForm Is Displayed

OFF98: How to Run Sample Macro Code from Knowledge Base Articles

OFF98: Visible Property Does Not Apply to All CommandBars

OL97 VBScript: How to Populate a ComboBox with Your Contacts

OL97: Accessing Data from an Outlook Grid Control

OL97: Additional Control Properties Available for Programming

OL97: Bound Control Does Not Support Click Event

OL97: Cannot Programmatically Change Contact's E-mail Address

OL97: Cannot Programmatically Sign or Seal a Mail Message

OL97: Creating Sequentially-Numbered Items in a Folder

OL97: Custom Forms and Programming Limitations

OL97: Errors in Outlook Visual Basic Help (Vbaoutl.hlp)

OL97: General Information About Using VBScript with Outlook

OL97: How to Automate Outlook from Another Program

OL97: How To Create a Categories Button on a Custom Form Page

OL97: How to Create a New Item Based on a Custom Form

OL97: How to Display a Web Page in an Outlook Form

OL97: How to Get Help Programming with Outlook

OL97: How to Programmatically Import Outlook Items from Access

OL97: How to Programmatically Resolve a Contact's E-mail Address

OL97: How to Programmatically Set TextBox and CheckBox Values

OL97: How to Retrieve All Recurring Appointments with Code

OL97: How to Set a Form's From Field Using VBScript

OL97: How to Simulate a Form 'Create' Event in VBScript

OL97: How to Start Another Program from an Outlook Form

OL97: How to Use Command Bars in Outlook Solutions

OL97: How to Use Fields and Controls with VBScript

OL97: How to Use the Restrict Method

OL97: How to Use Variables with Find and Restrict Filters

OL97: Next/Previous Disabled Using Programming to Display Item

OL97: Outlook VBScript Editor Patch Available on MSL

OL97: Programmatically Accessing Office Form Documents

OL97: Programmatically Specifying an Attachment Type

OL97: Programmatically-Created Attachment Loses Icon

OL97: Programming Examples for Referencing Items and Folders

OL97: Programming With EntryIDs, StoreIDs, and GetItemFromID

OL97: Q? Questions about Customizing or Programming Outlook

OL97: SaveSentMessageFolder Property Renames Folder

OL97: ShowFormPage/HideFormPage Changes Form's Message Class

OL97: Supported Outlook Forms Control Events

OL97: Syntax to Access Controls on User-Designed Form

OL97: Troubleshooting Solutions That Don't Run on Other Computer

OL97: VBScript Cannot Access Characters in the Body Property

OL97: VBScript Example Returns the Current User Name

OL97: Working with Form Definitions and One-Off Forms

OL97: Working with Keywords Fields from VBScript

OL97: Working With the Message or Body of an Outlook Item

OLE Automation: Add-Ins Don't Load When Using CreateObject

ON.TIME() and OnTime Method Disable Windows Screen Saver

PivotTableWizard Method Fails If Active Cell Not In Table

PPT: Code Displays Each Word of Selection in Message Box

PPT: Code to Change 'White Areas' of Graphic to Transparent

PPT: Code to Count the Placeholders on the Current Slide

PPT: Error Importing Form Into the Visual Basic Editor

PPT: For Each Loop Doesn't Find All Shapes on a Slide

PPT: How to Add a Macro to a Toolbar

PPT: How to Create a PowerPoint 97 Add-In

PPT: How to Use the AddLine Method

PPT: How to Use the EntryEffect Property

PPT: How to Use the Shell Function to Print a Presentation

PPT: Incorrect Arguments in Export Method Help Topic Example

PPT: Introduction to Macro Programming in PowerPoint 97 and 98

PPT: Macro Menus and Visual Basic Editor Require an Open File

PPT: Quitting the VBE Changes the Active Presentation

PPT: Run-Time Error Using the AddPicture Method

PPT: Sample Code Displays Message Box With AutoShape Type Name

PPT: Sample Code To Add the Path and File Name to Each Slide

PPT: Sample Code to Animate All Graph 8.0 Objects

PPT: Sample Code to Apply Small Caps Formatting to Selection

PPT: Sample Code to Assign a Random Animation to all Objects

PPT: Sample Code to Center a Selection of Objects

PPT: Sample Code to Change the Chart Type of a Graph

PPT: Sample Code to Change the Zoom Percentage

PPT: Sample Code to Control Word from a PowerPoint Macro

PPT: Sample Code to Copy Slide to Different Presentation

PPT: Sample Code to Copy Slides to Another Presentation

PPT: Sample Code to Create a Basic Organization Chart

PPT: Sample Code to Determine the Current View

PPT: Sample Code to Determine the Number of Open Presentations

PPT: Sample Code to Display the Selection Type

PPT: Sample Code to Extract Text from an Organization Chart

PPT: Sample Code to Find Slides that Don't Follow Slide Master

PPT: Sample Code to Get Input From an Office Assistant Balloon

PPT: Sample Code to List Available Add-Ins

PPT: Sample Code to Name a Slide

PPT: Sample Code to Print All Open Presentations

PPT: Sample Code to Print Slide Numbers for a Custom Show

PPT: Sample Code to Reset Action Settings

PPT: Sample Code to Reset the Builds on a Slide

PPT: Sample Code to Retrieve or Set Slide Size

PPT: Sample Code to Retrieve the Fonts Used in a Presentation

PPT: Sample Code to Update Links in a Graph Datasheet

PPT: Sample Macro Code To Visit Every Open Slide

PPT: Sample VB Code Adds Multiple New Slides to Presentation

PPT: Sample VB Code that Inserts Title Slide and Title Text

PPT: Sample VB Code to Check for Open Presentation

PPT: Sample VB Code to Count Graph 97 Objects on Current Slide

PPT: Sample VB Code to Create a Custom Slide Show

PPT: Sample VB Code to Create a Graph on a Slide

PPT: Sample VB Code to Create Shape Using FreeForm Tool

PPT: Sample VB Code to Delete a Custom Slide Show

PPT: Sample VB Code to Get Selected Text

PPT: Sample VB Code to Group Objects Together

PPT: Sample VB Code to Make the Selected Text Bold

PPT: Sample VB Code to Manipulate Command Bars

PPT: Sample VB Code to Print Current Slide from Slide Show

PPT: Sample VB Code to Retrieve Current Slide Number

PPT: Sample VB Code to Retrieve Summary Properties

PPT: Sample VB Code to Retrieve the Path to PowerPoint

PPT: Sample VB Code to Retrieve the Title of a Graph

PPT: Sample VB Code to Reverse Order of Slides

PPT: Sample VB Code to Turn Bullets On or Off

PPT: Sample VBA Code to Create a Graph from a Text File

PPT: Sample VBA Code to Insert an Image Full Size and Centered

PPT: Unable to Change the ActivePrinter Property With VBA

PPT: Using LeftMargin or FirstMargin Yields Unexpected Results

PPT: Using Macros Stored in Templates

PPT7: OLE Automation Error Using Open Method

PPT7: PowerPoint Supports OLE Automation via VBA Object Model

PPT7: Printing Programmatically Generates Error

PPT7: Sample Code to Retrieve the Current Slide Number

PPT97: Add-in Rotates 3-D Objects in One-degree Increments

PPT97: Assigning Word Styles to the PowerPoint Slide Master

PPT97: Cannot Display Built-in Dialog Boxes Using Object Model

PPT97: Cannot Set Save Picture Preview Programmatically

PPT97: Code for Moving Objects On Screen During a Slide Show

PPT97: Code to Display the Number of Slides or Shapes Selected

PPT97: CreateObject Does Not Create New PowerPoint Session

PPT97: Expressions Added to Watch Aren't Saved in Presentation

PPT97: F1 Key May Not Start Help When in the Visual Basic Editor

PPT97: Graph8 Process Remains in Memory After Macro Ends

PPT97: How to Activate a Media Object From a Macro Button

PPT97: How To Manipulate ActiveX Controls Through VBA Macros

PPT97: How to Record a Macro using PowerPoint 97

PPT97: How to Use the AddPicture Method

PPT97: How to use the Presentations.Open Method

PPT97: How To Use the SaveAs Method

PPT97: How to Use the WindowState Property

PPT97: Incorrect Code Recorded Changing Fonts in Grouped Object

PPT97: Macro May Stop Running After Slide Show Ends

PPT97: Macro Recorder Does Not Record Closing Slide Miniature

PPT97: Macro Recorder Does Not Record Increase or Decrease Font

PPT97: Macro Recorder Does Not Record Show Command

PPT97: Macro Recorder Does Not Record Undo or Redo Actions

PPT97: Macro Recorder Doesn't Record Activating Placeholder

PPT97: Macro Recorder Doesn't Record Changes to Links Dialog Box

PPT97: Macro Recorder Doesn't Record Changes to Options Dialog

PPT97: Macro Recorder Doesn't Record Code Moving Command Bars

PPT97: Macro Recorder Doesn't Record Find or Replace Commands

PPT97: Macro to Export PowerPoint Slides as Graphics

PPT97: Main Street Demo Uses VBA for Interactive Slide Show

PPT97: NewShow Method Doesn't Start Slide Show If Viewer Running

PPT97: Not Enough Memory Using Help in Run-Time Error Message

PPT97: Paste Special Not Available in PowerPoint Object Model

PPT97: Run-Time Error Using Assistant.Application

PPT97: Run-Time Error When Opening Shortcuts Programmatically

PPT97: Sample Code to Add a Media Object to a Running Slide Show

PPT97: Sample Code to Change Source of Linked Excel Worksheet

PPT97: Sample Code to Copy All Objects to a New Presentation

PPT97: Sample Code to Create Backup Presentations

PPT97: Sample Code to Open a Web Site in Internet Explorer

PPT97: Sample Code to Rotate 3D Shapes During a Slide Show

PPT97: Sample Code to Save a PowerPoint Presentation as RTF

PPT97: Sample VB Code Changes Source of Multiple Linked Objects

PPT97: Sample VB Code Retrieves Total Number of Custom Shows

PPT97: Sample VB Code That Detects When a Slide Show Ends

PPT97: Sample VB Code to Control Window Redraw

PPT97: Sample VB Code to Insert a Background Image

PPT97: Sample VB Code to Obtain Window Handle

PPT97: Sample VB Code to Save a Presentation in Multiple Formats

PPT97: Sample VB Code Uses DAO to Create Presentation

PPT97: Tag Name Always Returned As Upper Case String

PPT97: Typing Is Slow When Recording a Macro

PPT97: Viewer Quit Method Does Not Close Viewer

PRB: 'Object not a Collection' Trying to Read Array Element

PRB: Arguments Are Evaluated from Right to Left in Some Cases

PRB: Can't Have Fixed Length Strings

PRB: Can't Watch Properties or Fields Used in a WITH Statement

PRB: Error 3162 Setting FoxPro Date Field to Null

PRB: Error Passing Recordset to Excel Using Automation From VB

PRB: Error When Excel VBApp Proc

PRB: Excel Automation: Method of Object '_Global' Failed

PRB: Excel Doesn't Use Container's Name for Embedded Objects

PRB: IPF While Debugging Microsoft Access Automation Code

PRB: Len and LenB May Differ on Size of User-Defined Types

PRB: Mismatched Jet DLL Files with Excel and Visual Basic

PRB: Naming Conflicts Between Variables and Objects

PRB: Object Created w/NEW Instantiated When Passed as Argument

PRB: OLE Automation Err: Method Not Applicable for This Object

PRB: OPTION PRIVATE Statement Has No Effect in Visual Basic

PRB: Overflow Doesn't Occur Using Pentium Pro or Pentium II

PRB: Plus Sign (+) Operator Behaves Differently in VB 4.0

PRB: Print Function Evaluation Order Has Changed

PRB: Run-Time Overflow Error w/Byte-Type Counter in For Loop

PRB: Sub Name Can't Be Valid Cell Reference in Excel VBApp

PRB: Type Mismatch When Passing Variants to Word Using OLE

PRB: VB/VB Apps Won't Run if Windows NT OLE Service Stopped

PRB: Wrong Number of Arguments Error When Call Math Functions

PRJ AppNote: Constants for Project and Visual Basic (WP1043)

PRJ: 'User-Defined Type Not Defined' Error in Macro

PRJ: Auto_Open and Auto_Close Macros

PRJ: Can't Select OLE Object Using Visual Basic Macro Command

PRJ: Cannot Execute Macros with Optional Arguments

PRJ: Changing Title Via Macro Won't Change Summary Task Name

PRJ: Creating a Multi-Line Filter Using the FilterEdit Method

PRJ: Current Date Gridline Not Redrawn Using CurrentDate Prop

PRJ: Error Using Command Without Required Arguments

PRJ: FilterApply Method Fails with Two Interactive Dialog Boxes

PRJ: How to Use the GanttBarFormat Method

PRJ: Incorrect TimescaledData Syntax in Visual Basic Reference

PRJ: Macro to Sum Values in Filtered List

PRJ: Minimize Argument in AppExecute Does Not Work

PRJ: Running a Macro Automatically When You Start MS Project

PRJ: TimeScaledData Method Example Run Time Error 91

PRJ: Toolbar Buttons Don't Work When Using DoEvents Statement

PRJ: Using DateDifference to Calculate Planned % Complete

PRJ: Using DDEExecute to Pass Arguments to MS Project Macros

PRJ: Using VBA Print Method Without Displaying Dialog Box

PRJ: VB Code to Find Blank Rows in Task or Resource Sheet

PRJ4: 'Cannot Find Macro' Choosing Existing Macro from Tools

PRJ4: 'Cannot Read From Drive' Error Using AppExecute Method

PRJ4: Add Method Returns Wrong Resource Assignment UniqueID

PRJ4: Changing Paste Linked Cell Via a Macro May Cause GPF

PRJ4: ChDir Command Doesn't Change the Default Directory

PRJ4: Converting Duration Values

PRJ4: Deleted Object Causes General Protection (GP) Fault

PRJ4: Error When You Use a Macro to Consolidate Files

PRJ4: Field Names for Other Languages for Use in Macros/Views

PRJ4: Find Macro Method May Cause Run-Time Error 1004

PRJ4: GP Fault If ConsolidateProjects Has Long Filenames Arg

PRJ4: GP Fault Using Replace While Debugging Macro

PRJ4: HoursPerDay/HoursPerWeek Properties Return Wrong Values

PRJ4: OpenFromDatabase Causes Error When Used to Open File

PRJ4: Printer Font Unavailable in Macro or Toolbar

PRJ41: 'Out Of Memory' Adding Task or Resource in Macro

PRJ41: ActiveCell Collection Causes MS Project to Hang

PRJ98: Button Customization Not Recorded by Macro Recorder

PRJ98: Run-time Error Using Project 95 Object Library

PRJ98: Subscript Out of Range Err Using PercentComplete Property

PRJ98: Unit of Time Included when Pasting Timescaled Work

Proj41: Using DAO to Export Data to Microsoft Access

Public Variables Are Not Seen on Modules for Sheet or UserForm

Query to Find Unmatched Records Between Two Files

Rounding Errors In Visual Basic For Applications

Run-time Error Using SendKeys to Send Right Brace Character

Sample Code to Reset Custom Animation

Sample Code to Retrieve the Name of the Active Printer

Sample Macro That Converts the Default Chart to Microsoft Excel

Sample Macro to Open a Text File Without Displaying TextWizard

SendKeys '{CAPSLOCK}' Toggles CAPS LOCK Key State

SendKeys Statement Doesn't Affect NUM LOCK Key State

SendKeys Statement Doesn't Send Keystrokes to Module in MS Excel

Showing xlDialogFormatChart Causes Run-Time Error

Some Command Argument Names Not Capitalized

Some Key Combinations Don't Work in Visual Basic Module

Some ShapeRange Methods Do Not Work for Mixed ShapeRanges

SQLOpen May Not Be Able to Connect to Oracle Databases

Stack Space Error in Macro in MS Excel 5.0c But Not in 5.0

Transferring an Array from VB 3.0 to a Microsoft Excel Sheet

UNCONF: Out of Stack Space Error Calling QueryGetData

Using a Macro to Select Font Cartridges

Using GET.CELL with Type_num 15 in Excel

Using MS Excel 5.0 Dialog Boxes MS Excel 4.0 Macro Language

Using Saved Property to Determine If Workbook Has Been Changed

Using Square Brackets in a Visual Basic Procedure

Using the OnKey Method in a Visual Basic Macro

Value of Variables Reset in Immediate Pane

VARTYPE() Function Returns Value 8204 for Variant/Array

VB Macro to Tell If You Are Running 16-bit or 32-bit MS Excel

VBA: Display Specified Date in Outlook Calendar

VBA: ErrMsg: 'Class Not Registered' Inserting UserForm

VBA: How to Create a New Contact Item in Outlook with Automation

VBA: How To Delete a Sub Procedure After It Runs Once

VBA: How to Run Macros in Other Office Programs

VBA: Invalid Page Fault with More Than 411 Controls in UserForm

VBA: Programming Resources for Visual Basic for Applications

VBA: Reset Method of CommandBars Rebuilds Menu Bar Only

VBA: Run-Time Error 3085 Using DAO

VBA: Sample Code to Determine CD-ROM Drive Letter

VBA: Sample Code to Determine Whether a File Exists

VBA: Sample Code to Retrieve the Current User Name

VBA: Sample Code to Return the UNC Path of a Network Drive

VBA: Scope of Variables in Visual Basic for Applications

VBA: Selected Check Box or Option Button Prints Unselected

VBE: Underscore Characters Not Printed from VB Editor

Visual Basic Code to Activate a Text Box for Editing

Visual Basic for Applications Macro That Displays a File List

Visual Basic INT Function Returns Incorrect Value

Visual Basic Macro to Protect Multiple Sheets in a Workbook

WD: Add Button Unavailable for Insert/Bookmark

WD: ErrMsg Using Mid$(), Left$() or Right$() Function

WD: Manage Fields Dialog Box Returns Incorrect Values

WD: WordBasic Macro to Number New Documents in Sequence

WD97: Cannot Find VEENLR3.HLP After Typical Installation

WD97: 'All Active Templates and Documents' Missing Macros

WD97: 'For Each...Next' Loop Gives Wrong Result with Endnotes

WD97: 'Replace With' Format Incorrect with Recorded Macro

WD97: 'String Too Long' Using Over 255 Characters

WD97: 'This file could not be found' Error with Open Method

WD97: Acceptable Values of wdLineWidth Constant (in wdLineStyle)

WD97: Activewindow.Panes.Count Returns 1

WD97: Add Button Unavailable for Insert/Bookmark

WD97: Application Error Printing from Shortcut Menu in Explorer

WD97: Application.Help wdHelp Generates Run-Time Error

WD97: ArtWidth Sets Values in Points But Returns in Twips

WD97: AutoClose Macro Is Executed Before Document Is Closed

WD97: AutoClose Macro Prompts to Save When Document Is Closed

WD97: Bad Parameter Error with the AddPicture Method

WD97: Borders.Count Returns Five on a Selected Paragraph

WD97: BreakLink Method Deletes Object Reference

WD97: BuiltInDocumentProperties Returns Incorrect Page Count

WD97: Can't Open Selected Doc Using Dialogs FileFind Constant

WD97: Can't Run OCX Control After Converting to Inline Object

WD97: Can't Save with Embedded Control and Missing Reference

WD97: Can't View Embedded Control Event Code

WD97: Cancel Action Doesn't Function in Converted Macro

WD97: Cannot Record Macro to Set Options in Customize Dialog Box

WD97: Cannot Reference HeadingStyles Index with String Value

WD97: Cannot Switch to Navigation Pane in Document Map View

WD97: Cannot Trap FormFieldOptions Command on Double-Click

WD97: Cannot Trap Undefined Sub or Function Error

WD97: Cannot Undo Resizing of ActiveX Controls

WD97: Character Format Functions Ignore Leading, Trailing Spaces

WD97: Close Method in Macro Fails in Protected Form

WD97: Closing Document Window Does Not Close VB Editor

WD97: Code to Determine Whether Open Document Is a Template

WD97: Command to Display the Properties Dialog Box

WD97: Command to Display Version Number of Word

WD97: Commands on Web Toolbar Cannot be Recorded in a Macro

WD97: Compile Error If VB Code Doesn't Find Comments

WD97: Compile Error Passing Function Call

WD97: Compile, Syntax Errors Running Converted Macro in Word 97

WD97: Converted WordBasic Macro Doesn't Apply Outline Numbering

WD97: Converted WordBasic On Error Statements May Fail

WD97: Converting ActiveX to Picture Causes Invalid Page Fault

WD97: Creating a Password-Style Macro Dialog Text Box

WD97: Creating Hyperlink Deletes Object Reference

WD97: DefaultBorderColorIndex Does Not Apply Color First Time

WD97: Deleting Hyperlinks from Collection Does Not Delete All

WD97: Determining the Current Page and Section Number

WD97: DisplayAlerts=wdAlertsNone Fails to Suppress Print Error

WD97: Document Must Be Open to Change Properties by Macro

WD97: Documents Collection Fails When Document Is Closed

WD97: Email Profile Argument Does Not Exist For Document Routing

WD97: ErrMsg If AutoText String Exceeds 255 Characters

WD97: Error - Cyclic References Of Projects Not Allowed

WD97: Error Attempting to Copy or Rename Project Module

WD97: Error Creating Pre-Existing Custom Document Property

WD97: Error in Recorded Macro Using Previous/Next Row Commands

WD97: Error Inserting ActiveX Control

WD97: Error Recording Opening Template with WordBasic Macros

WD97: Error Using Border Constants with Font.Borders

WD97: Error: 'Can't Exit Design Mode...' After Adding Control

WD97: Errors Initializing Visual Basic Editor

WD97: Errors Setting Border LineWidths Via Macro Commands

WD97: Example Macro to Select or Go to a Table Cell

WD97: Example Macro to Send E-mail Using MAPI Commands

WD97: Extend Selection Toggled Off After Macro Completion

WD97: Extraneous Characters Returned with ViewFieldCodes On

WD97: FileCopy Statement Requires Destination File Name

WD97: FileFind Command Does Not Open Advanced Find Dialog Box

WD97: Float Over Text Option Unavailable Recording Macro

WD97: Form Fields Lose Text When Protected for Forms

WD97: GetAddress Method Without Name Argument Causes IPF

WD97: GetAllSettings Returns Type Mismatch

WD97: GetSpellingSuggestions Method Misses Repeated Words

WD97: GoBack Method Switches to Another Document

WD97: Grouped Floating Option Buttons Not Mutually Exclusive

WD97: Hang When Sending E-mail Twice In Rapid Succession

WD97: HasHorizontal/HasVertical Return True for Single Object

WD97: How to Add a Drop-down Menu to the Main Menu Bar

WD97: How to Automatically Update Fields

WD97: How to Break Out of an Infinite Macro Loop

WD97: How to Create a Macro to Change Printer or Fax Driver

WD97: How to Create and Display a Custom Dialog Box

WD97: How to Create Mutually Exclusive Check Boxes Using VBA

WD97: How To Create Ordinal (Legal) Dates In Form Fields

WD97: How to Exit Windows from Word Using ExitWindows

WD97: How To Hide The Full Screen Toolbar Using VB Code

WD97: How to Implement a Delay in VB for Applications

WD97: How to Keep OnEntry Macro from Running at Document Open

WD97: How To Perform Calculations With Dates And Times

WD97: How to Print a Field Result on the Last Page of a Document

WD97: How to Print a List of AutoCorrect Entries

WD97: How to Programmatically Insert an Excel Chart into Word

WD97: How to Protect VBA Code from Unauthorized Access

WD97: How to Rename, Copy, or Delete a Macro

WD97: How to Select the Current Paragraph Using VBA Code

WD97: How to Store and Retrieve Variables in Documents

WD97: How to Use Built-in (or Predefined) Bookmarks in Word

WD97: How to Use the Name...As Statement to Rename Files

WD97: How Word Converts Execute-Only Macros

WD97: Illegal Operation Opening Form Field Options Dialog

WD97: Incorrect Tab Settings Using WordBasic.FormatTabs

WD97: InlineShape.Reset Does Not Reset Size of Document Object

WD97: Inserting Linked Picture Results in Absolute Path

WD97: Inserting OLE Object in Header Opens OLE Application

WD97: InsertSymbol Result Not Translated Between Mac and ANSI

WD97: Invalid Page Fault Running ToolsGramSettings Command

WD97: Invalid Page Fault with WordBasic.EditLinks and \Sel

WD97: IPF Using Linked Image SourceName/SourcePath Property

WD97: Jumping to a Bookmark Located in a Header or Footer

WD97: Macro Does Not Insert AutoText Entries with Formatting

WD97: Macro Error When Opening Template with Toolbar

WD97: Macro Examples To Calculate Cells Across Multiple Tables

WD97: Macro Programming Resources

WD97: Macro Record Results In PlayBack Error Editing Objects

WD97: Macro Returns to View Used Before Opening Header

WD97: Macro to Calculate Number of Months between Two Dates

WD97: Macro to Cascade Open Document Windows

WD97: Macro to Count Number of Rows in a Table

WD97: Macro to Count Sections in a Document

WD97: Macro to Determine If a Form Field Exists

WD97: Macro to Determine If File Is Already Open

WD97: Macro to Determine the Number of Days in a Specified Month

WD97: Macro to Dock Toolbars That Are Beyond Screen Borders

WD97: Macro to Find Automatic (Soft) Page Breaks

WD97: Macro to Find Tables in Word Documents

WD97: Macro to Generate List of Available Fonts in Word

WD97: Macro to Increment Invoice Number To New Form Document

WD97: Macro to List Custom Tab Stops in a Paragraph

WD97: Macro to Move Insertion Point to Top of Current Page

WD97: Macro to Remove a Subdirectory in Word for Windows

WD97: Macro to Replace Font Formatting

WD97: Macro to Retrieve Text from Each Cell in a Table

WD97: Macro to Send a Word Document as Text or an Attachment

WD97: Macro to Test for an Existing Macro Name

WD97: Macro to Turn All Field Codes On and Off

WD97: Macros Not Listed After Creating New Document in Explorer

WD97: Macros to Move to Beginning, End of Paragraph

WD97: No Dialog With WordBasic.Dialog.ToolsOptionsGrammar

WD97: No Error Inserting Invalid Picture Via Macro

WD97: No Toolbars When Word Doc Activated from VB OLE Container

WD97: OLE Automation Fails When Using 'Word.Basic' Object

WD97: Para Mark Not Included In Selection.MoveRight(wdSentence)

WD97: Paragraph.Border.Linestyle Incorrect After Applying Shadow

WD97: Print # Statement Separates Fields with Spaces, Not Tabs

WD97: Problems with AutoExec Macro That Calls Macro in Add-in

WD97: Range.Text Length Includes 'End Of Cell' for Table Cell

WD97: Recorded Find Method Not Based on Language Formatting

WD97: Recorded Macro Switching to Outline View Causes Error

WD97: Recorded Macro to Insert AutoText from Add-in Fails

WD97: Reference Type Changed in Code, Not in Cross-reference

WD97: Retrieving Settings from Word Dialog Boxes Using OLE

WD97: Returned Height for Inline Shape Different from Specified

WD97: Returning Bookmarks Sorted by Location or Alphabetically

WD97: Returning Object Counts for Parts of a Document

WD97: Run-time Error '1280' Setting Custom Dictionary

WD97: Run-Time Error '4599' Using DDE to Internet Explorer 4.x

WD97: Run-Time Error '4605': Command Not Available

WD97: Run-time error '5880' Saving as HTML from VBA

WD97: Run-Time Error 1517 Running Converted Wordbasic Macro

WD97: Run-Time Error 5 Using Mid(), Left(), or Right() Function

WD97: Run-Time Error 5584 'Too Many DDE Channels Are Open...'

WD97: Run-Time Error Attempting to UnGroup Shape Objects

WD97: Run-time Error Getting Document Properties from Template

WD97: Run-Time Error If Style Doesn't Exist

WD97: Run-Time Error Setting Borders.InsideLineWidth

WD97: Run-Time Error Using Macro to Save File with Name

WD97: Run-time Error Using OLEFormat.Object with Linked Object

WD97: Run-Time Error Using VB Macro to Resize Document Window

WD97: Run-Tme Error Using True Parameter on NewTemplate Method

WD97: Sample Code to Increment Through a Document Line by Line

WD97: Sample Code to Scroll to Top or Bottom of Document Window

WD97: Sample Macro to Place a Border on a Single Cell in a Table

WD97: Sample Macro to Remove a Submenu From a Menu

WD97: Sample VB Code to Assign Clipboard Text to String Variable

WD97: Sample VB Code to Delete Built-In Style

WD97: Sample VB Code To Determine Text Box (or Text Frame) Link

WD97: Sample VB Code to Set, Retrieve .ini File or Registry Info

WD97: Sample VB Code to Set, Retrieve Summary Information

WD97: Selection Returns Question Marks Instead of Text

WD97: Selection.Cells.Shading Applies Shading to Selected Text

WD97: Setting Default Border Via Macro Not Reflected In Dialog

WD97: Shell Command Does Not Wait for Application to Finish

WD97: Simulating a Macro Pause in Word 97

WD97: Statistics Button Unavailable in File Summary Info Dialog

WD97: StoryRanges Does Not Return Text Box Text In Header/Footer

WD97: Tabstop Count Returns Incorrect Count

WD97: Temporary Parameter for Control Does Not Work.

WD97: Text from WordBasic.Input Command Truncated After Comma

WD97: TimeOut Argument Ignored by Some Dialog Boxes

WD97: Timing Problem Getting Object Via OLE Automation

WD97: Title Bar File Name Not Updated Using ActiveWindow.Caption

WD97: Troubleshooting Variables and Data Types

WD97: Two Similar Macro Errors Occur for Same Line of Macro Code

WD97: Type Mismatch Error Running Converted WordBasic Macro

WD97: Unable to Get Count of Table Rows or Columns

WD97: Unable to Run Macro w/Multiple Command Line Switches

WD97: Unexpected Name in 'File Name' Box After Macro Change

WD97: Unexpected Results with Find Object w/o Forward Argument

WD97: Updated WBODBC Files Available

WD97: Use Textbox Form Control to WorkAround 255 Character Limit

WD97: Using the Open Statement in Word VBA

WD97: VB Code to Check, Uncheck Word Dialog Box Check Boxes

WD97: VB Code to Switch a Document to Two-Page View

WD97: VB Macro Examples to Insert Text into a Document

WD97: VBA Macro to List All Documents Found in a Folder

WD97: VBA Macro to Print All Documents Found in a Folder

WD97: VBA Routines to Determine If Line or Document Is Empty

WD97: VerticalPercentScrolled Fails to Set the Correct Value

WD97: wdParagraph, ColumnSelectMode Will Not Select Text Column

WD97: WithEvents Fails Quit Event with No Documents Open

WD97: Word Count Appears Inaccurate

WD97: Word Count for Comments Number Incorrect

WD97: Word Hangs If VBA Adds Inline Control in Header or Footer

WD97: Word Solution Migration Information on the Web

WD97: Word Starts w/o ToolBars/Menus Using WindowState Property

WD97: Word Still Running After OLE Automation Session

WD97: WordBasic Object Returns Incorrect ASCII Number For Symbol

WD97: WordBasic.EditGoTo Does Not Go to Bookmark

WD97: WordBasic.Files$() Command Adds Quotation Marks to Result

WD97: WordBasic.MailMergeInsertFillin Fails to Prompt

WD97: WordBasic.ToolsCalculate Returns Incorrect Result

WD97: Working with Earlier Version WLLs/DLLs in Word 97

WD97: Writing Macro Code for VBA and WordBasic Branching

WD97:Can't Assign an Array to Explicitly Declared Array Variable

WD98: 'All Active Templates and Documents' Missing Macros

WD98: 'For Each...Next' Loop Gives Wrong Result with Endnotes

WD98: 'Help Topic Does Not Exist' for ActiveX Jump in Help

WD98: 'Replace With' Format Incorrect with Recorded Macro

WD98: 'String Too Long' Using Over 255 Characters

WD98: Acceptable Values of wdLineWidth Constant(in wdLineStyle)

WD98: Activewindow.Panes.Count Returns 1

WD98: Application.Help wdHelp Generates Run-Time Error

WD98: ArtWidth Sets Values in Points But Returns in Twips

WD98: AutoClose Macro Is Executed Before Document Is Closed

WD98: AutoClose Macro Prompts to Save When Document Is Closed

WD98: Bad Parameter Error with the AddPicture Method

WD98: Borders.Count Returns Five on a Selected Paragraph

WD98: BreakLink Method Deletes Object Reference

WD98: BuiltInDocumentProperties Returns Incorrect Page Count

WD98: Cancel Action Doesn't Function in Converted Macro

WD98: Cannot Record Macro to Set Options in Customize Dialog Box

WD98: Cannot Record Speak Selection or Pick Voice

WD98: Cannot Reference HeadingStyles Index with String Value

WD98: Cannot Switch to Navigation Pane in Document Map View

WD98: Cannot Trap FormFieldOptions Command on Double-Click

WD98: Cannot Trap Undefined Sub or Function Error

WD98: Changing PaperSize Using VBA Causes Run-time Error

WD98: Character Format Functions Ignore Leading, Trailing Spaces

WD98: Close Method in Macro Fails in Protected Form

WD98: Closing Document Window Does Not Close VB Editor

WD98: Code to Determine Whether Open Document Is a Template

WD98: Command to Display the Properties Dialog Box

WD98: Command to Display Version Number of Word

WD98: Commands on Web Toolbar Cannot be Recorded in a Macro

WD98: Compile Error If VB Code Doesn't Find Comments

WD98: Compile Error Passing Function Call

WD98: Compile, Syntax Errors Running Converted WordBasic Macro

WD98: Converted WordBasic Macro Doesn't Apply Outline Numbering

WD98: Converted WordBasic On Error Statements May Fail

WD98: CreateObject('Word.Application') Fails with Run-time Error

WD98: Creating a Password-Style Macro Dialog Text Box

WD98: Creating Hyperlink Deletes Object Reference

WD98: DefaultBorderColorIndex Does Not Apply Color First Time

WD98: Deleting Hyperlinks from Collection Does Not Delete All

WD98: Determining the Current Page and Section Number

WD98: Document Must Be Open to Change Properties by Macro

WD98: Error - Cyclic References Of Projects Not Allowed

WD98: Error 1005 Using WordBasic.EditLinks and \Sel

WD98: Error Using Border Constants with Font.Borders

WD98: Error Using PrintToFile with PrintOut Method

WD98: Errors Setting Border LineWidths Via Macro Commands

WD98: Example Macro to Select or Go to a Table Cell

WD98: Extend Selection Toggled Off After Macro Completion

WD98: Extraneous Characters Returned with ViewFieldCodes On

WD98: Float Over Text Option Unavailable Recording Macro

WD98: Form Fields Lose Text When Protected for Forms

WD98: Full Screen View Toolbar Is Hidden

WD98: GetAllSettings Returns Type Mismatch

WD98: GetSpellingSuggestions Method Misses Repeated Words

WD98: GoBack Method Switches to Another Document

WD98: HasHorizontal/HasVertical Return True for Single Object

WD98: How to Add a Drop-down Menu to the Main Menu Bar

WD98: How to Automatically Update Fields

WD98: How to Break Out of an Infinite Macro Loop

WD98: How to Control the Tabbing Order in a Form

WD98: How to Create and Display a Custom Dialog Box

WD98: How to Create Mutually Exclusive Check Boxes Using VBA

WD98: How to Create Ordinal (Legal) Dates in Form Fields

WD98: How to Determine the Number of Days Between Two Dates

WD98: How to Hide the Full Screen Toolbar Using VB Code

WD98: How to Implement a Delay in VB for Applications

WD98: How to Keep OnEntry Macro from Running at Document Open

WD98: How to Perform Calculations with Dates and Times

WD98: How to Print a Field Result on the Last Page of a Document

WD98: How to Print a List of AutoCorrect Entries

WD98: How to Programmatically Insert an Excel Chart into Word

WD98: How to Store and Retrieve Variables in Documents

WD98: How to Use Built-in (or Predefined) Bookmarks in VBA

WD98: How to Use the Name...As Statement to Rename Files

WD98: Incorrect Tab Settings Using WordBasic.FormatTabs

WD98: InlineShape.Reset Does Not Reset Size of Document Object

WD98: Insert Object Fails When Playing Back Recorded Macro

WD98: Inserting OLE Object in Header Opens OLE Application

WD98: InsertSymbol Result Not Translated Between Mac and ANSI

WD98: Int'l Characters Do Not Convert from WordBasic Macros

WD98: Jumping to a Bookmark Located in a Header or Footer

WD98: Macro Error When Opening Template with Toolbar

WD98: Macro Examples To Calculate Cells Across Multiple Tables

WD98: Macro to Count Number of Document Paragraphs and Lines

WD98: Macro to Determine if a Form Field Exists

WD98: Macro to Determine If Insertion Point Is in a Table

WD98: Macro to Dock Toolbars That Are Beyond Screen Borders

WD98: Macro to Find Automatic (Soft) Page Breaks

WD98: Macro to Remove a Subdirectory in Word for Windows

WD98: Message Box Buttons Appear in the Wrong Order

WD98: Problems with AutoExec Macro That Calls Macro in Add-in

WD98: Recorded Macro Switching to Outline View Causes Error

WD98: Recorded Macro to Insert AutoText from Add-in Fails

WD98: Recording Turning Off 'Same As Previous' Fails On Playback

WD98: Reference Type Changed in Code, Not in Cross-Reference

WD98: Run-time error '5880' Saving as HTML from VBA

WD98: Run-Time Error 5584 'Too Many DDE Channels Are Open...

WD98: Sample Code to Scroll to Top or Bottom of Document Window

WD98: Sample Macro to Remove a Submenu from a Menu

WD98: Sample VBA Code to Set, Retrieve Summary Information

WD98: Tabstop Count Returns Incorrect Count

WD98: Text from WordBasic.Input Command Truncated After Comma

WD98: Type Mismatch Error Running Converted WordBasic Macro

WD98: Use TextBox Control to Work Around 255 Character Limit

WD98: Using the Open Statement in Word VBA

WD98: VBA Routines to Determine If Line or Document Is Empty

WD98: Visual Basic Example to Print Current Page

WD98: WindowStyle Argument of Shell Function Ignored

WD98: WithEvents Fails Quit Event with No Documents Open

WD98: Writing Macro Code for VBA and WordBasic Branching

WE1182: 'Customizing Menu Bars, Menus, and Menu Items'

WE1277: XL7:Visual Basic Equivalents for Lotus Macro Commands

Window Class Names for the Office 97 Applications

XL AppNote: Sample Code for Controlling Dialog Boxes (WE1162)

XL Err Msg: 'Not Enough Stack Space to Run Macro'

XL Err Msg: EditBox Does Not Have LockedText Property

XL Err Msg: Unable to Set the Text Property of Editbox Class

XL Err Msg:'Cannot Find Macro' Running Macro from Object

XL OLE Automation: Workbook Hidden Using GetObject Function

XL: 'Can't Find Project or Library' When You Run a Macro

XL: 'Cannot Access' Error Saving File to 'C' on a Macintosh

XL: 'Cannot Jump to 'Application' Because it is Hidden'

XL: 'Cannot Open Add-In' Error When You Run a Macro

XL: 'Compile Error' Running Macro That Changes Margins

XL: 'Excel 7.0;' Is an Invalid Database Type in DAO

XL: 'Formula Is Not Valid' Changing Label Text with FORMULA()

XL: 'Formula Not Valid' Converting or Assigning Valid Formula

XL: 'Invalid Procedure Call' with SendKeys Statement

XL: 'Out of Memory' Message Using the OpenText Method

XL: 'Out of Stack Space' Error Running Sub Procedure

XL: 'Overflow' Error Running Procedure with Math Calculation

XL: 'User-Defined Type Not Defined' Error Message Using DAO

XL: 'For Each Item in List' Doesn't Work

XL: ActivatePrevious Method Uses Z-Order Defined by User

XL: ActiveCell.FormulaArray Doesn't Enter Formula As Array

XL: All PageSetup Settings Are Recorded into Macro

XL: Application.Interactive Value Not Reset When Macro Stops

XL: Arc/Block Arc Adjusted Incorrectly When You Run Macro

XL: ATP Functions Return Error When Created Through Automation

XL: Auto-Open Macro to Select Right Cell After Pressing ENTER

XL: Auto_Open Macro Fails to Hide Floating Toolbars

XL: Automation Example: Controlling MS Excel from VB

XL: Borders Method Applies Inconsistent Format

XL: Branching to Other Sections of Code with GoTo and Call

XL: Calculating Depreciation with the Production Method

XL: Calculating Elapsed Time for a Visual Basic Procedure

XL: Can Change Protected Document's Properties with VB Macro

XL: Can't Add Object to Sheet Protected as UserInterfaceOnly

XL: Can't Change Size or Position of Object in Custom Dialog

XL: Can't Display Dialog Box from VBA Macro If Workbooks Hidden

XL: Can't Set Property of Outline Class With Object Selected

XL: Can't Set Value Property in For Each with Variant Type

XL: Can't Specify Number of Digits with Fix() or Int()

XL: Can't Step Through Excel 4.0 Macro If Dialog Box Visible

XL: Can't Trap No or Cancel in 'Replace Existing' Dialog Box

XL: Can't Use ActivateMicrosoftApp Method to Activate Excel

XL: Can't Use BottomRightCell or TopLeftCell with Edit Box

XL: Can't Use xlConstant Names in Variables in VB Code

XL: Canceling OnTime Macro When Time Argument Is Volatile

XL: Cannot Define Name If Active Sheet Protected

XL: Cannot Enable or Disable Built-in Commands with a Macro

XL: Cannot Set Zoom Property of PageSetup Class

XL: Cannot Use Array as Source Argument with SeriesCollection

XL: Cannot Use Array of Data Points with Extend Method

XL: Cannot Use ERASE in a Batch File Run by SHELL Function

XL: Cannot Use MS-DOS Core Commands From Shell Function

XL: Cannot Use Page Setup in Macro If No Printers Installed

XL: Caption Property of Menu Contains Ampersands

XL: Cells.Find Returns Error When No Match Found

XL: Changing an Integer to a Microsoft Excel Serial Number

XL: Changing an Integer to an Excel Serial Number

XL: Changing the Date or Time Format in a Header or Footer

XL: Changing the Paper Source Using SendKeys

XL: ChDir May Fail When Changing to a Root Directory

XL: Clarification of Caller Property Help

XL: Client Not Updated with Multiple Instances of Excel

XL: Closing Excel from Workbook Control Menu Causes GP Fault

XL: Control Block Statement Error Messages

XL: Controlling Alerts and Updating in MS Excel OLE Server

XL: Controlling Appearance of Mouse Pointer Within Macro

XL: Controls in Dialog Box May 'Snap' to Preset Values

XL: Conversion to Base x Function Not Available

XL: Copy of Recorded Macro Code Doesn't Work Correctly

XL: CopyFromRecordset Method Does Not Return Field Headings

XL: Counting Cells That Contain Formulas, Text, or Numbers

XL: Counting Occurrence of a Character in Selection

XL: CreateObject Function Starts Invisible Instance of Excel

XL: Creating a Dynamic List in a Custom Dialog Box

XL: Creating a Linked Directory List Box

XL: Creating a PAUSE Button in Visual Basic for Applications

XL: Creating Macros for Different Language Versions

XL: Custom Function Returns Incorrect Value/Appears to Hang

XL: Custom Function to Express Degree as Fractions of Degrees

XL: Custom Function to Transpose Nonadjacent Range

XL: Data Map Objects Limited to RefreshMap Command

XL: Data Returned to Wrong Row Using SQLBind

XL: Date Returned in a Macro Is Four Years Too Early

XL: Dates Inserted by Recorded Macro May Be in Wrong Century

XL: DDE Poke to Microsoft Excel Workbook Fails

XL: DDEREQUEST May Truncate Results

XL: Deactivate Macro Doesn't Run When You Open HTML Document

XL: Default Property/Methods for Objects in Visual Basic

XL: DefType Statements Change If Workbook Used on New Platform

XL: Deleted Project or Library Listed Twice In References

XL: Determining the Number of Dimensions in an Array Variable

XL: Determining Which DLLs Are Registered

XL: Determining Which Items Are Selected in a List Box

XL: Dialog Box Show Method Fails with Reference Type Edit Box

XL: Dialog Constants That Do Not Have an Interactive Dialog

XL: Dialogs(xlDialogFont) Changes Normal Style

XL: Disabling Microsoft Excel Control Menu Commands

XL: Displaying Several Dialog Boxes Without Looping

XL: Distinguishing Sheet Types with Visual Basic Macro

XL: DocErr: VB for Apps Sub Example Incorrect

XL: Drawing Objects Behave Differently When Clicked

XL: Edit Code Fails When Object Formula Passes Parameters

XL: EnableCancelKey Property Ignored in Printing Procedure

XL: EnableSelection Property May be Overridden

XL: Err Msg: Error in Procedure Causes 'Cannot Find Procedure'

XL: Error Calling Macro Contained in Open Add-In

XL: Error Creating OLE Automation Object with Microsoft Excel

XL: Error Getting the Value of a Name in Visual Basic

XL: Error Handler Ignored with Break On All Errors Selected

XL: Error If MarkerBackgroundColorIndex Property Incorrectly Set

XL: Error Inserting a Module Sheet in a Workbook

XL: Error Message: FUNCRES.XLA Is Not a Valid Add-in

XL: Error Opening File That Refers to Shortcut

XL: Error Programmatically Accessing Data Series on Chart

XL: Error Running Inserted Text File Macro from Another Macro

XL: Error Running Macro with Reference to XLODBC.XLA File

XL: Error Running Solver Macro with Non-Comma List Separators

XL: Error Setting Type Property of Trendline with Macro

XL: Error Trapping with Visual Basic for Applications

XL: Error Using Array with Range Method

XL: Error Using SendKeys in VB with Shortcut Key Assigned

XL: Error Using VB to Insert Column in Filtered Range

XL: Error When Macro Closes Its Own Workbook

XL: Error When You Concatenate String and Numeric Values

XL: Error with Evaluate with More Than One Custom Function

XL: Error with HasLegend Argument of ChartWizard Method

XL: Errors Changing Chart Axis Value Scale in Macro

XL: Evaluate Method Affects Volatility of Custom Functions

XL: EVALUATE() Function with INDIRECT() Returns #REF! Error

XL: Example of Using API Calls in Multi-Platform Macros

XL: Excel 4.0 Dialog Box Causes Error in Excel 5.0

XL: Excel 4.0 Macro Sheets Not Included in Worksheets Collection

XL: Excel 4.0 Menus Option Setting Not Saved

XL: Excel Stops After Specifying Conditional Format

XL: Executing SQL Server Stored Procedure Using SQLRequest

XL: Finding Graphic Objects Within a Range with TopLeftCell

XL: Finding Open Applications that are DDE Capable

XL: FitToPagesWide or FitToPagesTall Doesn't Affect PageSetup

XL: Focus Method Doesn't Set Focus to Correct Dialog Control

XL: FOR Behaves Differently in Visual Basic than in XLM Macro

XL: For Each Loop to Determine If an Excel Workbook Is Open

XL: Formatted Text (.prn) Limited to 240 Characters Per Line

XL: Formatting Name of Months in All Capital Letters

XL: Formula for EFFECT Function Incorrect in Help

XL: Function Name Can't be Same as Module Name

XL: Function to Compute Average Without High and Low Values

XL: Function Using ActiveCell Property Returns Incorrect Result

XL: GET.DOCUMENT(67) Always Returns TRUE

XL: GetCustomListNum Returns Unexpected List Number

XL: GetOpenFilename Method Is Different

XL: Getting Windows Status Information from Windows API

XL: Goal Seek Records Incorrectly with Relative References

XL: Goto Method Fails When Custom Dialog Box Visible

XL: Grouped Drawing Objects Run Separate Macros

XL: Hiding Button Objects with Visual Basic for Applications

XL: Hiding Nonadjacent Rows May Hide Other Rows

XL: How to Add a New Category to Function Category List

XL: How To Add a Sheet After Last Sheet in a Single Action

XL: How to Add Data to a Drop-Down or List Box

XL: How to Add MS Excel 5.0 Dialog Sheet to a Workbook

XL: How To Add Shortcut Key to Menu Item Using Chr Function

XL: How to Add the Workbook Path to the Footer

XL: How to Append an Excel Worksheet to a Database Using DAO

XL: How to Avoid 'Save Changes?' When You Close a Workbook

XL: How to Avoid the Error 'Can't Find Project or Library'

XL: How to Call a Macro Repeatedly on a Fixed Time Interval

XL: How to Change Arabic Page Numbers to Roman Numerals

XL: How to Check Number of Records Returned in an AutoFilter

XL: How to Check Spelling for Worksheet Objects Only

XL: How to Close All Workbooks but One with Visual Basic Macro

XL: How to Compare Data in Two Columns for Duplicates

XL: How to Concatenate DDE to MSQuery Statements

XL: How to Continue a VB Statement from one Line to the Next

XL: How to Control Built-In and Custom Menus with Visual Basic

XL: How to Control the AutoFilter with a Macro

XL: How to Convert a Numeric Value into English Words

XL: How to Copy One of Each Record Type to Another Worksheet

XL: How to Copy Text to TextBoxes Using the Characters Method

XL: How to Copy the Text Within a Text Box to a Cell

XL: How to Count Blank Cells in a Specified Range

XL: How to Count Rows Displayed After Data Has Been Filtered

XL: How to Create a Chart with Discontiguous Ranges

XL: How to Create a Dynamic Dialog Box

XL: How to Create a Dynamic Named Range

XL: How to Create a Global User-Defined Function

XL: How to Create a Macro That Counts Text Notes (Cell Notes)

XL: How to Create a Monthly Calendar

XL: How to Create a Temporary Message Box While Macro Runs

XL: How to Create an Auto_Open Macro to Show Data Form Dialog

XL: How to Create and Use an Auto_Close Procedure

XL: How to Create Macro That Opens Multiple Selected Files

XL: How to Create MS Access Database from MS Excel Using DAO

XL: How To Create Random Integers Between Two Given Values

XL: How to Create Yes and No Buttons for a Custom Message Box

XL: How to Delete and Restore a Menu That Has a Submenu

XL: How to Determine How Many Pages Will Be Printed

XL: How to Determine If a File Is Read-Only

XL: How to Determine if a Variable Is an Array

XL: How to Determine If a Workbook or a Worksheet Is Protected

XL: How to Display the Open and Save As Dialog Boxes

XL: How to Display Top 10 Records With a Macro

XL: How to Enter a Second Line in a Message Box

XL: How to Find Visual Basic for Applications Help

XL: How to Hide Sheets and Use xlVeryHidden Constant in a Macro

XL: How to Identify and Remove PLDT (Laroux) Macro Virus

XL: How to Keep Unattached Text Aligned to a Data Series

XL: How to Make Spinner Whose Minimum Value Is Less Than Zero

XL: How to Make Sure That Only Numbers Are Entered in a Column

XL: How to Obtain the SQL Statement for a PivotTable

XL: How to Open a Copy of a Template in MS Excel 7.0, 97

XL: How to Play a Sound Note Using Visual Basic for Applications

XL: How to Play a Warning Sound If Critical Value Is Exceeded

XL: How to Play Sounds Using Visual Basic for Applications

XL: How to Populate an Array with a Discontiguous Range

XL: How to Programmatically Save a File to a Network Drive

XL: How to Put the Folder Contents into a Spreadsheet

XL: How To Retrieve a QueryDef from MS Access Using DAO

XL: How to Retrieve a Table from Access into Excel Using DAO

XL: How to Retrieve Records into Specific Columns Using DAO

XL: How To Retrieve the Results of a Parameter Query Using DAO

XL: How to Return Data from a Dialog Box to a Worksheet

XL: How to Return the Nth Word from a String

XL: How to Run a Macro When Certain Cells Change

XL: How to Run a Sort When a Calculation Occurs

XL: How to Run a WordBasic Macro from an MS Excel Macro

XL: How to Scroll Window Views from Object to Object

XL: How to Search All Worksheets in a Workbook

XL: How to Select Cells/Ranges Using Visual Basic Procedures

XL: How to Select Ranges Using VB for Apps (Novice Examples)

XL: How to Select the Current Region Minus the First Row

XL: How to Set Page Setup Attributes for More Than One Sheet

XL: How to Set Print Area to Range with Defined Name

XL: How To Share a Custom AutoFill List

XL: How to Simulate a PivotTable with No Summarization

XL: How to Sum a Range of Cells Based on a Number Format

XL: How to Sum Ranges Using Visual Basic for Applications

XL: How to Temporarily Hide a Dialog Box

XL: How to Use 'On Error' to Handle Errors in a Macro

XL: How to Use a Custom Dialog Box for Data Entry

XL: How to Use a Custom Function in Another Workbook

XL: How to use a Macro to Enter Cell Note Text in a Text Box

XL: How to Use a Toolbar Button to Open a File Indirectly

XL: How to Use a VBA Macro to Sum Only Visible Cells

XL: How to Use a Visual Basic Macro to Create a Bubble Chart

XL: How to Use DAO in Excel Without Referencing DAO Library

XL: How to Use DAO to Create a New Microsoft Excel Workbook

XL: How to Use Dynamic Arrays in a Macro

XL: How to Use Input Boxes with Visual Basic for Applications

XL: How to Use the DataEntryMode Property

XL: How to Use the Menu Editor

XL: How to Use the MultiPage Control in a UserForm

XL: How to Use the TabStrip Control in a UserForm

XL: How to Work with Random Access Files

XL: Increment Relative References by More Than One Cell in VBA

XL: Infinite Loop If OLE Automation Server Busy

XL: Inserting and Formatting Text in Headers and Footers

XL: IPF/Hang Closing Workbook Containing BeforeClose Macro

XL: LibraryPath Includes Trailing Separator on Macintosh

XL: Limitations of Passing Arrays to Excel Using Automation

XL: Macro Cannot Scroll Chart Windows

XL: Macro Code to Check Whether a File Is Already Open

XL: Macro Does Not Open Report Manager Add-In as Expected

XL: Macro Doesn't Function on Multiple Sheets in Group Mode

XL: Macro Example to Return Item from Worksheet Control

XL: Macro Examples Using XLODBC Functions

XL: Macro Function to Determine If Environment Is 32-bit

XL: Macro On Workbook Is Not Defined Error While Updating Links

XL: Macro That Changes Cell Dimensions on Multiple Sheets Fails

XL: Macro to Add a Number to a Selected Cell

XL: Macro to Add Labels to Points in an XY (Scatter) Chart

XL: Macro to Append Text from One Text File to Another

XL: Macro to Automatically Save Personal.xls Without Prompt

XL: Macro to Change the ToolTip Name for Custom Toolbar

XL: Macro to Check for Page Breaks on Worksheet

XL: Macro to Convert Column Numbers to Column Letters

XL: Macro to Copy All Range Names

XL: Macro to Count the Number of Procedures on a Module Sheet

XL: Macro to Create a Defined Name for the Current Selection

XL: Macro to Delete #REF! Defined Name Errors in a Workbook

XL: Macro to Delete Blank Rows and Columns in a Lotus File

XL: Macro to Delete Defined Names with Links

XL: Macro to Delete Every Other Row

XL: Macro to Delete Link Between List Box and Range of Cells

XL: Macro to Determine If a Button is on a Toolbar

XL: Macro to Determine If Excel Is Open for In-Place Editing

XL: Macro to Extract Data from a Chart

XL: Macro to Fill a List Box with Multiple Ranges

XL: Macro to Import a Text File into Existing Worksheet

XL: Macro to Insert a Blank Row on Every Other Row of Sheet

XL: Macro to Insert an Object at the Active Cell

XL: Macro to Insert Data from a List Box into the Active Cell

XL: Macro to Link a Range of Cells in Word

XL: Macro to Loop Through All Files in a Folder (Directory)

XL: Macro to Loop Through All Worksheets in a Workbook

XL: Macro to Loop Through Check Boxes Inside a Group Box

XL: Macro to Loop Through Range and Act Based on Cell Value

XL: Macro to Open All Linked Workbooks

XL: Macro to Open the Most Recently Used File

XL: Macro to Print a Group of Files Located in Same Folder

XL: Macro to Print All Embedded Charts on a Worksheet

XL: Macro to Print Notes/Comments as Separate Printout

XL: Macro to Remove 0% Labels from a Pie Chart

XL: Macro to Remove Hidden Names in Active Workbook

XL: Macro to Restore Tab Split Box to Default Position

XL: Macro to Return Exact Visible Range in Points

XL: Macro to Search for Cell Formats: Font, Border, and Interior

XL: Macro to Select all Data on a Worksheet

XL: Macro to Select Every nth Row/Column

XL: Macro to Shade Every Other Row in a Selection

XL: Macro to Suppress an Error Value Returned by a Formula

XL: Macro Virus Protection Alert May Not Appear

XL: Macro with OnEntry or ON.ENTRY() Not Activated

XL: Macros to Alter Workspace Based on Active File

XL: Macros to Disable Keyboard Input

XL: Macros to Return Windows and System Directories Paths

XL: Macros to Set Row Height and Column Width

XL: Macros to Sort Tabs in the Active Workbook

XL: Manually Recalculating a Single Cell or Range

XL: Methods and Properties Used to Create OnEvent Procedures

XL: Methods to Use Custom Functions with Varying Arguments

XL: Microsoft Excel Hangs If Macro Contains PageBreak Property

XL: Min and Max Functions do not Work Properly With Arrays

XL: Modifying Access Databases from Excel Using DAO QueryDefs

XL: Modules Cannot Be Printed in Color

XL: Moving Custom Dialog Box Leaves a Copy of Dialog on Screen

XL: MsgBox Function has 255 Character Limit

XL: Named Arguments Are Not Supported with DAO

XL: Names.Add May Get Recorded Twice

XL: New Balloon That Contains Picture May Not Be Displayed

XL: No Error Message with Incorrect Range Reference Syntax

XL: No Resume Button or Key Command for Paused .XLM Macro

XL: No Visual Basic Method for SET.UPDATE.STATUS

XL: Non-Loop Array Transfer to a Worksheet

XL: Not All Worksheet Functions Supported as Application

XL: OLE Automation Dialog Box Redrawn Incorrectly

XL: OLE Automation Err Msg: Method Not Applicable

XL: OLE Automation, Can't Use Named Arguments in Visual Basic

XL: OnData/ON.DATA Function Doesn't Work With Object Links

XL: OnEntry Macro to Create a Running Total

XL: OnKey Method Ignored When a Dialog Box Is Being Displayed

XL: Open Subroutines Run Before Referenced Subroutines

XL: OpenDatabase Method Prompts for User Input

XL: OpenLinks Method Fails When Recorded Macro Is Run

XL: Option Base with User-Defined Type Incorrect in Help Topic

XL: Order Data Is Entered Changes Results of STDEV() Function

XL: PageBreak Property Does Not Work as Expected

XL: Passed Strings Greater Than 255 Characters Are Truncated

XL: Passing Variables in Visual Basic for Applications Macros

XL: Pointer is an Hourglass When You Display a Message Box

XL: PrintArea Property Needs Dollar Signs

XL: Printing Entire Workbook Prints Hidden Sheets

XL: Problems Using Show Method to Open Dialog Sheets

XL: Procedure to Export Text File with Comma AND Quote Delimiter

XL: Prompt to Save Workbook After Using GetObject Function

XL: Protect Method Fails When Module Is Hidden

XL: Public and Module-Level Variables Lost with SaveAs Method

XL: Public Variables May Be Lost When You Copy a Worksheet

XL: Public/Global Variables Not Maintained After Error

XL: Put Statement Allows Writing Beyond End of File

XL: Q? About Excel Macro/Laroux Macro Virus

XL: Range Command in Macro Selects Cells from Entire Range

XL: Range Does Not Have Writable Entire Row/Column Property

XL: Range.EntireRow May Return Incorrect Result

XL: Recently Used File List Disabled

XL: Recorded Macro Fails to Insert New Data to Chart

XL: Recorded Macro to Edit Links of Chart Doesn't Work

XL: Recorded Macro to Replace All on Grouped Sheets Doesn't Work

XL: Recording a Visual Basic Macro in an External Module

XL: RemoveItem and RemoveAllItems Methods May Not Work

XL: Removing the Control Menu and Application Window Controls

XL: Replacing Text in Cell Notes

XL: Resetting the Last Cell Fixes Memory/Printing Problems

XL: Resources for Programming with Visual Basic for Applications

XL: Restoring Settings in Options Dialog After Running Macro

XL: Returning a Value from a List Box in Visual Basic

XL: Returning Address of the Cell with Largest or Smallest Value

XL: Returning Multiple Values from a Custom Function

XL: Row and Column Range Converted to Two-Dimensional Array

XL: Run-time Error '424': Object Required Using DAO

XL: Run-Time Error 1004 Setting Focus to Dialog Sheet

XL: Running a Microsoft Access Macro from Microsoft Excel

XL: Running a Microsoft Project Macro from Microsoft Excel

XL: Running Subroutines and Macros from Visual Basic

XL: Sample Code Demonstrating DDEPoke and POKE()

XL: Sample Macro Code to Change Case of Text

XL: Sample Macro Code to Loop Through a List on a Worksheet

XL: Sample Macro That Won't Allow User to Cancel Dialog Box

XL: Sample Macro to Add Check Marks to Custom Menu Commands

XL: Sample Macro to Add or Place Object in Relation to a Range

XL: Sample Macro to Display File Name and Path

XL: Sample Macro to Insert/Delete Rows on Multiple Sheets

XL: Sample Macro to Retrieve Defined Name of the ActiveCell

XL: Sample Macro to Set Print Titles in Active Worksheet

XL: Sample Macro to Sort List Based on Custom Sort Order

XL: Sample Visual Basic Code to Create Color Index Table

XL: Sample Visual Basic Procedure to Print Range of Cells

XL: Save Method Saves Read-Only File to Current Directory

XL: SaveAs Method for Worksheet Object Doesn't Save Single Ply

XL: Scrolling Through List Box on Worksheet Runs Attached Macro

XL: SendKeys Method Runs Before Built-In SendKeys Statement

XL: Setting Default Save As to Microsoft Excel 4.0 File Format

XL: Setting Status Bar Text and ToolTips for Toolbar Buttons

XL: Sheets Hidden with XlVeryHidden Can Be Viewed in Word

XL: Shell Function Doesn't Accept Built-in Constants

XL: ShowDataForm Method Fails If Data Can't Be Found

XL: Some Window Properties Only Affect Active Worksheet

XL: Sorting Alphanumeric Text as Numeric Values

XL: Sounds Not Converted with Cell Notes

XL: SQL.REQUEST and SQLREQUEST Function Syntax Differences

XL: SQLExecQuery and SQLRequest Limited to 255 Characters

XL: SQLRetrieve Defines Field Names on Active Workbook

XL: SQLRetrieve Fails Using Oracle 7.0 ODBC Driver

XL: Strange Value for PageSetup.FirstPageNumber

XL: Syntax Error with Recorded ExecuteExcel4Macro Method

XL: Text Concatenation Causes Error in Visual Basic Module

XL: TEXT(MONTH(NOW()),'mmm') Always Returns 'Jan'

XL: TREND Function Works Differently in Functions Than in Macros

XL: Type Mismatch: Array or User Defined Type Expected

XL: TypeNum 3 Not Supported By Most ODBC Data Sources

XL: Unable to Hide Full Screen Toolbar Through a Procedure

XL: Unable to Set Formula Property of a Dialog Sheet Button

XL: Unexpected Results with Mixed Text

XL: Unlocked Cells Not Underlined With Protection Enabled

XL: Update Remote References Option Selected by Default

XL: User-Defined Function to Put Sheet Name in a Cell

XL: Using a Visual Basic Macro to Sort Arrays in Microsoft Excel

XL: Using a Worksheet Function in a Visual Basic Macro

XL: Using Application.Match to Locate Date Values on a Worksheet

XL: Using DAO to Join Tables of Different Formats

XL: Using Left, Right, Mid and Len in Visual Basic

XL: Using Paste Method Without Moving Active Cell

XL: Using Solver.Ok from VBA Requires R1C1 Style Referencing

XL: Using SQLOpen with User ID and Password

XL: Using SQLRetrieve to Return Data to a Protected Worksheet

XL: Using the DDERequest Method for System Information

XL: Using the Imp Operator for Binary Comparison

XL: Using VBA Code to Make a Spinner Display Noninteger Values

XL: Using Visual Basic to Create a Chart Using a Dynamic Range

XL: Using Visual Basic to Exit Windows From Within Excel

XL: Using Visual Basic to Multiply Cell Contents

XL: Using Visual Basic to Return Screen Elements

XL: VB Code for Working with List Box Items in a Dialog Box

XL: VB Code to Automatically Set Min and Max Scale for Y-Axis

XL: VB for Apps Procedure to Open or Activate a Workbook

XL: VB Macro to Align Worksheets with Top Worksheet

XL: VB Macro to Change Between Relative/Absolute References

XL: VB Macro to Sort Custom List on First and Second Keys

XL: VB Procedure to Emulate Find Command

XL: Verifying the Value of a Check Box

XL: Visual Basic Activate Method Unhides Hidden Windows

XL: Visual Basic Add Method Fails If Object Already Exists

XL: Visual Basic and the Excel Version 4.0 Macro Language

XL: Visual Basic Code to Resize an Application Window

XL: Visual Basic Code to Use Instead of DIRECTORIES()

XL: Visual Basic Example for Validating Data on Entry

XL: Visual Basic Example of Spinner Use on a Date

XL: Visual Basic Example to Delete Blank Rows

XL: Visual Basic Example to Disable All Shortcut Menus

XL: Visual Basic Example to Open a RecordSet Using DAO

XL: Visual Basic Example to Play an AVI File

XL: Visual Basic Example to Retrieve Value from Last Cell

XL: Visual Basic Example to Total Rows and Columns in an Array

XL: Visual Basic Example Using BuildSQL

XL: Visual Basic Example Using If and Case Statements

XL: Visual Basic Example Using ODBCLogon

XL: Visual Basic Example Using the Verb Method

XL: Visual Basic Examples Using DDE

XL: Visual Basic Function to Calculate Cross Product

XL: Visual Basic Function to Format Complex Numbers

XL: Visual Basic Macro Examples for Working with Arrays

XL: Visual Basic Macro to Concatenate Columns of Data

XL: Visual Basic Macro to Convert Lotus Files to MS Excel

XL: Visual Basic Macro to Convert Number to a Different Base

XL: Visual Basic Macro to Determine Which Button Was Selected

XL: Visual Basic Macro to Dynamically Populate a List Box

XL: Visual Basic Macro to Hide and Restore All Toolbars

XL: Visual Basic Macro to List Circular References

XL: Visual Basic Macro to Save All Open Workbooks in MS Excel

XL: Visual Basic Macro to Show Active Cell's Range Names

XL: Visual Basic Macros That Add or Remove Hidden Apostrophes

XL: Visual Basic Macros to Add or Delete a Custom Menu

XL: Visual Basic Module to Create Gantt Chart

XL: Visual Basic Nested Case Statement Example

XL: Visual Basic Procedure to Change the Standard Font

XL: Visual Basic Procedures for Julian Date Calculations

XL: WordBasic Command FileExit Generates An Error

XL: Workbook File Size Increases While Editing Procedure

XL: Working with Sequential Access Files

XL:Can't Use PrintOut Method When Custom Dialog Box Is Visible

XL:Custom Functions Can't Change Microsoft Excel Environment

XL:Permission Denied, Error 70 When You Use FileCopy Statement

XL:Sample Macro to Find Duplicate Entries in a Row

XL:Unable to View or Retrieve Cell Note on Protected Worksheet

XL5 Err Msg: 'OLE Automation Error' or 'Out of Memory'

XL5 Err Msg: 'OLE Automation Method Did Not Return a Value'

XL5: 'Error in Formula' Inserting FormulaArray in Visual Basic

XL5: Application.OperatingSystem Returns Incorrect Value

XL5: Calculate Method for Range Object Fails on Protected Sheet

XL5: Can't Define Name with Same Name as a Subroutine

XL5: Can't Get or Set Properties of X Axis in XY Scatter Chart

XL5: Can't Print Collated Copies

XL5: Can't Run Macros That Use File Functions Add-in Functions

XL5: Can't Select Label Attached to Filled Radar Series

XL5: Can't Set ColorIndex Property of Style Class

XL5: Can't Use Horizontal Array for List Box/Drop-Down Input

XL5: Can't Use Replace Command to Search for Blank Cells

XL5: Cannot Print Multiple Copies to DeskJet 500C/550C Driver

XL5: Cells to the Right of Data Table Do Not Calculate

XL5: Change to 'Prompt Before Saving' Check Box Not Saved

XL5: Continue Macro Execution While Playing a .WAV File

XL5: Controlling Memory Used by PivotTable RAM Cache

XL5: Creating a Masked Password Dialog Box in Visual Basic

XL5: Custom Menu Commands Displayed in Incorrect Order

XL5: Drag to Replace in Recorded Macro Returns Invalid Code

XL5: Error in Help File for SQLREQUEST Function

XL5: Error Using Statusbar Argument for Add Method

XL5: Error:'Unable to Set Visible Property PivotItem class'

XL5: Example for SpecialCells Method Incorrect

XL5: Excel and Visual Basic Library Files (.OLB) Available

XL5: Getting Windows Status Information from Windows API

XL5: GP Fault If SQLRequest Results Used in Custom Function

XL5: GP Fault in VBA.DLL Opening File with Deleted Auto_Open

XL5: GP Fault Using Intersection of Named Ranges in Function

XL5: GPF/Type 11 Error Adjusting Margins While Recording Macro

XL5: How to Display Hourglass Pointer Running Macro in Dialog

XL5: How to Manipulate Macro Operation With Key Strokes

XL5: Incorrect Results or Crash Returning Data Using API

XL5: Incorrect Use of 'Is' Function Causes GP Fault

XL5: Macro Assigned to an Edit Box May Not Run

XL5: Macro Cannot Determine If Sheet Is xlVeryHidden

XL5: Macro Fails If Optional Argument Uses Integer Data Type

XL5: Macro to Find Directory in WIN.INI for an Application

XL5: Macro to Test if Windows Application Is Loaded

XL5: Macro to Toggle spooler= Line of WIN.INI

XL5: Name Defined Incorrectly If Sheet Name Contains Space

XL5: No Line.Print() Function Equivalent in Visual Basic

XL5: ODBC Examples from NT Help File Using NWind Data Source

XL5: OLE Automation Error Using Quit Method with GetObject

XL5: OLE Automation Example: Running Macro in Visual Basic 3.0

XL5: OnWindow Property Does Not Work with Info Window

XL5: Recorded AutoFit Selection Changes Entire Row or Column

XL5: Recorded Macro Prints Sheet Instead of Embedded Chart

XL5: Save As or Delete Dialog Box Doesn't Close on OK

XL5: Screen Updated Incorrectly with SQLRetrieve Function

XL5: Sending Mail from MS Excel Using VBAMAPI.DLL (Part 1)

XL5: Sending Mail from MS Excel Using VBAMAPI.DLL (Part 2)

XL5: Sheets in Wrong Orientation with Print Entire Workbook

XL5: Syntax Errors Using Array Fields in MSQuery

XL5: Transpose Function Returns Date Value as Text

XL5: Unable to Hide Grouped Drawing Objects in Dialog

XL5: Using Global and Local References in Formulas

XL5: Using SENDKEYS to Change Paper Source in Printer Setup

XL5: Using the FormulaArray Property Returns an Unexpected Value

XL5: Using the WinHelp Function with Visual Basic

XL5: Visual Basic Examples Using DDE with Program Manager

XL5: Visual Basic Procedure Option Settings Not Saved

XL5: Visual Basic Procedure to Display System Resources

XL5: Visual Basic Procedure to Return Active Drive Letters

XL7: 'Run-time error '1004'' Using SetBackgroundPicture Method

XL7: #NA Returned When Data put Into Specific Cells via DAO

XL7: ADD.COMMAND Fails if You Use Menu Item Name for Position

XL7: Application.Sendkeys Fails Sending Special Characters

XL7: AutoCalculate in Group Edit Mode Works Only on Active Sheet

XL7: Can't Run Solver Help, Receive Error About Macrofun.hlp

XL7: Can't Set Bookmarks When Variables Defined as String

XL7: Can't Step Through Macro with ActiveWindow.ActivateNext

XL7: Cannot Assign ChartObject Object to Database OLE Fields

XL7: Cannot Compare A Workbook Object With ThisWorkbook

XL7: Code to Access MS Excel Doesn't Work in Version 7.0

XL7: CopyFromRecordset Doesn't Fail in User-Defined Worksheet

XL7: CopyFromRecordset Fails with OLE Automation

XL7: Count Method Returns Wrong Value If Shared Lists Active

XL7: Dates with Two-Digit Years May Yield Unexpected Results

XL7: Debug Window Dialog Box Tabs Appear in Version 5.0 Style

XL7: Error Running Recorded Macro to Insert Map Object

XL7: Error Using OLE Automation with Microsoft Word 7.0

XL7: Get External Returns Incorrect Data and/or Blank Rows

XL7: How to Create a Form Letter with a Visual Basic Macro

XL7: How to Return DAO Query Results Directly to a List Box

XL7: Illegal Operation Using OpenDatabase with Open Database

XL7: Insert Macro From File Hangs When You Use Long Filename

XL7: Integer Example in Help Should Not Exceed 32767

XL7: Invalid Page Fault When OLE Automation Used to Copy Chart

XL7: List of New And Changed Visual Basic Commands

XL7: Macro Recorded to Add Sheet Template Incorrect

XL7: MS Access DDEPoke Help Example Fails If Run from MS Excel

XL7: MS Excel and Visual Basic Library Files (.olb) Available

XL7: New Toolbar Button Properties in VB for Applications

XL7: No Help Topic When You Right Click Custom Dialog Object

XL7: Problems Editing Modules in Shared Files

XL7: Protected Toolbar Disappears When You Move It

XL7: Run-time Error Adding Button to Toolbar

XL7: Run-time Error Using Macro to Access Worksheet in Binder

XL7: Sample Macro to Edit AutoCorrect List

XL7: Visual Basic Command to Show Set Background Dialog Fails

XL7: Visual Basic Example for Creating a PowerPoint Slide Show

XL7: Visual Basic Example Logging on to Schedule+

XL7: Visual Basic Macro to Insert Data in Schedule+

XL7: Visual Basic Procedure To Get Current User Name

XL97 Err Msg: 'Name Conflicts with Existing Module'

XL97: '255 Characters in Cell' Error when Copying Worksheet

XL97: 'Bad DLL Calling Convention' When Running a Macro

XL97: 'Can't Enter Break Mode' Stepping Through a Macro

XL97: 'Cannot Quit' After Using Visual Basic Editor

XL97: 'Exit Design Mode' Deactivates Visual Basic Editor

XL97: 'Invalid Use of Null' Error Setting OnRepeat Method

XL97: 'Module Not Found' Error Opening Workbook

XL97: 'Not Enough Memory' Opening a Workbook with a Chart

XL97: 'Out of memory' Error Running Sub Procedure

XL97: 'Run-Time Error '1004': ATPVBAEN.XLA Could Not Be Found'

XL97: 'Run-time error '4599'' Running DDE Macro to Control Excel

XL97: 'Type Mismatch' Comparing String Variable to Boolean

XL97: 'Unhandled Exception in Mso97.dll' When Using XlCoerce

XL97: Active Cell Moves Using RefreshTable Method

XL97: ActiveMenuBar.Index Different than Earlier Versions

XL97: ActiveX Controls May Not Display Formatted Numeric Data

XL97: Additional Controls Dialog Box Disappears

XL97: ALT Key Stuck On After Running Macro with Copy Method

XL97: Analysis ToolPak Functions Return #VALUE!

XL97: Application.SendKeys Does Not Wait for Key Processing

XL97: ApplyNames Method May Cause Invalid Page Fault

XL97: Auto_Close Macros Run When You Use Application.Quit

XL97: Automation Example with MS Word and MS Outlook

XL97: Background Color Is Not Updated in ActiveX Control

XL97: Background Queries Suspended While Macro Executes

XL97: Calculation Problems with Arrays in Custom Functions

XL97: Calling RunAutoMacros Method More than Once Fails

XL97: Can't Tile Windows with Macro If a Window Is Minimized

XL97: Cannot Add Macros to the Tools Menu

XL97: Cannot Edit Text Box with Unlocked Text

XL97: Cannot Get OLEObjects Property Referencing Collection

XL97: Cannot Import/Export UserForms Between VBE and VB4.0

XL97: Cannot Make Changes to Some Shortcut Menus

XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in

XL97: Cannot Move Among Unlocked Cells in Scroll Area with TAB

XL97: Cannot Move or Copy Sheet After Last Sheet

XL97: Cannot Paste Array Formula in its Original Cell

XL97: Cannot Programmatically Close Referenced Workbook

XL97: Cannot Remove User Name from Default Cell Comment Text

XL97: Cannot Run Macro from Macros Dialog Box

XL97: Cannot Stop Macro After Switching to Other Program

XL97: Cannot Use Custom Function with Data Validation

XL97: Cannot Use Mouse to Populate RowSource or ListFillRange

XL97: Cannot Use New Keyword to Create Workbook Object

XL97: Cannot Use xlDisplayShapes with DisplayDrawingObjects

XL97: Changes to Microsoft Visual Basic for Applications

XL97: Chart Activation with Macro Changes Selection

XL97: Charts.Delete Command in Macro May Delete Worksheets

XL97: Clicking Cancel Button May Not Dismiss UserForm

XL97: Closing UserForm Causes MS Excel to Hang

XL97: Code 'Behind' Worksheet or Workbook may not Work

XL97: Compile Error Passing ParamArray

XL97: Compile Error Running Recorded Macro That Uses Solver

XL97: Conditional Compilation Code Lost With 5.0/95 Format

XL97: Contents of the Samples.xls Workbook

XL97: Copy From Object Browser May Not Copy Named Arguments

XL97: Crash Saving Workbook That Uses BeforeSave Event

XL97: CreateObject and GetObject Work Differently

XL97: Custom Function Returns #VALUE! Error After Running Macro

XL97: Custom Menu Merges with Custom Toolbar

XL97: Custom Toolbar Added Above Existing Toolbars

XL97: Data Validation Message May Not Disappear

XL97: Deactivate Event Doesn't Occur After Moving Sheet

XL97: Defined Names Are Case Sensitive in Microsoft Excel 97

XL97: Deleting Cells with a For Each...Next Loop

XL97: Description of the Value2 Property for the Range Object

XL97: Edit Box Does Not Appear in Toolbox

XL97: Embedded Worksheet Object Stops After Running Macro

XL97: Error Adding or Deleting a Menu Command in a Macro

XL97: Error Appears When CopyFromRecordSet Uses Empty Variable

XL97: Error Applying Comment When Worksheets Are Grouped

XL97: Error Changing Order of Option Buttons on a Dialog Sheet

XL97: Error Creating Web Page with Option Base 1 Setting

XL97: Error Message Appears Returning MSGraph Object Name

XL97: Error Message for Sheets.Select Has Changed

XL97: Error Opening Add-in with Macro

XL97: Error Passing Objects to Subroutine

XL97: Error Running Macro to Modify Shape Text

XL97: Error Running SQLRetrieve with Embedded Chart

XL97: Error Setting AxisGroup Property of Series Class

XL97: Error Using 'Mailto:' with FollowHyperlink Method

XL97: Error Using DDEPoke When Chart Is the Active Sheet

XL97: Error Using RemoveItem Method

XL97: Error When Function Contains a Breakpoint

XL97: Error When Invalid Characters in Drawing Object Name

XL97: Error When Passing an Array Value Between Macros

XL97: Error When Variable Refers to Deleted or Moved Sheet

XL97: Error When You Change List Property of Combo Box

XL97: Errors When Trying to Make Office Assistant Visible

XL97: FindPrevious Method Does Not Support Discontiguous Range

XL97: Format Function May Return an Incorrect Date

XL97: Formula Returns Incorrect Value When Changed by a Macro

XL97: GetSaveAsFilename Method Returns Extra Character

XL97: Help Argument for MsgBox Function Behaves Differently

XL97: How to Add Data to a ComboBox or a ListBox

XL97: How to Assign a Macro to an ActiveX Worksheet Control

XL97: How to Change the Font in a Cell Comment

XL97: How to Change the Taper Style for All Series in a Chart

XL97: How To Create a Dynamic Chart Using Visual Basic

XL97: How to Create a Startup Screen with a UserForm

XL97: How to Create a Template for a Toolbox Control

XL97: How to Create Application Level Event Handlers

XL97: How to Create PivotTable from Word

XL97: How to Customize a Custom Toolbar Button

XL97: How to Determine the Key Pressed Along with Mouse Button

XL97: How to Determine Which Items Are Selected in a ListBox

XL97: How to Disable Shortcut Menus

XL97: How to Display a ComboBox List When UserForm Is Displayed

XL97: How to Display a Custom Office Assistant Balloon

XL97: How to Display a UserForm Whose Name Is in a Variable

XL97: How to Dynamically Resize a UserForm

XL97: How to Fill ListBox Control with Multiple Ranges

XL97: How to Move Between Custom UserForms with CommandButtons

XL97: How to Place a Checkmark Next to a Menu Item

XL97: How to Populate One ListBox Based On Another ListBox

XL97: How to Programmatically Change the Project Name Property

XL97: How to Programmatically Create a Collection

XL97: How to Programmatically Create a Reference

XL97: How to Programmatically Perform a Web Query

XL97: How to Record a Macro Using Relative Cell References

XL97: How to Remove All Items from a ListBox or ComboBox

XL97: How to Remove Individual AutoFilter Drop-Down Lists

XL97: How to Restore a Built-In Menu

XL97: How to Simulate a Paused Visual Basic Procedure

XL97: How to Temporarily Hide a UserForm

XL97: How to Trap Events for an Embedded Chart

XL97: How to Use a UserForm for Entering Data

XL97: How to Use EnableEvents to Disable Event Handling

XL97: How to Use File DSNs and DSN-less Connections

XL97: How to Use FileSearch to Fill a Listbox with File Names

XL97: How to Use the ApplyCustomType Method to Format Charts

XL97: How to Use the GetOpenFilename Method

XL97: How to Use the Query Before and AfterRefresh Events

XL97: How to Use the TextColumn Property

XL97: How to Verify the Value of a CheckBox on a UserForm

XL97: Illegal Operation Unhiding a Row with a Macro

XL97: Illegal Operation Using Unload with Enter Event

XL97: Incorrect Definitions Displayed in Object Browser

XL97: Indexes for Methods and Collections are Rounded

XL97: Input # Statement Does Not Retain Trailing Spaces

XL97: Insert and Delete Methods of Characters Class May Fail

XL97: Invalid Page Fault After Closing Last Open Workbook

XL97: Invalid Page Fault Saving a Workbook or Add-In

XL97: Invalid Page Fault Using DropDown Method with ComboBox

XL97: Keyboard Input for RichTextBox Is Entered in a Cell

XL97: LastUpdated Argument of Htmlconvert Is Not Functional

XL97: Len Function Returns Only 1024 Characters in Cell

XL97: Limitations for Naming Visual Basic Modules

XL97: List Box Doesn't Work Correctly When Workbook Is Hidden

XL97: List of ID Numbers for Built-In Command Bar Controls

XL97: Macro Can't Open File That has no Extension

XL97: Macro Created in Form by Web Form Wizard

XL97: Macro Doesn't Recognize OLEObject Name Property

XL97: Macro Error Accessing OLEObject on Worksheet

XL97: Macro Error Creating Custom Shortcut Menu Item

XL97: Macro Error Using ActiveCell in a Binder or Embedded File

XL97: Macro Error When You Use GET.TOOLBAR Command

XL97: Macro Examples Using OptionButton Controls on a UserForm

XL97: Macro Recorder Doesn't Record Some Menu Commands

XL97: Macro Stops Running When its Workbook is Closed

XL97: Macro to Change File Type to *.* in Open Dialog Box

XL97: Macro to Change the Date/Time Format in a Header/Footer

XL97: Macro to Create Data Validation Circles for Printing

XL97: Macro to Open the Most Recently Used File

XL97: Macro97.exe File Available on Online Services

XL97: Making the Active Row Bold Using SelectionChange Event

XL97: Menu Added in Wrong Position on Menu Bar

XL97: Menu Editor and Make Add-In Dialog Boxes Cause Error

XL97: Menubars and Toolbars Flash When You Close a Workbook

XL97: Microsoft Excel Toolbars Appear in the Visual Basic Editor

XL97: Min Can Exceed Max on ScrollBar or SpinButton Control

XL97: Module Sheet Tab Visible After Saving in 5.0/95 Format

XL97: Modules Inserted Manually Are Not in Modules Collection

XL97: MS Excel Hangs When You Programmatically Save a Workbook

XL97: Names Collection Result Is Incorrect or Returns an Error

XL97: NewSheet Event Not Triggered with Sheet.xlt

XL97: No 'Record at Mark' Feature in Microsoft Excel 97

XL97: No Automatic Type Coercion Between Variable Types

XL97: No Data Validation Property for UserForm TextBoxes

XL97: No Menu Choice to Select All Hyperlinks

XL97: No Trappable Events for Dialog Sheets and Macro Sheets

XL97: Offset of Nonadjacent Range Returns Incorrect Results

XL97: OnSave Property Not Available in Object Browser

XL97: Open Event Macro May Not Activate a Worksheet

XL97: Overflow Error Occurs When Using Err Object

XL97: Page Fault Accessing Demand-Loaded Add-in

XL97: Page Fault Running Macro That Adds Chart to Worksheet

XL97: Page Fault Setting RowSource for ListBox or ComboBox

XL97: Page Fault When Running DDE Macro or Closing Windows

XL97: Page Fault When You Use CTRL Key to Run Macro in XLL

XL97: ParamArray Must be Declared as an Array of Variant

XL97: ParamArrays are Always Zero-Based

XL97: Parentheses Around Object May Dereference the Object

XL97: PasteSpecial Method Activates Target Sheet

XL97: Path/File Access Error in Macro Under Windows NT

XL97: Preventing UserForm from Being Dismissed with Close Button

XL97: Printing Formatted Text from a RichTextBox Control

XL97: Problems Accessing Microsoft Map Visual Basic Help Files

XL97: Problems Disabling and Enabling Shortcut Menus

XL97: Problems Using ColorIndex to Set Color of Borders

XL97: Problems Using TripleState Property for OptionButton

XL97: Problems When Disabling/Enabling Menus

XL97: Problems When Removing Line from Drawing Object

XL97: Problems When Selecting Error Bars With a Macro

XL97: Problems When you use Macro to Add Control to UserForm

XL97: Problems with Arguments of PasteSpecial Method

XL97: Problems with Recorded Macro That Creates Map Object

XL97: Prompt to Save Changed Workbook Fails to Appear

XL97: Protect Method Password Is Not Applied to Worksheet

XL97: Range.PasteSpecial Changes Selection

XL97: Recorded Macro Contains DrawingObjects Method

XL97: Redraw Problem Changing Visibility of Object on Dialog

XL97: RefEdit Control in Binder Does Not Collapse

XL97: RefEdit Control Still Appears After You Close UserForm

XL97: Reference to DAO 3.0 Changes to DAO 3.5 When File Opened

XL97: Resetting Toolbox to Default Controls and Layout

XL97: Returning Data with DAO to a Custom Worksheet Function

XL97: Returning the Id for a CommandBar Control

XL97: Returning Values from ListBox Displaying Multiple Columns

XL97: Revised Dao350.dll File for 'No current row' Error

XL97: RTF Code Copied to Cell When Using TextRTF Property

XL97: Run-time Error '1004' Accessing Locally Defined Name

XL97: Run-Time Error '1004' Using CustomViews Collection

XL97: Run-Time Error 40009 when you Run DAO Macro

XL97: Run-time Error Evaluating Immediate Window Expression

XL97: Run-Time Error Using CreateObject With DAO.DBEngine

XL97: Run-Time Error Using ShowDependents Method

XL97: Run-Time Error Using SpecialCells Method with Protection

XL97: Run-Time Errors Using UserForms Collection

XL97: Sample Macros That Customize and Control Shortcut Menus

XL97: Sample Macros to Control Menus and Submenus

XL97: Sample Macros to Customize or Replace a Menu Bar

XL97: ScreenUpdating Causes Problems in MS Internet Explorer

XL97: Select Method May Select More Cells Than Expected

XL97: SendKeys Slower When Compared to MS Excel 7.0

XL97: Set Window Caption Changes Caption for Active Window

XL97: Setting the Default CommandButton on a UserForm

XL97: Show Method Fails with Passed Arguments

XL97: Show Pages Does Not Use Sheet.xlt for Worksheets

XL97: Status Bar Text not Displayed when you Point to Menu Item

XL97: Stop Recording Button Is Not Displayed During Macro Record

XL97: Structure and Windows Arguments of Protect Method

XL97: Styles('X').Parent Different in MS Excel 97

XL97: Summary of Workbook and Worksheet Application Events

XL97: Syntax Errors Calculating Functions or Opening a Workbook

XL97: TabStrip Information Missing from Value Property Help

XL97: Text Property Limited to 1024 Characters

XL97: Unable to Close File Activated by WorkbookBeforeClose

XL97: Unable to Show UserForms in Other Projects

XL97: Unexpected Behavior for RefEdit Control in Binder

XL97: Unexpected Results Using the Caller Property in a Menu

XL97: Unexpected Results Using the SolverAdd Function

XL97: User-Defined Function with Application.Run Returns #VALUE!

XL97: UserControl Property Code Example Doesn't Work Properly

XL97: UserForm ListBox Is Blank When Run from a Binder Section

XL97: UserForm May Not Be Closed Using QueryClose Event

XL97: Using 'Checked', 'Gray', and 'Unchecked' in Macros

XL97: Using AddItem Method When RowSource Is Data Bound

XL97: Using NoteText and Comment.Text to Apply Comments

XL97: Using Quit Method May Cause Illegal Operation

XL97: Using System, User, and File Data Sources

XL97: Using the Common Dialog (Print) Control Flags Property

XL97: Using the LoadPicture Function with an Image Control

XL97: Using the MenuBars Method in Microsoft Excel 97

XL97: Using the New Keyword to Create Instances of a UserForm

XL97: Using the RefEdit Control with a UserForm

XL97: Using the SheetChange Event in Microsoft Excel 97

XL97: Value Returned by VarType for Omitted Arguments Differs

XL97: Variant Array of Dates Transfers to Worksheet Incorrectly

XL97: VBA Macro Behavior Is Different from MS Excel 5.0 or 7.0

XL97: Visible Property Does Not Apply to All CommandBars

XL97: Visual Basic does not Signal an Error has Occurred

XL97: Visual Basic Example for Using SpinButton with a Date

XL97: Visual Basic Macro to Open a workbook on the Internet

XL97: Warning Appears When You Use GetObject to Open Workbook

XL97: Watch Window Does Not Use Procedure Call Context

XL97: WE1163: 'Visual Basic Examples for Controlling UserForms'

XL97: WE1183: 'Customizing Menu Bars, Menus, and Menu Items'

XL97: Worksheet Change Event Error Using Names Property

XL97: Worksheet Change Event Macro Fails to Run

XL97: Worksheet Displays Incorrect Values After Calculation

XL97: Worksheet Events Don't Occur After Clicking Link

XL97: Worksheet_Change Does Not Run When Worksheet Sorted

XL97: XLDialogOpen Constant Causes Error When Opening XLTs

XL97:How To Create a Group of Mutually Exclusive ToggleButtons

XL98: 'Can't Find Project or Library' When You Run a Macro

XL98: 'Cannot Quit' After Using Visual Basic Editor

XL98: 'Invalid Picture' When Setting Picture Property

XL98: 'Not Enough Memory' Opening a Workbook with a Chart

XL98: Auto_Close Macros Run When You Use Application.Quit

XL98: BottomRightCell/TopLeftCell Incorrect with Merged Cell

XL98: Calling RunAutoMacros Method More than Once Fails

XL98: Cannot Add Macros to the Tools Menu

XL98: Cannot Make Changes to Some Shortcut Menus

XL98: Cannot Move or Copy Sheet After Last Sheet

XL98: Cannot Paste Array Formula in its Original Cell

XL98: Cannot Use Array of Data Points with Extend Method

XL98: Cannot Use Page Setup in Macro If No Printers Installed

XL98: Closing Workbook with VBA Appears to Stop the Macro

XL98: Code 'Behind' Worksheet or Workbook may not Work

XL98: Color Palette Looks Different in Microsoft Excel 98

XL98: Crash Saving Workbook That Uses BeforeSave Event

XL98: DAO and ODBCDirect Are Not Supported

XL98: Displaying a UserForm with a Name That Is in a Variable

XL98: Drawing Objects Behave Differently When Clicked

XL98: Error Adding or Deleting a Menu Command in a Macro

XL98: Error Applying Comment When Worksheets Are Grouped

XL98: Error Running Macro That Inserts Control into UserForm

XL98: Error Running Macro to Modify Cell Comments

XL98: Error Using Natural Language Formula in a Macro

XL98: Error When Passing an Array Value Between Macros

XL98: Error with Invalid Characters in Drawing Object Name

XL98: Excel Quits When You Add Shadow to Series in Surface Chart

XL98: Format Function May Return an Incorrect Date

XL98: Formula Returns Incorrect Value When Changed by a Macro

XL98: Function Returns #VALUE! Error After Running Macro

XL98: How to Convert an Add-in File into a Workbook

XL98: How to Create a Group of Mutually Exclusive ToggleButtons

XL98: How to Determine Which Items Are Selected in a ListBox

XL98: How to Populate One ListBox Based on Another ListBox

XL98: How to Remove All Items from a ListBox or ComboBox

XL98: How to Use EnableEvents to Disable Event Handling

XL98: How to Use the TextColumn Property

XL98: Hyperlinks May Be Corrupted When Modified by a Macro

XL98: Len Function Returns Only 255 Characters in Cell

XL98: Limitations for Naming Visual Basic Modules

XL98: Macro Error Message Appears Behind MS Excel 5.0 Dialog

XL98: Macro Recorder Doesn't Record Some Menu Commands

XL98: Macro Stops Running When its Workbook Is Closed

XL98: Menu Editor and Make Add-in Dialog Boxes Cause Error

XL98: Message Box Function Has a Title Bar

XL98: No 'Record at Mark' Feature in Microsoft Excel 98

XL98: No Automatic Type Coercion Between Variable Types

XL98: No Menu Choice to Select All Hyperlinks

XL98: OK Button in Message Box Is Right-Aligned or Centered

XL98: Options Not Available in Macro Options Dialog Box

XL98: Overflow Error Occurs When Using Err Object

XL98: ParamArray Must Be Declared as an Array of Variant

XL98: ParamArrays Are Always Zero-Based

XL98: Preventing UserForm from Being Dismissed with Close Button

XL98: Problems Disabling and Enabling Shortcut Menus

XL98: Problems When Disabling/Enabling Menus

XL98: Program Stops Responding Moving Chart Location Using Macro

XL98: Returning Values from a Multi-Column ListBox

XL98: Run-Time Error 57121 If Macro Uses ControlFormat Object

XL98: Run-Time Error Using Macro to Add Custom List

XL98: Run-Time Error When Using DDEInitiate with Word

XL98: Setting RowSource Property Results in Run-Time Error

XL98: Setting WindowState Property Generates the Wrong Error

XL98: Structure and Windows Arguments of Protect Method

XL98: Styles('X').Parent Different in MS Excel 98

XL98: Syntax Error Running Macro That Inserts WordArt

XL98: System Error Using DropDown Method with ComboBox

XL98: Text Property Is Limited to 255 Characters

XL98: TextColumn Property Displays Only the First Column

XL98: Type 2 Error Running Macro That Adds Chart to Worksheet

XL98: Using the SheetChange Event in Microsoft Excel 98

XL98: Using VbConstants in Text Strings in MS Excel 98

XL98: Warning Appears When You Use GetObject to Open Workbook