Open files with error using VBA

[Snoopy2003]

Hello,

I have an excel application which gets input data by importing xls files.

My problem:

I get the xls files from a different system so I can not change the way the are created.

When I try to open the input files in excel 2007 I get the error: "Excel found an unreadable content ...choose yes to repair ..."
If I choose "yes" and let excel solve the problem, it opens the file. After opening the file, If I press "save" and open it again with excel 2007 there is no problem.

If I open the original data file in excel 2003 there is no problem.

I have a VBA macro which import the data file to my application.
How can I handle the error using VBA and open the file despite this error ?

Thank you for your help

[Snoopy2003]

Hello,

I will try to rewrite my question -
Is it possible to open xls files with excel 2007 vba in case excel finds unreadable content and suggest recover ?
Could my vba code choose "yes" and open the file despite the error ?

Thank you for your help