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.

Offline KB Article List

Article ID Article Title Hidden
213772 How to use system, user, and file data source names (DSN) in Excel 2000 or Excel 2002
213773 How to create data validation circles for printing in Excel
213774 XL2000: How to Create a Startup Screen with a UserForm
213775 XL2000: Edit Box Does Not Appear in Toolbox
213776 XL2000: How to Use the RefEdit Control with a UserForm
213777 XL2000: How to Play Sounds Using Visual Basic for Applications
213778 XL2000: Unexpected Behavior for RefEdit Control in Binder
213780 XL2000: How to Use Visual Basic to Create a Dynamic Chart
213781 XL2000: SaveAs Method for Worksheet Object Doesn't Save Single Ply
213783 XL2000: Compile Error Passing ParamArray
213785 XL2000: Macro Cannot Open a File That Has No Extension
213786 XL2000: Copying from the Object Browser May Not Copy Named Arguments
213787 XL2000: Problems Using Recorded Macro That Creates Map Object
213788 XL2000: Unable to Get OLE Object's Property Referencing Collection
213789 XL2000: Visual Basic Does Not Signal That an Error Has Occurred
213790 XL2000: No Menu Command to Select All Hyperlinks Within a Worksheet
213793 XL2000: How to Copy the Text Within a Text Box to a Cell
213794 XL2000: DDEREQUEST May Truncate the Results of a Query
213795 XL2000: How to Create a Monthly Calendar
213796 XL2000: How To Share a Custom AutoFill List
213797 XL2000: How to Populate an Array with a Discontiguous Range
213798 Sample Visual Basic macros for working with arrays in Excel
213799 HOW TO: Simulate a PivotTable with No Summarization in Excel 2000
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
213801 Sample Visual Basic code to create a color index table in Excel
213802 XL2000: How to Copy Text to Text Boxes Using the Characters Method
213805 XL2000: Macros to Loop Through Range and Act Based on Cell Value
213806 XL2000: How to Close All Workbooks But One with a Visual Basic Macro
213809 XL2000: Cannot Use xlConstant Names in Variables in Visual Basic Code
213810 How to determine how many pages will be printed in Excel
213811 XL2000: How to Use DAO to Create a New Microsoft Excel Workbook
213812 XL2000: Goto Method Fails When Custom Dialog Box Is Visible
213813 XL2000: How to Add a New Category to Function Category List
213814 XL2000: Macro to Extract Data from a Chart
213815 XL2000: How to Change the Paper Source Using the SendKeys Command
213816 XL2000: Macro to Import a Text File into an Existing Worksheet
213817 XL2000: How to Open a Copy of a Template in Microsoft Excel 2000
213818 XL2000: How to Use a Visual Basic Macro to Sort Arrays in Excel
213820 XL2000: How to Use Data Access Objects to Join Tables of Different Formats
213823 Macro that changes cell dimensions on multiple sheets does not run as expected
213825 XL2000: "Overflow" Error Message Running Procedure with Math Calculation
213826 XL2000: Visual Basic Macro to List Circular References
213828 XL2000: Cannot Specify Number of Digits with FIX() or INT() Functions
213830 XL2000: Error Using For Each...Next Statement with OLE Object Type
213831 XL2000: Macro to Check for Page Breaks on a Worksheet
213832 XL2000: How to Hide Button Controls with Visual Basic for Applications
213833 XL2000: Creating Macros for Different Language Versions
213834 XL2000: Inconsistent Formatting When You Use VBA Borders Method
213835 XL2000: ShowDataForm Method Fails if Data Cannot Be Found
213836 Update remote references check box is usually selected in Excel 2003 and in earlier versions of Excel