View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vinod vinod is offline
external usenet poster
 
Posts: 23
Default Macro saved .xls file is not opening in 2007

Hi All,

I've asked the below quesion in another post but I didn't get solution. Let
me try one more time.

I'm using a Macro which will open a template with predefined formulas and
copies selected sheet data into template. After coping, template will be
calculated with copied data after this template will save as Output.xls and
closes the saved file. By this macro functionality is completed.

Here is the sample code:
set wbkTemplate=workbook.open("C:\Template.xls",false)
Copying input sheet data into 'RawData' of wbkTemplate.

wbkTemplate.SaveAs "C:\Output.xls"
wbkTemplate.close
set wbkTemplate=Nothing


While opening output.xls I'm getting following error:
The file you are trying to open, 'Output.xls', is in a different format than
specified by the files extension. Verify that the file is not corrupted and
is from trusted source before opening the file. Do you want to open the file
now?

On clicking 'Yes' Output.xls is opening machine language.

We observed this above error while running macro at excel 2007. Origionally
the macro is developed and tested at excel 2003 without issue.

Please helpme out on resolving above said issue by sharing your thoughts and
ideas which will be appreciated.

Advanced Thanks
Vins