Exporting Excel 97 to Excel 2000/2002
 

Hi there,

Can anybody help me out on the issue of exporting this excel file?

I have one excel file created using Ms Excel version 97. There are som
worksheets, macros and other automated processes involved in each o
these worksheets. What I were trying to do is, to export this exce
file to Ms Excel 2000/2002 since I am no longer using the older versio
of Ms Excel.

However, when I tried to export all of the data in this Excel 97 t
Excel 2000/2002, the column’s width becomes much bigger that it'
original file. This issue can become quite annoying, especially when
have quite a number of worksheets. I've tried many things and tricks
but still no luck.

Just wondering if there is a way to overcome this issue?
Perhaps using VBA coding, macros or other means.

Please kindly advice and help on this.
Thanks a lot.


- Mari

--
Message posted from http://www.ExcelForum.com

Exporting Excel 97 to Excel 2000/2002
 

I don't understand what you mean by exporting xl97 to xl2k/xl2002.

You should be able to just open the file in the newer version of excel--no
importing required.



"mario88 <" wrote:

Hi there,

Can anybody help me out on the issue of exporting this excel file?

I have one excel file created using Ms Excel version 97. There are some
worksheets, macros and other automated processes involved in each of
these worksheets. What I were trying to do is, to export this excel
file to Ms Excel 2000/2002 since I am no longer using the older version
of Ms Excel.

However, when I tried to export all of the data in this Excel 97 to
Excel 2000/2002, the column’s width becomes much bigger that it's
original file. This issue can become quite annoying, especially when I
have quite a number of worksheets. I've tried many things and tricks,
but still no luck.

Just wondering if there is a way to overcome this issue?
Perhaps using VBA coding, macros or other means.

Please kindly advice and help on this.
Thanks a lot.

- Mario

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson