Microsoft KB Archive/181148

= XL97: Using the File Integration Wizard =

Article ID: 181148

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q181148





SUMMARY
An add-in for Microsoft Excel 97 for Windows that helps you to combine data from one or more worksheets into one workbook is available. The File Integration Wizard add-in provides functionality that is similar to the Lotus 1-2-3 file combine command.



MORE INFORMATION
The following file is available for download from the Microsoft Download Center:

Filecomb.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Introduction
The File Integration Wizard for Microsoft Excel 97 integrates (combines) data from one or more worksheets or from all worksheets in a selected workbook into the current workbook. You can combine any file format that Microsoft Excel can read. The wizard also allows you to perform operations on the combined data. These operations include the following:
 * Copy. Replaces text and values overwriting existing data.
 * Add. Adds numeric data from the selected file to the values in your workbook. Adds numeric data only and does not affect text. The File Integration Wizard discards incoming values when the value will overwrite a cell containing text. Also, when you use this operation, text in the extracted file is not admitted.
 * Subtract. Subtracts numeric data from the selected file from the values in your workbook. Subtracts numeric data only and does not affect text. The File Integration Wizard discards incoming values when the value will overwrite a cell containing text. Also, when you use this operation, text in the extracted file is not admitted.
 * Multiply. Multiplies numeric data from the selected file and the values in your workbook. Multiplies numeric data only and does not affect text. The File Integration Wizard discards incoming values when the value will overwrite a cell containing text. Also, when you use this operation, text in the extracted file is not admitted.
 * Divide. Divides numeric data from the selected file into the values in your workbook. Divides numeric data only and does not affect text. The File Integration Wizard discards incoming values when the value will overwrite a cell containing text. Also, when you use this operation, text in the extracted file is not admitted.

Installing and Using the Wizard
  Download the Filecomb.exe to your Desktop. Run the Filecomb.exe to extract the Filecomb.xla add-in and copy it into the Library folder for Microsoft Excel 97. This folder is usually located in the following folder:      C:\Program Files\Microsoft Office\Office\Library NOTE: You may now delete the file Filecomb.exe from your desktop.  In the Add-Ins dialog box of Microsoft Excel 97, click the File Integration Wizard check box, and then click OK. To run the File Integration Wizard, point to Wizard on the Tools menu and click File Integration. In step 1 of the wizard, click Browse to locate the file you want to integrate. You are prompted to save the current workbook. If you never saved the file, the Save As dialog box appears, otherwise the workbook is automatically saved. In step 2 of the wizard, click Entire File or Specified range. In the Cells to merge box, specify the range of cells you want to integrate, and then click Next.

Note: if you click Entire File, the current workbook must have at least the same number of worksheets as the workbook from which you are extracting data. In step 3 of the wizard, click an operation. By default, Copy is selected. In the cell range box, specify a single cell in which you want to begin integrating data, and then click Finish.</ol>

NOTE: The add-in discussed in this document is provided "as is" and Microsoft does not guarantee that it can be used in all situations. Although Microsoft support professionals can help with the installation and existing functionality of this add-in, they will not modify the add-in to provide new functionality.

NO WARRANTY. The software is provided "as-is," without warranty of any kind, and any use of this software product is at your own risk.

Additional query words: XL97

Keywords: KB181148

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.