Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Products
  3. Microsoft Excel 97 Standard Edition

Articles for product: Microsoft Excel 97 Standard Edition

Article ID Article Title Hidden
213413 Visual Basic macro to show active cell's range names in Excel
213438 How to programmatically select every nth row in a range in Excel
213447 XL: Visual Basic Module to Create a Gantt Chart
213476 XL: Unexpected Results with Mixed Text and Numbers in Lookup Table
213489 Add-ins do not load when using the CreateObject command in Excel
213507 XL: How to Count Cells That Contain Formulas, Text, or Numbers
213689 Compile error occurs running a recorded macro that uses the Solver add-in
213719 Description of the Value2 property for the Range object in Excel
213740 How to record a macro using relative cell references in Excel
213798 Sample Visual Basic macros for working with arrays in Excel
213800 In Office programs, you receive a "Specified COMMAND search directory had too many parameters" error message when you try to use an MS-DOS core command from the Shell function
213886 The AutoFilter status bar displays the "Filter Mode" message in Excel
213901 XL: General Number Format Applied to Improper Time Entry
213986 XL: Unable to Use Scroll Bar on Number Tab in Format Cells Dialog Box
214033 Pie Chart Shows Incorrect Percentage Value in Excel
214042 You receive an error message when you access files from a floppy disk in Excel
214058 Days of the week before March 1, 1900 are incorrect in Excel
214068 XL: Date Values Earlier Than 1900 Appear as Text
214069 XL: How to Return the First or Last Match in an Array
214070 Description of filtering and extracting a record that contains a text string in Excel
214084 XL: How to Display the File Name of a Worksheet Without Using a Macro
214089 XL: Custom Number Formats Are Lost When Worksheet Saved As Lotus 1-2-3 File
214091 XL: Finding the Balance of a Loan for a Given Period
214093 XL: How to Display the Current Date and Time with Text
214100 XL: How to Extract an Exact Match of Text from a Database
214108 XL: "Cannot Open Protected File" Error Message When You Open Password Protected WK3 or WK4 File
214113 XL: Function to Compute Interest and Growth Rate on a Single Payment
214133 XL: Formula for Distance/Velocity Returned in Hours, Minutes, and Seconds
214139 XL2000: How to Break Links Between a Chart and a Worksheet
214249 How to use the Conditional Sum Wizard in Microsoft Excel
214264 XL: How to Perform a Case-Sensitive Lookup
214275 XL: Using 16-Bit and 32-Bit ODBC Drivers
214278 Row Height Changes When You Print to a Different Printer
214282 Sorting alphanumeric text as numeric values
214297 Window options are not saved in a workspace file in Excel
214304 XL: Minus Sign Appears Before Text in Custom Number Format
214372 XL2000: Value Returned by Format Function May Vary Between Versions of Excel
214462 PRB: Error "Bound to Unknown Type" Inserting ATL Control in VBA UserForm
214797 How To Automate Excel Using Perl for Win32
215706 The Covariance analysis tool returns a different value in Excel 2000 than it does in Excel 97
216657 PRB: Error Messages When Opening Word Documents or Excel Workbooks with Internet Explorer
219430 How To Create/Format an Excel Workbook Using Visual J++ Automation
219639 FP2000: Error Message: "FrontPage Cannot Be Found on Your Machine"
223396 How to minimize metadata in Office documents
223789 How to minimize metadata in Microsoft Excel workbooks
225029 How To Determine Which Version of Excel Wrote a Workbook
231614 How To Automate Excel to Create a New Workbook from Delphi
232866 The whole Excel workbook may be pasted when you paste only the copied cells into another program
236872 You receive an "I/O Error" or the subfolders are displayed as question marks or squares in Office programs
238133 How To Write a DDEML Server for Excel and Use it with NetDDE