How to suppress XML import error message

S

Shatin

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.
 

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

Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
XML schema import problem 2
xml import error 1
custom error message 4
suppress macro messages 1
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
Excel found unreadable content in file error. 0
XML Web Imports 0

Top