Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Excel 2000 SR-1 Eurotool Add-in
 

The administrative version of the Excel 2000 SR-1 Eurotool Add-in enables you to configure computers to work with the Euro currency in Microsoft® Excel 2000. With this add-in, you can convert and format European Union currency as you work with other world currencies.


 Note   To use the Excel 2000 SR-1 Eurotool Add-in, you must first upgrade your computers to Office 2000 Service Release 1a (SR-1a).



Toolbox The administrative version of the Excel 2000 SR-1 Eurotool Add-in consists of two Windows Installer patch files (MSP format) packaged in one self-extracting executable. You can find this downloadable file on the Office 2000 Resource Kit Downloads page.


Applying the 2000 SR-1 Eurotool Add-in to an administrative installation point

You apply the Excel 2000 SR-1 Eurotool Add-in to your administrative share by using a command line with specific parameters. When you run the update, you'll need to apply two separate MSP files to refresh all of the related components. The following table lists the MSP files.

MSP file name Description
EUROTOOL_Admin.msp Windows Installer update for the Euro currency tools.
XLEURO_Admin.msp Windows Installer update for the Excel Help file.


 Note   For best results, the update files should be applied from the console of the computer containing the administrative installation point. Make sure that the files on the share point are not in use when the updates are being applied. If there are multiple administrative installation points, you may replace the remaining administrative installation points with the updated administrative installation point after backing up any custom transform, Setup.ini, or other files on the share points.


To apply the Excel 2000 SR-1 Eurotool Add-in to an administrative installation point

  1. Download Eurupd_a.exe and double-click the file name to extract the two administrative update files. Refer to the table above for the file names and descriptions.
  2. Connect to the server share for the administrative installation point.

    You must have write access to the administrative installation point on the server and the appropriate privileges to carry out the task.

  3. On the Start menu, click Run and then type the command line for Windows Installer with the appropriate options for the Excel 2000 SR-1 Eurotool Add-in. Use the following syntax:

    [start] msiexec /p [path\name of update MSP file] /a [path\name of MSI file] SHORTFILENAMES=TRUE /qb /L* [path\name of log file]

You will need to run the command line separately for each MSP file that you apply to the administrative installation point — you cannot reference multiple MSP files on the same command line. The following table describes the command-line options.

Command-line option Description
[start] Required only for Microsoft Windows® 95 or 98 systems where Msiexec is not directly in the path.
msiexec Executable file name for Windows Installer.
/p Enables Windows Installer to apply an update to an existing installation.
[path\name of update MSP file] Path and file name of the MSP file for the files you want to update. For a list of MSP file names, refer to the table earlier in this document.
/a Enables Windows Installer to perform an administrative installation of a product on a network share.
SHORTFILENAMES=TRUE Directs Windows Installer to create all file names and folders with MS-DOS compatible file names, as used on Office 2000 Disc 1. Required when you run Windows Installer from the command line.
/qb Sets the user interface to the basic level (simple progress and error handling). This switch is optional on the command line.
/L* Turns on logging and sets a path for the log file. The * flag causes the switch to log all information. This switch is optional on the command line.
[path\name of log file] Path and file name of the Windows Installer log file.

Updating client computers from an administrative installation point

After you update your administrative installation point, you must perform a recache and repair on existing client computers that use the administrative image. Any new client installations from the administrative installation point will automatically include the Excel Eurotool updates.

To update an existing client installation from an administrative installation point, run the following command line on the client computer:

start msiexec /i [path to updated .msi file on the administrative image] REINSTALL=[list of features] REINSTALLMODE=vomus

You can run this command line by creating a log-on script, distributing it as a batch file, deploying it via Systems Management Server, or using other means according to your practice. The options for this command line are as follows.

Command-line option Description
[start] Required only for Windows 95 or 98 systems where Msiexec is not directly in the path.
Msiexec Executable file name for Windows Installer.
/i Enables Windows Installer to apply an update to an existing installation.
[path to updated .msi file on the administrative image] Path and file name of the Microsoft Installer (.MSI) file on the administrative installation point.
REINSTALL =[list of features] Specifies whether you want to reinstall specific features or reinstall all applications on the administrative image.
REINSTALLMODE=vomus Triggers the recache and reinstallation on the client computer.
/q Suppress the End User License Agreement dialog box so administrators or end users will not be prompted by this dialog box.

For the Excel 2000 SR-1 Eurotool Add-in, the value for [list of features] will vary depending on the patched administrative image MSI file.

  • For updating any CD1 Data1.msi:
    ExcelAddInEuroToolFiles,ProductNonBootFiles,ExcelHelpFiles
  • For updating CD2 Data2.msi:
    CD2NonBootFiles
  • For updating the AccessRuntime Data1.msi:
    AccessRuntimeMaster

 Note   The Msoeuro.dll file is updated on CD2 and the AccessRuntime.


Optionally, you can substitute the parameter REINSTALL=ALL to reinstall all components on the client computer.


 Note   If you originally installed Office 2000 on a client computer from an administrative installation point, you must follow the recache and repair procedure described above to update that client. If you update the client directly by using the end-user patch from the Office Update Web site, the client and administrative images will become out-of-sync, which may cause future updates to fail.


Applying the Excel 2000 SR-1 Eurotool Add-in under Windows 2000

If your administrative installation point and all of your client computers are running Windows 2000, you can use IntelliMirror® technology to manage the installation of the add-in.


 Note   Be sure to test all software updates in a controlled setting before modifying your administrative installation point or deploying the new version throughout your organization.


To deploy a QFE fix or update under Windows 2000

  1. Apply the updates (MSP files) to the original Office administrative installation point.

    You will need to run the command line separately for each MSP file that you apply to the administrative installation point — you cannot reference multiple MSP files on the same command line.

  2. Open the Software Installation snap-in within the Group Policy Object (GPO) that you are using to manage the existing Office installation.
  3. In the details pane, right-click the Office package, point to All Tasks, and click Redeploy application.

    The next time the Group Policy is applied to the designated users or computers, the updated files are copied to their computers.


 Note   You can redeploy a package only if it is being managed by Group Policy — that is, only if you originally installed it by using IntelliMirror software installation and maintenance or if you brought it into a managed state under Windows 2000.


Related links

For information on deploying the Office 2000 SR-1a Update, see Deploying Office 2000 Service Release 1 in the Office Resource Kit Journal. For information on determining whether the Excel 2000 SR-1 Eurotool Add-in has been installed on a computer, see HOW TO: Obtain and Install the Excel 2000 SR-1 Eurotool Add-In Update in the Microsoft Knowledge Base.

advertisement