Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Excel 2000 Update: Programmatic Text Export

Brief Description
If you are using Microsoft Visual Basic for Applications in Excel 2000 to export files to TXT, PRN, CSV, or DIF formats (and you are not using Microsoft Windows 2000), you need to install this update.

On This Page

Quick Details
File Name:xl9p2pkg.exe
Version:2000
Date Published:12/29/1999
Language:English
Download Size:3.6 MB
Estimated Download Time: 9 min 56K
Change Language:
  

Overview

Microsoft has recently become aware of an issue found in Excel 2000 when users programmatically export a spreadsheet to a text file. Unless you are running Excel on a computer using Microsoft Windows® 2000, when you export a text file using the Excel object model (such as when using Microsoft Visual Basic® for Applications), dates are exported in the format "mm/dd/yy" (for example, 11/25/99 for November 25, 1999). If you are running Excel 2000 on a computer using an earlier version of Microsoft Windows, four-digit years are truncated to the two-digit year format regardless of the date format applied to the cell and the system date settings. This behavior only occurs when you use a macro or procedure to export to a text file, not when you manually save to a text file format. If you are using Visual Basic for Applications to export files to TXT, PRN, CSV, or DIF formats (and you are not using Windows 2000), you need to install this update. Note  This update also includes the Microsoft Excel 2000 SYLK File Security Update. If you are using Office 2000, this vulnerability has been addressed in Service Release 1 (SR-1). For more information, see Office 2000 Service Release (SR-1a) Frequently Asked Questions.


If you are currently using Excel 97, download the Microsoft Excel 97 Programmatic Text Export Update.


To ensure the integrity of your Office 2000 installation, the Excel 2000 Update: Programmatic Text Export requires access to the Office 2000 CD or your network installation location during the installation process.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000; Windows 95; Windows 98; Windows NT
  • This download works with the following Office applications:
    • Excel 2000

 Top of page

Instructions



To install this download

  1. You may want to print this page to use as a reference when you are offline.
  2. Download the file from this page by clicking the Download link above and following the instructions in the dialog boxes.
  3. Double-click the xl9p2pkg.exe program file on your hard disk to start the setup program.
  4. Follow the instructions on the screen to complete the installation.


Instructions for use:

Once you have completed the installation, simply use Excel as usual.

To remove this download:

There is no uninstall feature included with this download.

 Top of page

 Top of page

What Others Are Downloading

Others who downloaded Excel 2000 Update: Programmatic Text Export also downloaded:
  1. Excel 2000 Update: Analysis ToolPak Update for Leap Year
  2. Office 2000 Developer Service Release 1

 Top of page

© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement