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

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

" wrote:

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

On 17 Oct, 14:37, Joel wrote:
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



" wrote:
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- Hide quoted text -

- 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.

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.

" wrote:

On 17 Oct, 14:37, Joel wrote:
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



" wrote:
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- Hide quoted text -

- 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.

On 17 Oct, 15:28, Joel wrote:
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.



" wrote:
On 17 Oct, 14:37, Joel wrote:
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

" wrote:
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- Hide quoted text -

- 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.- Hide quoted text -

- Show quoted text -

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