Some of the workbooks always has an error message when it's opened manually
that says


"Excel found unreadable content in "filename". Do you want to recover the
contents of this workbook? If you trust the source of this workbook,ckick
Yes."

and when I click "Yes" the workbook opens just fine. However, when I try to
open it with VBA, I get an error message saying "Method 'Open' of objects
'Workbooks'class failed".

Please help me out,it is very urgent

Thanks in Advance