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

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

'Invalid Data Format' Referencing File that Contains Procedure

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

'No Floppy Drives Installed' Error during Paintbrush Setup

'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 Omitted in Debug Window

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

ACC: 'Object Invalid or No Longer Set' Error Using CurrentDb

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

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

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

ACC: 'Type Mismatch' Error When Comparing Bookmarks

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

ACC: #Num Appears in Linked Microsoft Excel Spreadsheet

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: Bound Multi-Selection List Box Always Returns Null

ACC: Can't Trap Specific ODBC Errors in OnOpen Property of Form

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 Use AutoNumber to Determine If Record Is New Record

ACC: Cannot Use Code to Set the LogMessages Property

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

ACC: Change Active Control Background Color with Timer Event

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: CreateControl Creates Empty Container for OLE Controls

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: Determining How Many Instances of Application Are Active

ACC: Do Not Jump into WITH Statement Blocks

ACC: Eliminating White Space in Reports with CanShrink and Code

ACC: Enumerating Local and Network Printers

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: Explicitly Close Recordsets to Help Prevent Database Bloat

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: 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 64 KB Segment

ACC: Hourglass May Not Change After Illegal Function Call

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

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

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 Row-Level Statistics (95/97)

ACC: How to Call Excel Functions from Within Microsoft Access

ACC: How to Call Functions by Using a String Variable

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

ACC: How to Change a Field's Data Type at Run Time with Code

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 Currency or Numbers into English Words

ACC: How to Convert Julian Days to Dates in Access and Back

ACC: How to Convert Letters to Numbers in Phone Numbers

ACC: How to Convert Macros to Visual Basic for Applications

ACC: How to Convert Short Time Format to Different Formats

ACC: How to Convert Twips to Pixels

ACC: How to Convert Unsigned Integers to Long Integers

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 History Log of Users and Dates

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 Pop-Up Calendar Control on a Form

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 an Access 2.0 Database with Access 95 or 97

ACC: How to Create an AfterUndo Form Event

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

ACC: How to Create an Updatable Unbound Word Object on a Report

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 Delete a Table Set in RecordSource When Form Closes

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 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 in a Database

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 from 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 Exclude Zero Values When Calculating Averages

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 Export Right-Aligned Fields to a Text File (95/97)

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 an Array by Using Visual or Access Basic

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 As U.S. 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 Generate and Print a Report Without Saving It

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 an Entire Sheet from an Excel Workbook

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 Limit Number of Characters Typed in Unbound Text Box

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 by Using TAB or ENTER

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

ACC: How to Move to the Next Item in a Combo Box with DblClick

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

ACC: How to Open a Form to the Last Viewed Record

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 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 the Path of Linked MS Access 95/97 Tables

ACC: How to Retrieve Workgroup Information Under Win32

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

ACC: How to Round a Number Up or Down by a Desired Increment

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 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 a Control Array in Visual and Access Basic

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 Extra Characters from a String

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 Trap ODBC Login Error Messages

ACC: How to Trap Specific ODBC Error Messages (95/97)

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

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

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 Toggle Button to Hide and Display a Subform

ACC: How to Use Automation to Add Appointments to Schedule+

ACC: How to Use Automation to Change a Graph Chart Type

ACC: How to Use Automation to Change Border Properties for Chart

ACC: How to Use Automation to Create a Microsoft Office Binder

ACC: How to Use Automation to Create a PowerPoint Presentation

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

ACC: How to Use Automation to Fill a List Box

ACC: How to Use Automation to Find a Location in a Word Document

ACC: How to Use Automation to Find Bookmark in Word 97 Document

ACC: How to Use Automation to List SQL Server Objects

ACC: How to Use Automation to Print a Microsoft Word Document

ACC: How to Use Automation to Print Microsoft Access Reports

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

ACC: How to Use Automation to Run a Microsoft Word Macro

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

ACC: How to Use Automation to Run Word 97 Mail Merge from Access

ACC: How to Use Automation to Set Graph Trend Lines

ACC: How to Use Automation with Microsoft Project

ACC: How to Use Code to Change Column Headings in Crosstab Query

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

ACC: How to Use Code to Derive a Statistical Median

ACC: How to Use Code to Derive the Statistical Mode

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

ACC: How to Use Code to Set the Colors of a Control

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 Open Password-Protected Database (95/97)

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

ACC: How to Use dBASE-Style REPORT FORM Command in Code

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 OLE Automation to Change a Graph's Type

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

ACC: How to Use Optional Arguments

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 or Quit Method

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: How to Use Visual Basic to Change Application Title (95/97)

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

ACC: Imported MS Excel Carriage Returns Become Vertical Bars

ACC: Introduction to Windows Programming for MS-DOS Programmer

ACC: Line Numbers Not Automatically Returned by Erl Variable

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: Problems Quitting Microsoft Access

ACC: Problems When You Use Instr() to Find Special Characters

ACC: Programmatically Add AutoNumber Field to Table with DAO

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

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

ACC: Query That Has 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

ACC: Round or Truncate Values to Desired Number of Decimals

ACC: Rounding Errors Using Floating-Point Numbers

ACC: Running a Microsoft Word 97 Macro Using Automation

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

ACC: Same Named Module and Function Cause Error After Conversion

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 in Several Different Ways

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 Remove Alphas from a Numeric Field

ACC: Sample Function to Replace Special Characters

ACC: Sample Function to Return a Random Record

ACC: Sample Function to Reverse the Characters in 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: Sorting Titles Without Leading Articles (The, An, or A)

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: Text Import Wizard Doesn't Import Data Correctly

ACC: Tips for Debugging Visual Basic for Applications Code

ACC: Two Functions to Calculate Age in Months and Years

ACC: Unexpected Characters Appear in Imported dBASE IV Database

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 Create and Manipulate an Excel Workbook

ACC: Using Automation to Send a Microsoft Exchange Message

ACC: Using Automation to Transfer Data to Microsoft Excel

ACC: Using Code to Dynamically Synchronize Two Forms (95/97)

ACC: Using CreateControl() and CreateReportControl() Functions

ACC: Using CreateForm() and CreateReport() Functions

ACC: Using DAO in Visual Basic Code to Import Relationships

ACC: Using DAO to Set and Retrieve Custom Database Properties

ACC: Using Data Access Objects (DAO) to List Object Names

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 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 Visual Basic to Hide a Link to an External Table

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

ACC: Validation Rule to Accept Only Alphabetical Characters

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

ACC: Version Argument for DoMenuItem (2.0/95)

ACC:How to Find Minimum or Maximum Value Across Fields of Record

ACC:Using DeleteControl, DeleteReportControl,

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 Word Document Using OLE Automation

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: 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

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 Graph 5.0 Graphs Upgraded to 8.0 Back to 5.0

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 Statement

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 You Use 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 the Colors of a Chart Dynamically

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

ACC97: How to Create an Audit Trail of Record Changes in a Form

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

ACC97: How to Create Command Bars by 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 Visua

ACC97: How to Force the IsBroken Property to Return True

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

ACC97: How to Loop Through References to View Their Properties

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 Programmatically Create/Search/Replace/Modify Code

ACC97: How to Programmatically Display a Help file

ACC97: How to Read .LDB Files

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 File Name 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: Sample DAO Code to Create a Many-to-Many Relationship

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: Visual Basic Example for CommonDialog Control Won't Work

ACC97: Why a Calculated Control Is Blank

ACC97:How to Convert Internet Shortcuts to Hyperlinks in a Table

ACC97:Transaction in ODBCDirect Workspace Causes Corrupted Index

Activating an Embedded Chart Using a Macro

Automation Error Using Excel Object in Visual Basic Procedure

BUG: Shell Returns Invalid Proc Call Even If App Starts

BUG: Cannot Reuse the Name of a UserForm

BUG: DAO dbFailOnError causes RecordsAffected to return 0

BUG: Drive Object Properties Are Incorrect on Large Drive (

BUG: Is Operator in VBApp Incorrectly Evaluates Excel Objects

BUG: Multiple SendKeys Statements Turn Off NumLock Key

BUG: VBApp FileCopy Updates Destination File's Date

Calling Macros Using OLE from MS Visual Basic for Applicatons

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

Cannot Change Color of Palette in 4-Color CGA Mode

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

CGA Two Color Produces Color Screen in Paintbrush

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

Changing Paintbrush's Appearance to Free Up Memory

Close Button on a Message Box Is Unavailable Under Windows 95

Closing Shared Files Using a Macro May Cause Infinite Loop

Creating a Print File from MS Paintbrush

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

Dir Function Example in Visual Basic Help File Gives Run-Time Er

Display Adapters Supported in Microsoft Paintbrush 4.00

DocErr: EnableCancelKey Property Uses xlDisabled Constant

Environment Not Set When Running Paintbrush 4.00

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

Errors Creating New Macro or Module Sheet

Excel Displays Only First Column in Embedded Worksheet

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

Excel: Cannot Open an Alias from a Macro

Excel: Duplicate NOTE or DEFINE.NAME in Recorded Macro

Excel: Editing a Chart SERIES Formula with a 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: 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

Files Created during Paintbrush 4.00 Setup

FIX: Compiling VB5 Applications with Large UDTs May Crash

FIX: Format Function Returns Incorrect Date or Number

FP98: How to Return Plain Text as a URL from a Database

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

How to Compare Two Cells Ignoring Leading and Trailing Spaces

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

How to Dimension a Variable as Name Type

How to Fill a UserForm ListBox with Database Values

How to Fill the Microsoft Visual Basic 5.0 FlexGrid Control

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 Use a Multi-Select List Box to Filter a Form

How to Use Looping Structures in Visual Basic for Applications

HOWTO: Call a VB ActiveX Server from a VBA Application

HOWTO: Change the Short Date Format from Visual Basic

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

HOWTO: Convert a Fraction to a Decimal Number

HOWTO: Convert Between ASCII and EBCDIC Character Codes

HOWTO: Convert Between Signed and Unsigned Numbers

HOWTO: Create a Parameter Query via Data Access Objects

HOWTO: Create an Incremental Search ComboBox

HOWTO: Display a Closed Message

HOWTO: Display a Number as a Fraction

HOWTO: Do 64-bit Arithmetic in VBA

HOWTO: Extract Appointment Information from Schedule Plus 7.0

HOWTO: General Bit Manipulation Routines

HOWTO: Get a Window Handle Without Specifying an Exact Title

HOWTO: Improve String Concatenation Performance

HOWTO: Navigate Excel Objects from Visual Basic

HOWTO: Open Another User's Schedule Programmatically

HOWTO: Parse a Person's Name into Multiple Variables

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

HOWTO: Read or Modify User-Defined DAO Properties

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

HOWTO: Search for the Last Occurrence of a Substring

HOWTO: Seek Past VBA's 2GB File Limit

HOWTO: Use Optional Arguments in Intrinsic Data Types

HOWTO: Use QueryPerformanceCounter to Time Code

HOWTO: VB3: Navigate Excel Objects from Visual Basic 3.0

HOWTO: VB3: Use the Word SpellChecker Via OLE Automation

HOWTO: Write Date Calculation Routines

IBM ROM Diagnostic and Power-On-Self-Test (POST) Errors

Improving Performance of Macro That Has a Repetitive Function

Incorrect Value Returned for Custom Property Linked To Content

INFO: Format Function and International Settings

INFO: Sample Function to Format Date and Time Intervals

INFO: Security Patch Available for Forms 2.0 ActiveX Control

INFO: VB5 FAQ: Visual Basic 5.0 Control Creation Edition

Installing Paintbrush 4.00 on Two Floppy Disks

IS Operator Does Not Work with Microsoft Excel Objects

KB Help File for Visual Basic for Applications

Large Scan Images Load; Smaller Images Don't Load

Line Numbers Greater Than 65529 Not Supported

Macro Error After PASTE() Function 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 Place Filenames in Given Directory on Worksheet

Macro to Save All Open Worksheets in Excel

Macro to Show Named Ranges Containing the Active Cell

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

Mouse Err Msg: Packed Files Corrupted

MS Paintbrush 4.0 Uses PBRUSH.INI, Not DEFAULT.INI

MS Paintbrush 4.00 Files Load into Windows 3.00 Paintbrush

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

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

MXL5: Wristwatch Mouse Cursor in Button Editor Using Macro

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

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

OFF: Macro for Listing Paper Names Supported by Active Printer

OFF: Office Assistant Not Answering Visual Basic Questions

OFF2000: Error Trying to View Locked or Signed VBA Project

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: ErrMsg: 'Could Not Open Macro Storage' w/Euro Character

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 Programmatically Hide and Unhide Windows Taskbar

OFF97: How to Programmatically Manipulate a UserForm

OFF97: IPF in FM20.DLL when Showing UserForm

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

OFF97: Selected Check Box or Option Button Prints Unselected

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: Cannot Use Save or Load with FileFind Object

OFF98: Type 2 Error Occurs When Showing UserForms

OFF98: Visual Basic Modules Cannot Be Hidden or Protected

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: Body Property Limited to 64 KB on Windows 95/98

OL97: Bound Control Does Not Support Click Event

OL97: Can't Display or Save Item Using GetItemFromID

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

OL97: Cannot Programmatically Sign or Seal a Mail Message

OL97: Click Event Behavior for Standard Controls

OL97: Creating Sequentially-Numbered Items in a Folder

OL97: Custom Forms and Programming Limitations

OL97: Display Specified Date in Outlook Calendar

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 Populate a List Box or Combo Box

OL97: How to Programmatically Determine Online/Offline Status

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: Incorrect Count Property Using Recurring Appointments

OL97: MailItem's RemoteStatus Property Doesn't Work

OL97: Next/Previous Disabled Using Programming to Display Item

OL97: No Events Fire When Message or Notes Field Changes

OL97: NoteItem.Move Actually Copies Item

OL97: Outlook Stays in Memory After Using Attachments via Code

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

OL97: ReplyRecipients Property Is Read/Write, Not Read-only

OL97: ReportItem.Body Returns Empty String

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

OL98: ActiveInspector.CurrentItem Returns Wrong Contact Item

OL98: Adding Help Files to an Outlook Custom Form

OL98: Additional Control Properties Available for Programming

OL98: Body Property Limited to 64 KB on Windows 95/98

OL98: Bound Control Does Not Support Click Event

OL98: Can't Use Square Brackets to Sort User-defined Fields

OL98: Click Event Behavior for Standard Controls

OL98: Collection of Items Does Not Appear to Sort

OL98: Controls Unexpectedly Resize or Move on a Custom Form

OL98: Creating Sequentially-Numbered Items in a Folder

OL98: Do Not Use 'New' Keyword to Declare New Items

OL98: Form Name Not Updated When Programmatically Published

OL98: Grid Displayed in Form Control Outside of Design Mode

OL98: How to Automate Outlook from Another Program

OL98: How to Automatically Close a Form When Calling an Action

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

OL98: How to Populate a Combo Box with Your Contacts (VBScript)

OL98: How to Populate a List Box or Combo Box

OL98: How to Programmatically Change Displayed Calendar Date

OL98: How to Programmatically Change Outlook's User Interface

OL98: How to Programmatically Determine Online/Offline State

OL98: How to Programmatically Determine the Version of Outlook

OL98: How to Programmatically Filter by Category

OL98: How to Programmatically Set TextBox and CheckBox Values

OL98: How to Programmatically Synchronize Folders

OL98: How to Properly Loop Through Items in a Collection

OL98: How to Retrieve All Recurring Appointments with Code

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

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

OL98: How to Sort a List Box or Combo Box

OL98: How to Start Another Program from an Outlook Form

OL98: How to Use Command Bars in Outlook Solutions

OL98: How to Use Fields and Controls with VBScript

OL98: How to Use the Restrict Method

OL98: How to Use the SetColumns Method

OL98: How to Use Variables with Find and Restrict Filters

OL98: Incorrect Count Property Using Recurring Appointments

OL98: Incorrect Message Class with Recurring Appointments

OL98: Item Created by Automation Doesn't Use Custom Form

OL98: Item Must Be Saved Using ForwardAsVCal, ForwardAsVCard

OL98: MailItem's RemoteStatus Property Doesn't Work

OL98: Next and Previous Unavailable Using Code to Display Item

OL98: No Events Fire When Message or Notes Field Changes

OL98: NoteItem.Move Actually Copies Item

OL98: Object Model Events Not Exposed Outside of Outlook

OL98: Outlook Doesn't Exit After Using PublishForm Method

OL98: Programmatically Accessing Office Form Documents

OL98: Programmatically Import Outlook Items from MS Access

OL98: Programmatically-Created Attachment Loses Icon

OL98: Programming Examples for Referencing Items and Folders

OL98: Programming with EntryIDs, StoreIDs, and GetItemFromID

OL98: PropertyChange Event Does Not Run for Some Fields

OL98: Published Form with Find Method Displays Macro Warning

OL98: ReplyRecipients Property Is Read/Write, Not Read-only

OL98: ReportItem.Body Returns Empty String

OL98: Restrict May Not Work with Uncached Properties

OL98: Restrict Method Doesn't Work with GetSharedDefaultFolder

OL98: SaveSentMessageFolder Property Renames Folder

OL98: SetColumns Returns Incorrect Times When Used with Tasks

OL98: SetColumns Returns Incorrect Value for Boolean Field

OL98: Setting Body or HTMLBody Properties Changes Mail Format

OL98: Supported Outlook Form Control Events

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

OL98: Using Address Books in an Outlook Solution

OL98: VBScript Example Returns the Current User Name

OL98: Working with Form Definitions and One-Off Forms

OL98: Working with Keywords Fields from VBScript

OL98: Working with the Message or Body of an Outlook Item

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

Paint Roller Patterns

Paintbrush 4.0 Err Msg: 'There Is No Image...'

Paintbrush 4.0 Err Msg: Could Not Init Video Hardware

Paintbrush 4.0 Printer Support

Paintbrush 4.0 Prints Small/Uses Too Much Memory

Paintbrush and Zenith Z-449 Video Card

Paintbrush Err Msg: Cannot Find Drivers

PaintBrush Err Msg: Divide-Overflow

Paintbrush May Crash with Insufficient Memory

Paintbrush Options for Pasting Cutouts: Transparent or Opaque

PBRUSH.CNV File Assigns Default Directories to File Types

PCX File Format and Bitmapped Images

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

PPT: Error Importing Form Into the Visual Basic Editor

PPT: How to Create a PowerPoint 97 Add-In

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

PPT: Introduction to Macro Programming in PowerPoint 97 and 98

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

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

PPT: Sample Code to Create a Basic Organization Chart

PPT: Sample Code to Delete Speakers Notes From Presentation

PPT: Sample Code to List Available Add-Ins

PPT: Sample VB Code to Manipulate Command Bars

PPT: Unable to Reference Renamed and Grouped Objects by Name

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: Add-in that Inserts a Picture to Fit to the Slide

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: 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: GoToSlide Method Uses Custom Show Slide Index

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

PPT97: How to Auto Load a PowerPoint Add-In

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 Batch Import Serially Named Graphics Files

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 VB Code Changes Source of Multiple Linked Objects

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: Typing Is Slow When Recording a Macro

PPT97: Viewer Quit Method Does Not Close Viewer

PRB: ACC97: Run Method Can't Find Procedure Although It Exists

PRB: DBEngine.Idle dbRefreshCache Doesn't Immediately Refresh

PRB: Error 3162 Setting FoxPro Date Field to Null

PRB: Error When Excel VBApp Proc

PRB: Key in VBA Collection Object Is Not Case-Sensitive

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

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

Printing a Full-Page Image from Paintbrush

Printing with Okidata Microline 92/93 or Other Printers

Printing with the Partial Option/Landscape Mode May Not Work

PRJ: Cannot Execute Macros with Optional Arguments

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

PRJ: Current Date Gridline Not Redrawn Using CurrentDate Prop

PRJ: Incorrect TimescaledData Syntax in Visual Basic Reference

PRJ: TimeScaledData Method Example Run Time Error 91

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: 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

PRJ4: Project 4.0 Constants for Project and Visual Basic

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

PRJ41: ActiveCell Collection Causes MS Project to Hang

PRJ98: How to Change the Default Working Directory

PRJ98: Macro to Determine If a Project Is Opened as Read-Only

Problems Using Paintbrush with Direct Access

Problems with MS Paintbrush and Video Seven PM VGA Drivers

Proj41: Using DAO to Export Data to Microsoft Access

Query to Find Unmatched Records Between Two Files

Rounding Errors In Visual Basic For Applications

Run-Time Error Accessing BuiltinDocumentProperties

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 Functions to Parse Numbers and Strings into Dates

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

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

Supported Printers/MS Paintbrush Version 1.00

Tandy VGA May Hang on HP 386/25 or COMPAQ 386/20 During Setup

Text Fonts (Outline, Bitmap) in Mouse Paintbrush 4.00

Tile Patterns Not Filling in Entire Closed Entity

TMGR: CreateObject Starts Team Manager with No Open File

TMGR: Excel Fails Using Tmgr View Object Without Name Property

TMGR: GroupBy Method Does Not Support All Interface Options

TMGR: Misuse of File Property May Result in Error Message.

TMGR: Run-time Error Messages Not as Expected

TMGR: Using Print Method Causes Run-Time Error

Transporting Pictures between Different Display Adapters

UNCONF: Out of Stack Space Error Calling QueryGetData

Using a Macro to Select Font Cartridges

Using Automation to Send a Microsoft Outlook Message

Using GET.CELL with Type_num 15 in Excel

Using MS Excel 5.0 Dialog Boxes MS Excel 4.0 Macro Language

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: Assigning Word Styles to the PowerPoint Slide Master

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 '3027' Using ODBCDirect to Open RecordSet

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: Sample Code to Rotate 3D Shapes During a Slide Show

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

VBA: Scope of Variables in Visual Basic for Applications

Ventura Desktop Publisher and Paintbrush

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

WD: Add Button Unavailable for Insert/Bookmark

WD: ConfirmConversions Doesn't Work with MailMergeOpenDataSource

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

WD: How to Create and Display a Custom Dialog Box

WD: Macro to Determine If a File Exists on Disk

WD: Macro to Generate Report of Files Found

WD: Passing Parameters 'By Reference' and 'By Value'

WD: Some Screen Items Update with ScreenUpdating Set to 0

WD: Visual Basic Example to Print Current Page

WD: WordBasic Macro to Number New Documents in Sequence

WD97: AutoClose Macro Is Executed Before Document Is Closed

WD97: AutoClose Macro Prompts to Save When Document Is Closed

WD97: AutoExit Macro Won't Remove Menu Items Added by AutoExec

WD97: Automating a Process Based on the Days Since Last Revision

WD97: Cannot Trap Undefined Sub or Function Error

WD97: Coding ENTER Key to Move to Next Field in Protected Form

WD97: Form Fields Lose Text When Protected for Forms

WD97: GetAddress Method Without Name Argument Causes IPF

WD97: Grouped Floating Option Buttons Not Mutually Exclusive

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

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

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

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

WD97: How to Determine Which Items Are Selected in List Box

WD97: How to Force a User to Enter Data into a Form Field

WD97: How To Perform Calculations With Dates And Times

WD97: How to Play a .wav Sound File by Using a Macro

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

WD97: How to Return Only the File Name Using FileSearch Property

WD97: How to Save Each Section of Doc As Separate File

WD97: How to Set the Default File Path Using VBA

WD97: How to Use (OLE) Automation with Word

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

WD97: Invalid Page Fault Running ToolsGramSettings Command

WD97: Macro Examples to Calculate Cells Across Multiple Tables

WD97: Macro to Add a Command Button with Code to a Document

WD97: Macro to Determine Whether File Is Already Open

WD97: Macro to Replace Font Formatting

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

WD97: Macro to Set Default Save Format As HTML

WD97: Macros to List or Print All Documents Found in a Folder

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

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

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

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

WD97: Sample Code to Insert Section, Page, and Column Breaks

WD97: Sample Macro to Create Popup Toolbar

WD97: Sample VB Code to Delete Built-In Style

WD97: Sample VBA Code to Set, Retrieve .ini File or Registry Inf

WD97: Sample Visual Basic Macro to Type All AutoText Entries

WD97: Shell Command Does Not Wait for Application to Finish

WD97: Some Screen Items Update with ScreenUpdating Set to 0

WD97: Timing Problem Getting Object Via OLE Automation

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

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

WD97: Using the ASCII and ANSI Characters in Word for Windows

WD97: VBA Function to Check If File or Document Is Open

WD97: VBA Macro to Return (Count) Total Number of Pages

WD97: VBA Stops and Does Not Enter Break Mode

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

WD98: Changing the Default Folder

WD98: How to Automatically Update Fields

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

WD98: Macro to Set Default Save Format As HTML

WD98: Macros to List or Print All Documents Found in a Folder

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

WE1277: XL7:Visual Basic Equivalents for Lotus Macro Commands

What Is New and Obsolete with DAO in MS Access 95

Window Class Names for the Office 97 Applications

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 OLE Automation: Workbook Hidden Using GetObject Function

XL: 'Can't Execute Code in Break Mode' When Running Macro

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: '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: Add-Ins Don't Load When Using CreateObject

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 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 Elapsed Time for a Visual Basic Procedure

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

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

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 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: 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 ERASE in a Batch File Run by SHELL Function

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

XL: Caption Property of Menu Contains Ampersands

XL: Cells.Find Returns Error When No Match Found

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: Clarification of Caller Property Help

XL: Closing Excel from Workbook Control Menu Causes GP Fault

XL: Control Block Statement Error Messages

XL: Control Method of Sheet Class Failed with Grouped Control

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: Converting Decimal Degree Value to Degrees, Minutes, Seconds

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 Transpose Nonadjacent Range

XL: Custom Functions Can't Change Microsoft Excel Environment

XL: Data Map Objects Limited to RefreshMap Command

XL: Data Returned to Wrong Row Using SQLBind

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

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

XL: DDE Poke to Microsoft Excel Workbook Fails

XL: DDEREQUEST May Truncate Results

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: Err Msg: Error in Procedure Causes 'Cannot Find Procedure'

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

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 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 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: 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: 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 to Convert Degree to/from Fractions of Degrees

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: GP Fault/Error Using For Each Statement with OLE Object Type

XL: Hiding Button Objects with Visual Basic for Applications

XL: Hiding Nonadjacent Rows May Hide Other Rows

XL: How the DateSerial Function Works with Year Arguments

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 Shortcut Key to Menu Item Using Chr Function

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 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 Text to TextBoxes Using the Characters Method

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 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 Macro That Opens Multiple Selected Files

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 MS Access Database from MS Excel Using DAO

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 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 Force Macro Code to Wait for Outside Procedure

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

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 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 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 Select Cells/Ranges Using Visual Basic Procedures

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

XL: How To Share a Custom AutoFill List

XL: How to Show Quotation Marks in Function Results and Macros

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 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: IsDate Function Incorrectly Identifies Some Expressions

XL: LibraryPath Includes Trailing Separator on Macintosh

XL: Limitations of Passing Arrays to Excel Using Automation

XL: Macro Cannot Scroll Chart Sheet

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 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 Data Point Labels to a Chart in Excel

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 Count the Number of Procedures on a Module Sheet

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 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 Search for Cell Formats: Font, Border, and Interior

XL: Macro to Select Every nth Row/Column

XL: Macro to Shade Every Other Row in a Selection

XL: Macro Virus Protection Alert May Not Appear

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

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: 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: New Balloon That Contains Picture May Not Be Displayed

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: 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: Passing Variables in Visual Basic for Applications Macros

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

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: Put Statement Allows Writing Beyond End of File

XL: Q

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: Recording a Visual Basic Macro in an External Module

XL: RemoveItem and RemoveAllItems Methods May Not Work

XL: Removing Chart Links to a Worksheet in a Macro

XL: Removing the Control Menu and Application Window Controls

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 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 '1005': Setting PrintArea Property

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 Find Duplicate Entries in a Column

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

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: Shell Function Doesn't Accept Built-in Constants

XL: Some Window Properties Only Affect Active Worksheet

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: 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: Unlocked Cells Not Underlined with Protection Enabled

XL: Update Remote References Option Selected by Default

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

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

XL: Using DAO to Join Tables of Different Formats

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 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 Return Screen Elements

XL: Varied Results with Mixed Text

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: 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 the Verb Method

XL: Visual Basic Examples Using DDE

XL: Visual Basic Function to Calculate Cross Product

XL: Visual Basic Macro to Break Chart Links

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: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: 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: PageSetup.Zoom Does Not Work with Some Printers

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: ToolbarButtons.Add Doesn't Add Status Bar Text to Button

XL5: Transpose Function Returns Date Value as Text

XL5: Unable to Hide Grouped Drawing Objects in Dialog

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: CopyFromRecordset Doesn't Fail in User-Defined Worksheet

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: Deleting a Cell Changes the UsedRange Property

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: '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 '4599'' Running DDE Macro to Control Excel

XL97: 'Subscript Out of Range' Using H or VPageBreaks.Location

XL97: 'Type Mismatch' Comparing String Variable to Boolean

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

XL97: ActiveX Controls May Not Display Formatted Numeric Data

XL97: Analysis ToolPak Functions Return #VALUE!

XL97: Application.SendKeys Does Not Wait for Key Processing

XL97: ApplyNames Method May Cause Invalid Page Fault

XL97: Assigning Help Files and Topic IDs in Visual Basic Project

XL97: Background Color Is Not Updated in ActiveX Control

XL97: Blank Line Inserted into Module

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 Run Macro from Macros Dialog Box

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: Changes to Microsoft Visual Basic for Applications

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: Color Palette Looks Different in Microsoft Excel 97

XL97: Compile Error Passing ParamArray

XL97: Compile Error Running Recorded Macro That Uses Solver

XL97: Contents of the Samples.xls Workbook

XL97: Copy Method of Sheets Object Causes Invalid Page Fault

XL97: Crash Saving Workbook That Uses BeforeSave Event

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

XL97: Custom Menu Merges with Custom Toolbar

XL97: Custom Toolbar Added Above Existing Toolbars

XL97: DAO 3.0 CopyFromRecordset Method Not Compatible with XL97

XL97: Defined Names Are Case Sensitive in Microsoft Excel 97

XL97: Description of the Value2 Property for the Range Object

XL97: Edit Box Does Not Appear in Toolbox

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 Application Object from ActiveX Control

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

XL97: Error Message for Sheets.Select Has Changed

XL97: Error Opening Add-in with Macro

XL97: Error Passing Objects to Subroutine

XL97: Error Running SQLRetrieve with Embedded Chart

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: Excel Hangs When You Programmatically Save a Workbook

XL97: Excel Quits Unexpectedly Running Macro That Creates Chart

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 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 Convert All Files on a Server to Microsoft Excel

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 Display Custom Function in Function Wizard Step 2

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 Create a Collection

XL97: How to Programmatically Create a Reference

XL97: How to Record a Macro Using Relative Cell References

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

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 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: Invalid Page Fault After Closing Last Open Workbook

XL97: Invalid Page Fault Using DropDown Method with ComboBox

XL97: LastUpdated Argument of Htmlconvert Is Not Functional

XL97: Limitations for Naming Visual Basic Modules

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

XL97: Macro Cannot Open a File That Has No Extension

XL97: Macro Created in Form by Web Form Wizard

XL97: Macro Error Accessing OLEObject on Worksheet

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

XL97: Macro Examples Using OptionButton Controls on a UserForm

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: Menu Added in Wrong Position on Menu Bar

XL97: Menu Bars and Toolbars Flash When You Close a Workbook

XL97: Min Can Exceed Max on ScrollBar or SpinButton Control

XL97: Modules Inserted Manually Are Not in Modules Collection

XL97: Modules.Count Method Always Returns 0

XL97: Names Collection Result Is Incorrect or Returns an Error

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

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: OnSave Property Not Available in Object Browser

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: Page Setup Command Does Not Exist in Modules

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: Private Functions Are Available to Worksheet

XL97: Problem Using Sort Method with More Than One Key

XL97: Problems Disabling and Enabling Shortcut Menus

XL97: Problems When Disabling/Enabling Menus

XL97: Problems When Removing Line from Drawing Object

XL97: Problems When You Use Macro to Add Control to UserForm

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: Public Variables Are Not Seen on Modules for Sheet or User

XL97: Range.PasteSpecial Changes Selection

XL97: Range_Lookup Argument in VLOOKUP() Finds Exact Match

XL97: Redraw Problem Changing Visibility of Object on Dialog Box

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 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' Using CustomViews Collection

XL97: Run-Time Error 40009 When You Run DAO Macro

XL97: Run-time Error Using Copy Method to Copy Module Sheet

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

XL97: Run-Time Error Using FormulaArray Property

XL97: Run-Time Error Using ShowDependents Method

XL97: Run-Time Errors Using UserForms Collection

XL97: Runtime Error 424 Clicking Cancel on InputBox

XL97: Sample Macros for Customizing Menus and Submenus

XL97: Sample Macros That Customize and Control Shortcut Menus

XL97: Sample Macros to Return ID for a CommandBar Control

XL97: ScreenUpdating Causes Problems in MS Internet Explorer

XL97: Select Method May Select More Cells Than Expected

XL97: Set Window Caption Changes Caption for Active Window

XL97: Setting the Default CommandButton on a UserForm

XL97: Some Properties and Methods Are Missing in Object Browser

XL97: Structure and Windows Arguments of Protect Method

XL97: Styles('X').Parent Different Than in Earlier Versions

XL97: TabStrip Information Missing from Value Property Help

XL97: Text Property Limited to 1,024 Characters

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: User-Defined Function with Application.Run Returns #VALUE!

XL97: User-Defined Function with Select Case May Return #VALUE!

XL97: UserControl Property Code Example Doesn't Work Properly

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

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

XL97: Using a Date Range in the Holidays Argument of Networkdays

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 the LoadPicture Function with an Image Control

XL97: Using the MenuBars Method in Microsoft Excel 97

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: VBA Macro Behavior Is Different from Excel 5.0 or 7.0

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: WE1163: 'Visual Basic Examples for Controlling UserForms'

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

XL97: Workbook Created via Automation Opens as Hidden

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_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: 'INTERSOLV' Licensing Error Using SQL Functions

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

XL98: 'Out of memory' Error Running Sub Procedure

XL98: 'Unable to Record' Message When Recording a Macro

XL98: Cannot Edit Text Box with Unlocked Text

XL98: Cannot Programmatically Close Referenced Workbook

XL98: Compile Error Passing ParamArray

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

XL98: Error Trapping with Visual Basic for Applications

XL98: Function Returns #VALUE! Error After Running Macro

XL98: General ODBC Error Running Macro from Excel for Windows

XL98: How to Add the Workbook Path to the Footer

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

XL98: How to Create a GIF File from a Microsoft Excel Chart

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

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

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

XL98: How to Show Quotation Marks in Function Results and Macros

XL98: How to Temporarily Hide a UserForm

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

XL98: Input # Statement Does Not Retain Trailing Spaces

XL98: Inserting and Formatting Text in Headers and Footers

XL98: Macro to Search for Cell Formats: Font, Border, Interior

XL98: Macro to Shade Every Other Row in a Selection

XL98: No Data Validation Property for UserForm TextBoxes

XL98: Offset of Nonadjacent Range Returns Incorrect Results

XL98: Parentheses Around Object May Dereference the Object

XL98: Problems When You Use Macro to Add Control to User Form

XL98: Range_Lookup Argument in VLOOKUP() Finds Exact Match

XL98: Redraw Problem Changing Visibility of Object on Dialog

XL98: Run-time Error Using Copy Method to Copy Module Sheet

XL98: Run-Time Error Using FormulaArray Property

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

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

XL98: Sample Visual Basic Code to Create Color Index Table

XL98: SendMail Method Returns Run-time Error 1004

XL98: Unexpected Quit After Changing Tab Order of Option Buttons

XL98: Unexpected Results Using the Caller Property in a Menu

XL98: Using the SheetChange Event in Microsoft Excel 98