Open workbook with unreadable content

J

Jacque

I have a macro that loops thorugh a bunch of workbooks, opens them, copies
data in them, and pastes that data in the workbook I'm working in. One of
the workbooks always has an error message when it's opened manually that says
"Excel found unreadable content... do you want to recover..." 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'
failed".

I've already tried disabling the display alerts. Right now my code to open
the workbook reads:

Application.DisplayAlerts = False
Workbooks.Open Filename:=update_file_location
Application.DisplayAlerts = True

Any ideas to fix this problem? I appreciate the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
WordPad blocked content 2
Active Content in this file is blocked issue 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Workbook which having unreadable contents is not getting opened 1
Excel found unreadable content in file error. 0
Save workbook without shapes 0
excel found unreadable content' error is coming while opening xlsx file 0

Top