Microsoft KB Archive/73648

AppNote Reference: EPU (Excel and Project) Last reviewed: September 18, 1996 Article ID: Q73648

SUMMARY The following is a list of the application notes currently available in the EPU group. EPU (EXCEL PROJECT UNIT) APPLICATION NOTES ========================================== MICROSOFT EXCEL Microsoft Excel for Windows 95 GF1201 FastTips Catalog No Disk Included Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: Not Available Last Update: 8/95 MSDL: Not Available FastTips: (800) 936-4100 WE1207 Upgrading Questions and Answers No Disk Included Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: S15511 Last Update: 8/95 MSDL: WE1207.EXE FastTips: (800) 936-4100 WE1208 Basic Use Questions and Answers No Disk Included Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: S15512 Last Update: 8/95 MSDL: WE1208.EXE FastTips: (800) 936-4100 WE1209 Printing Questions and Answers No Disk Included Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: S15513 Last Update: 8/95 MSDL: WE1209.EXE FastTips: (800) 936-4100 WE1210 Working with Shared Documents Questions and Answers No Disk Included Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: S15514 Last Update: 8/95 MSDL: WE1210.EXE FastTips: (800) 936-4100 WE1238 Jet Error Help File (Msjeterr.hlp) Disk Included Applies to Microsoft Excel for Windows 95, version 7.0 Software/Data Library: S15535 Last Update: 9/95 MSDL: WE1238.EXE FastTips: Not Available The Application Note "Jet Error Help File (MSJETERR.HLP)" (WE1238) is now available from Microsoft Product Support Services (PSS). The WE1238 disk included with this Application Note contains the Jet Error Help file, Msjeterr.hlp, for use with Microsoft Excel for Windows 95. WE1254 15-Digit Number Patch for Version 5.0c Disk Included Applies to Microsoft Excel for version 5.0c Windows Software/Data Library: S15575 Last Update: 12/95 MSDL: WE1254.EXE FastTips: Not Available The Application Note "15-Digit Number Patch for Version 5.0c" (WE1254) is now available from Microsoft Product Support Services (PSS). The disk included with this Application Note contains a patch that corrects problems you may encounter when you enter the following numbers in a Microsoft Excel worksheet: 140737488355328 281474976710656 562949953421312 NOTE: You can obtain the Microsoft Excel for Windows 95, version 7.0, version of this patch (XL15link.exe) from online services or by calling Microsoft Product Support Services (request part 065-054-S61). For more information about this patch, please see the following article in the Microsoft Knowledge Base: ARTICLE-ID: Q128650 TITLE  : XL7 Patch Available: 15-Digit Number, Linking, and Transpose WE1277 Visual Basic for Applications Equivalents for Lotus 1-2-3 Macro Commands Available ONLY through Online Services. Not available in OE. Applies to Microsoft Excel version 7.0 for Windows 95 Software/Data Library: S15868 Last Update: 03/96 MSDL: WE1277.EXE FastTips: Not available. Application Note WE1277 contains equivalent macro code in Visual Basic for Applications for most Lotus 1-2-3 macro functions. Microsoft Excel for Windows and Macintosh NOTE: AppNotes that begin with the prefix XE apply to Excel for both Windows and Macintosh. XE0124 Regression Analysis and Best Fit Lines [NOTE: This replaces WE0124 and WE0126] No Disk Included Applies to Microsoft Excel 3.0, 4.0, 4.0a Software/Data Library: Not Available Last Update: 8/93 MSDL: XE0124.EXE (Windows); XE0124.SEA (Macintosh) FastTips: Not available This Application Note discusses how to use Microsoft Excel functions to perform simple, multiple, and polynomial regression analysis. It contains examples of how to use LINEST(), LOGEST(), TREND(), and GROWTH() to describe a best fit line or curve and to make predictions about your data. It also outlines some of the new statistical functions and tools available with Microsoft Excel version 4.0. XE0125 Cell Referencing from a Macro [NOTE: AppNote WE0125 was deleted and replaced with XE0125] No Disk Included Applies to Microsoft Excel versions 3.0, 4.0 Software/Data Library: Not Available Last Update: 8/93 MSDL: XE0125.TXT (Windows); XE0125.SEA (Macintosh) FastTips: Not Available This Application Note outlines how to reference cells from a macro and discusses the A1 and R1C1 reference styles. It includes tables that define terms such as "absolute reference" and "relative reference" and contains descriptions of specific macro functions and the types of cell referencing they will accept. XE0127 Using Dates and Times [NOTE: AppNote WE0127 was deleted and replaced by XE0127] No Disk Included Applies to Microsoft Excel versions 1.0, 1.03, 1.04, 1.06, 1.5, 2.2, 3.0, and 4.0, for the Macintosh; and to Microsoft Excel versions 2.0, 2.1, 2.1c, 2.1d, 3.0, and 4.0, for Windows Software/Data Library: Not Available Last Update: 6/93 MSDL: XE0127.TXT FastTips: (800) 936-4100 This application note describes how to use new and existing date and time functions in Microsoft Excel 4.0 and earlier versions, for both Windows and Macintosh. It also describes how dates and times are stored. XE0183 Tips for Manipulating the Data in a Chart (Replaces ME0183) No Disk Included Applies to Microsoft Excel versions 3.0, 4.0, and 4.0a for Windows and Microsoft Excel versions 3.0 and 4.0 for the Macintosh Software/Data Library: Not Available Last Update: 11/93 MSDL: Pending FastTips: Not Available This Application Note provides and overview of how values are plotted in a chart and discusses how to add information to and delete information from a chart, how to make a chart independent from a worksheet, and how to add data point labels to a chart. XE0186 Database Tips [NOTE: AppNote ME0186 was deleted and replaced by XE0186] No Disk Included Applies to Microsoft Excel versions 2.x, 3.0, and 4.0 for Windows, and to Microsoft Excel versions 2.2, 3.0, and 4.0 for the Macintosh. Software/Data Library: Not Available Last Update: 5/93 MSDL: XE0186.TXT FastTips: (800) 936-4100 This Application Note describes how you can more productively use the database features of Microsoft Excel. XE0210 Creating and Using Tables [NOTE: AppNote number ME0210 was deleted and replaced by XE0210] No Disk Included Applies to Microsoft Excel versions 2.x, 3.0, 4.0, and 4.0a for Windows and Microsoft Excel versions 1.0, 1.03, 1.04, 1.06, 1.5, 2.2, 3.0, and 4.0 for the Macintosh Software/Data Library: Not available Last Update: 5/93 MSDL: XE0210.TXT FastTips: (800) 936-4100 This Application Note describes how to create one-input and two-input data tables using the Table command on the Data menu. It also discusses how you can use one-input and two-input tables to evaluate database information obtained using database functions and comparison or computed criteria. XE0449 Using Dynamic Dialog Boxes No Disk Included Applies to Microsoft Excel versions 3.0 and 4.0 for Windows, and 3.0 and 4.0 for the Macintosh Software/Data Library: Not Available Last Update: 12/93 MSDL: XE0449_W.EXE(MS-DOS/Windows) or XE0449_M.SEA (Macintosh) FastTips: Not Available This Application Note discusses how to create a dynamic dialog box and provides a sample dialog box definition table and sample macro code you can use to activate the dialog box. It also provides an example of one way you can retrieve information from a dynamic dialog box and enter that information into a database. NOTE: This Application Note is a cross-platform update to the earlier WE0449. XE0696 Using Microsoft Excel Workbooks [NOTE: AppNote WE0696 was deleted and replaced by XE0696] No disk included Applies to Microsoft Excel version 4.0 Software/Data Library: S14076 MSDL: XE0696.TXT FastTips: (800) 936-4100 This application note describes how to use Microsoft Excel version 4.0 workbooks, which are documents in which you store other Microsoft Excel documents or references to them. Workbooks replace Microsoft Excel version 3.0 workspaces. XE0800 Most Frequently Asked Questions No Disk Included Applies to Microsoft Excel version 4.0 Software/Data Library: Pending Last Update: 7/93 MSDL: XE0800.EXE (Windows); XE0800.SEA (Macintosh) FastTips: Not Available This Application Note provides detailed responses to some of the most frequently asked questions about Microsoft Excel version 4.0. The questions, which were derived from polling members of the Microsoft Excel technical support staff, are broken into eight functional categories. These categories include, tips and tricks, printing, working with text files, formulas and functions, macros, workbooks, and working with other applications. XE0872 Creating a Crosstab Table with the Crosstab ReportWizard No Disk Included Applies to Microsoft Excel version 4.0 Software/Data Library: S14946 Last Update: 11/93 MSDL: XE0872.EXE FastTips: Not Available This Application Note demonstrates how to use the Crosstab ReportWizard to create a crosstab table that resembles the one pictured on page 349 of "User's Guide 1," version 4.0. XE0923 Basic Use Questions and Answers No Disk Included Applies to Microsoft Excel version 5.0 for Windows Software/Data Library: Not Available Last Update: 10/93 MSDL: XE0923.TXT FastTips: (800) 936-4100 XE0924 Printing Questions and Answers No Disk Included Applies to Microsoft Excel version 5.0 for Windows Software/Data Library: Not Available Last Update: 10/93 MSDL: XE0924.TXT FastTips: (800) 936-4100 XE0925 Working with Charts Questions and Answers No Disk Included Applies to Microsoft Excel version 5.0 for Windows Software/Data Library: Not Available Last Update: 10/93 MSDL: XE0925.TXT FastTips: (800) 936-4100 XE0926 List Management and Data Analysis Questions and Answers No Disk Included Applies to Microsoft Excel version 5.0 for Windows Software/Data Library: Not Available Last Update: 10/93 MSDL: XE0926.TXT FastTips: (800) 936-4100 XE0927 Using Macros Questions and Answers No Disk Included Applies to Microsoft Excel version 5.0 for Windows Software/Data Library: Not Available Last Update: 1/96 MSDL: XE0927.TXT FastTips: (800) 936-4100 XE0938 Introduction to Custom Dialog Boxes No Disk Included Applies to Microsoft Excel version 4.0 for Windows and version 4.0 for the Macintosh Software/Data Library: Not Available Last Update: 2/94 MSDL: XE0938_W.EXE (Windows) or XE0938_M.SEA (Macintosh) FastTips: Not Available The "Introduction to Custom Dialog Boxes" (XE0938) Application Note shows you how to use the Dialog Editor to create a custom dialog box and provides sample macro code to display it. XE0962 Equations for Financial Functions No Disk Included Microsoft Excel versions 3.0, 4.0, and 4.0a for Windows, and Microsoft Excel versions 3.0 and 4.0 for Windows Software/Data Library: S14822 Last Update: 11/94 MSDL: XE0962.EXE FastTips: Not Available This Application Note describes the formulas used in the financial functions that are included with Microsoft Excel versions 3.0, 4.0, and 4.0a. The theories that these formulas are derived from are based on information in the "Standard Securities Calculation Methods," published by the Securities Industry Association, 120 Broadway, New York, NY. Microsoft Excel for the Macintosh GF0895 FastTips Catalog No Disk Included Applies to Microsoft Excel version 4.0 for the Macintosh Software/Data Library: Not Available Last Update: 8/27/93 MSDL: Not Available FastTips: (800) 936-4100 ME0185 Using Custom Help Applies to Excel for the Macintosh versions 2.2, 3.0, and 4.0 Software/Data Library: ME0185, S12983 ME0185 Using Custom Help No Disk Included Applies to Microsoft Excel versions 2.2, 3.0, and 4.0 for the Macintosh Software/Data Library: S12983 Last Update: 3/93 MSDL: ME0185.SEA FastTips: Not Available This AppNote describes how to use the custom help feature in Excel 2.2, 3.0, and 4.0. ME0188 Entering Formulas Applies to Excel for the Macintosh versions 1.0, 1.03, 1.04, 1.06, 1.5, 2.2, and 3.0 Software/Data Library: Not available Describes how to enter formulas into Excel. ME0197 Text Concatenation Applies to Excel for the Macintosh versions 1.0, 1.03, 1.04, 1.06, 1.5, 2.2, and 3.0 Software/Data Library: ME0197, S12995 Describes how to concatenate (string together) several text values. ME0333 Using Pascal Code Resources Disk included Applies to Excel for the Macintosh, version 2.2 Software/Data Library: ME0333.SEA, S13009 MSDL: Yes FastTip: Not Available Describes how Excel can use external Pascal code after that code has been compiled as a resource. The disk contains code examples. ME0570 Charting Questions & Answers No Disk Included Applies to Excel for the Macintosh, version 3.0 Software/Data Library: Not available MSDL: Yes FastTip: (800) 936-4100 (800) 936-4100 ME0571 Installing Questions & Answers No Disk Included Applies to Excel for the Macintosh, version 3.0 Software/Data Library: Not available MSDL: Yes FastTip: (800) 936-4100 ME0572 Printing Questions & Answers No Disk Included Applies to Excel for the Macintosh, version 3.0 Software/Data Library: Not available MSDL: Yes FastTip: (800) 936-4100 ME0573 Updating Questions & Answers No Disk Included Applies to Excel for the Macintosh, version 3.0 Software/Data Library: Not available MSDL: Yes FastTip: (800) 936-4100 ME0574 Usage Questions & Answers No Disk Included Applies to Excel for the Macintosh, version 3.0 Software/Data Library: Not available MSDL: Yes FastTip: (800) 936-4100 ME0802 Opening and Saving Text Files Disk Included Applies to Microsoft Excel version 4.0, for the Macintosh Software/Data Library: S14205 Last Update: 7/93 MSDL: N/A FastTips: (800) 936-4100 This Application Note discusses how Microsoft Excel parses text and formats numbers and alphanumeric characters in text files. The ME0802 disk included with this Application Note contains the Text Reader add-in macro, which you can use to import text files. This macro parses your text according to a delimiter you select and prevents Microsoft Excel from applying automatic number formatting to the entries in your file. ME0858 Generating Smooth Curves in Charts Disk Included Applies to Microsoft Excel version 4.0 for the Macintosh Software/Data Library: S14353 Last Update: 9/93 MSDL: ME0858.SEA FastTips: Not Available This Application Note includes two add-in macros that use the interpolation method to generate smooth curves in charts. Microsoft Excel for Windows GF0897 FastTips Technical Library Catalog No Disk Included Applies to Microsoft Excel 4.0 for Windows Software/Data Library: Not Available Last Update: 12/16/94 MSDL: Not Available FastTips: (800) 936-4100 GF0953 FastTips Technical Library Catalog No Disk Included Applies to Microsoft Excel 5.0 for Windows Software/Data Library: Not Available Last Update: 5/95 MSDL: Not Available FastTips: (800) 936-4100 WE0107 HPPCL Driver and HP Cartridge Support Disk included Applies to Excel for Windows version 2.1 Software/Data Library: WE0107, S13565 Contains a revised Windows PCL/HP LaserJet driver (version 3.2b), which includes support for the HP LaserJet IIP; the disk also contains new HP font cartridge support add-on files for the HPPCL driver. WE0145 Importing Excel Graphics into Word Software/Data Library: Not available Discusses methods of importing graphics from Excel to Microsoft Word for MS-DOS version 5.0. WE0404 Excel Custom Help File Conversion Utility Disk included Software/Data Library: WE0404, S12923 MSDL: WE0404.EXE Last Update: 2/91 Contains a utility for creating custom Help for Excel applications. WE0500 A Practical Guide to Using Q+E, Part I (Also see WE0821) Article truncated.

Last reviewed: September 18, 1996 © 1998 Microsoft Corporation. All rights reserved. Terms of Use.