Macro saved .xls file is not opening in 2007

[Vinod]

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

 

[Homey]

You getting new file format with old file extension. Do this instead:

wbkTemplate.SaveAs "C:\Output", xlWorkbookNormal

Excel put on right file extension if you tell it right format.

| 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
|

 

[Vinod]

Thanks for your response.

Do you mean that it should be
wbkTemplate.SaveAs "C:\Output.xls", xlWorkbookNormal
for saving in excel 2003 version?