Microsoft KB Archive/73648

{| = AppNote Reference: EPU (Excel and Project) =
 * width="100%"|

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 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 &quot;Jet Error Help File (MSJETERR.HLP)&quot; (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 &quot;15-Digit Number Patch for Version 5.0c&quot; (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 &quot;absolute reference&quot; and &quot;relative reference&quot; 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 &quot;User's Guide 1,&quot; 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 &quot;Introduction to Custom Dialog Boxes&quot; (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 &quot;Standard Securities Calculation Methods,&quot; 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.


 * }