I am using excel 2007. I am using few macros also. My application generates a
workbook (containing data and charts for the data) in .csv format. Saving
this in .xls format using excel 2003 worked fine. Opening this saved file
also worked fine.

When I try to save the same using excel 2007, the dialog is " file.csv
cannot be saved in current format. To save your changes, click OK and theb
save it as latest format."
Clicked OK and proceeded to save as .xlsx file , when I try to open this
saved file, the message seen is" Excel was able to open the file by
repairing or removing the unreadable content".

Often, the xml part of the workbook is removed. I am able to see only the
data and the charts are lost.

Is there any other way I can save the generated .csv file and reopen it
without losing data?

Any suggestions???

Thank you!!

By definition a .csv file is a simple ASCII (text) file and such files don't
have neat things like charts, pictures and macros. A .csv file is primarily
intended to be used as a means to exchange data between applications or
systems that don't share a native format but need to share the data, such as
between a spreadsheet program and a database or vice versa. They are also
used to provide data in a format that can be read by many applications - say
as a way of providing data on the internet that some people may want to
import into Access while others may wish to import into Excel and still
others may want to open in plain, vanilla Notepad.

Basically you need to keep two copies if you're going to need to work with
it again with its charts and macros: one .xlsm file and the .csv file.
Obviously you want to first save it in the .xlsm format first, then the .csv
format.

"DM" wrote:

I am using excel 2007. I am using few macros also. My application generates a
workbook (containing data and charts for the data) in .csv format. Saving
this in .xls format using excel 2003 worked fine. Opening this saved file
also worked fine.

When I try to save the same using excel 2007, the dialog is " file.csv
cannot be saved in current format. To save your changes, click OK and theb
save it as latest format."
Clicked OK and proceeded to save as .xlsx file , when I try to open this
saved file, the message seen is" Excel was able to open the file by
repairing or removing the unreadable content".

Often, the xml part of the workbook is removed. I am able to see only the
data and the charts are lost.

Is there any other way I can save the generated .csv file and reopen it
without losing data?

Any suggestions???

Thank you!!