I save a workbook with workbooks(<filename).close savechanges := TRUE and
any cell formatting is lost. I've traced the circumstances to the version of
Excel the original <filename was created in. If the file was version 4.0
formatting is lost (even if it's been subsequently saved as the 'latest Excel
version') otherwise it's OK. Given that I can have no influence on the Excel
version of the original file is there anyway of saving my formatting changes
(I'm only interesting in the colorindex). Also how can I tell what the
original Excel version was from within VB (or elsewhere) - The above applies
to XP, NT and windows 2000. I'm using office 2000 in all cases. Thanks.