How to suppress XML import error message
 

I am using Excel 2003 under Vista.

I have a worksheet with several XML tables imported from the web and I use a
macro to refresh all the tables. Sometimes I'd get this error message:

Microsoft Office Excel encountered errors when importing the following
files:

Source: http://www.abc.com
Error: Some data was imported as text
Import Status: Complete

The thing is this error doesn't really matter to me. As long as the import
is complete, it's OK. I don't want to see this message when running the
macro. I tried "On Error Resume Next" but the error message is still
displayed. Is there any way I can make the message go away?

Thanks.

How to suppress XML import error message
 

Perhaps Application.DisplayAlerts = False

Mike F
"Shatin" wrote in message
...
I am using Excel 2003 under Vista.

I have a worksheet with several XML tables imported from the web and I use
a macro to refresh all the tables. Sometimes I'd get this error message:

Microsoft Office Excel encountered errors when importing the following
files:

Source: http://www.abc.com
Error: Some data was imported as text
Import Status: Complete

The thing is this error doesn't really matter to me. As long as the import
is complete, it's OK. I don't want to see this message when running the
macro. I tried "On Error Resume Next" but the error message is still
displayed. Is there any way I can make the message go away?

Thanks.