Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default .xls file is not opening in excel 2007

Hi All,

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I stop a Excel 2007 file opening as read only? Will Excel Discussion (Misc queries) 1 August 31st 08 11:14 PM
Excel 2007 File not opening Nikhil Excel Discussion (Misc queries) 3 August 12th 08 11:56 AM
Excel 2007 Opening File Mary Fetsch Excel Discussion (Misc queries) 1 October 30th 07 04:42 PM
opening excel file in 2007 Alistair Excel Discussion (Misc queries) 13 October 13th 06 03:11 AM
Excel 2007 File Problems (Opening New Format) Grazen Excel Discussion (Misc queries) 2 July 21st 06 04:24 PM


All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"