I have created a file in office 2003. I have kept certain colums as
'Date', certain as 'Number' etc. In short, cell formatting has been
applied in the file.

Now I am opening this file in a PC which has office 2007. I can see all
the cell formatting in this file even in excel 2007.

Now I am saving this file as .xslm format on that PC.

Now when I am opening this file, 90% of the cell formats have been
vanished while 10% are still there . I dont know why I m losing out
certain formats in tehre ..

*** Sent via Developersdex http://www.developersdex.com ***

How are you saving it as an XLSM? Manually or with code? I ask because I
had strange things happen when I saved programmatically using the wrong
syntax.

Barb Reinhardt


"soham shah" wrote:

I have created a file in office 2003. I have kept certain colums as
'Date', certain as 'Number' etc. In short, cell formatting has been
applied in the file.

Now I am opening this file in a PC which has office 2007. I can see all
the cell formatting in this file even in excel 2007.

Now I am saving this file as .xslm format on that PC.

Now when I am opening this file, 90% of the cell formats have been
vanished while 10% are still there . I dont know why I m losing out
certain formats in tehre ..

*** Sent via Developersdex http://www.developersdex.com ***