Microsoft KB Archive/211561

= HOW TO: Convert an Add-in File into a Workbook in Excel 2000 =

Article ID: 211561

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211561



For a Microsoft Excel 97 version of this article, see 156943.

IN THIS TASK
SUMMARY
 * Convert Add-in to Workbook

REFERENCES



SUMMARY
This step-by-step article describes how to convert an add-in (.xla) file into a normal workbook (.xls) file that you can view and edit.

back to the top

Convert Add-in to Workbook
To convert an add-in file back into a normal workbook, follow these steps:  On the File menu, click Open. In the Open dialog box, select the add-in file that you want to convert (for example, Test.xla), and then click Open. On the Tools menu, point to Macro, and then click Visual Basic Editor (or press ALT+F11).

In the Project Explorer window in the Visual Basic Editor, entries similar to the following appear

where  is the name of the Visual Basic project, and   is the name of an add-in file.

For example, entries similar to the following appear:

MyAddIn (Test)

 Click the plus sign (+) to the left of the entry for the add-in file.  If you are prompted for a password, type the password and click OK. Otherwise, proceed to step 5.

NOTE: If you do not know the password for the add-in file, you cannot convert it into a normal workbook. If you know who created the add-in file, ask the creator for the password. Otherwise, you cannot continue.

Entries similar to the following appear in the Project Explorer window: MyAddIn (Test) Microsoft Excel Objects Modules   Click the plus sign (+) to the left of Microsoft Excel Objects.

The tree should look similar to the following:   MyAddIn (Test) Microsoft Excel Objects Sheet1 (Sheet1) Sheet2 (Sheet2) Sheet3 (Sheet3) ThisWorkbook Modules  Click ThisWorkbook.</li> On the Tools menu, click  Properties.</li> Click the Protection tab. Clear the Lock project for viewing check box. Clear both the Password box and Confirm password box, and then click OK.</li> In the Properties window of the Visual Basic Editor, click IsAddin. In the box to the right of IsAddin, change the value from True to False.</li> On the File menu, click Close and Return to Microsoft Excel.

The worksheets and chart sheets in the add-in file (if it contains any) should be visible.</li> On the File menu, click Save As.</li> In the Save As dialog box, click Microsoft Excel Workbook in the Save as type list. Type a new name for the workbook (for example, Test.xls) in the File name box. Click Save to save the add-in file as a normal workbook.</li> After you save the workbook, click Close on the File menu.</li></ol>

The add-file is converted to a workbook that can be opened, viewed, modified, and saved, just like any other workbook. Note that the add-in file is not modified by this process.

back to the top

<div class="references_section">