Opening workbook - get error message : unreadable content, lostvbproject

M

macmeldrum

Dear All,

I am opening a workbook and on opening I am disabling macros and
opening read-only. I also have enableEvents set to false.

The problem I have is the file I am opening give an error message
saying the that these is unreadable content. When I press ok I get
message saying lost vb content.

If I open the file outside vba (the excel) it asks me to enable macros
but there is no vba projects.

Is there any way to suppress this message in vba (and indeed all
messages)

Thanks in advance

Mac
 
J

Joel

There is a microsoft application recovery tool that you can use. Depending
on which version of Office you have installed it may be in a slightly
different location. For Office 2003

Start - Microsoft Office - Microsoft Offfice Tools - Application Recovery.

Then select Excel Application
 
M

macmeldrum

There is a microsoft application recovery tool that you can use.  Depending
on which version of Office you have installed it may be in a slightly
different location.  For Office 2003

Start - Microsoft Office - Microsoft Offfice Tools - Application Recovery..

Then select Excel Application











- Show quoted text -

Thanks for your response. I would just like my vba routine to detect
the message and not open it and move onto the next line of code.
 
J

Joel

The two ways of bypassing errors are

Application.DisplayAlerts = False
On Error Resume Next

But I don't think the error you are getting can be bypassed.
 
M

macmeldrum

The two ways of bypassing errors are

Application.DisplayAlerts = False
On Error Resume Next

But I don't think the error you are getting can be bypassed.






- Show quoted text -

No I don't think so etiher. Thanks for your time Joel.
 

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

Top