Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting to excel 2000 from online SQL database | Excel Discussion (Misc queries) | |||
Exporting Crystal 9 to Excel 2002 | Excel Discussion (Misc queries) | |||
Excel Macro exporting to MS-Project 2002 | Excel Programming | |||
VBA - Macro backward compatibility from excel 2002 to excel 2000 | Excel Programming | |||
Exporting data from Excel 2002 | Excel Programming |