Turning off Excel Error Message for Web Query

[Look]

I'm using an excel web query to search for data through an online form. The input for this query is eventually going to be dynamic as part of a larger project, and I am expecting some of the input data used to not appear in the online database. When this occurs, excel comes back with an error popup, "The Web Query returned no data...".

Is there any way to stop this error message from appearing?

I've uploaded a sample of what I'm doing. Thanks in advance for any advice!

 

[SirJB7]

Hi, Look!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, these comments.
a) You uploaded a .xlsx file which has stored the data connection for the web query. With this file types that doesn't allow VBA I don't know how to remove that message; so check the .xlsm version that includes the code for the web query where the message doesn't pop up.
b) If you're using Excel 2013 (and I don't recommend so except for these functions WEBSERVICE & Co.:
http://chandoo.org/forum/threads/ch...iving-in-borrowed-time-by-2013-version.14296/) you replace with a simple formula what up to 2010 version you had to do with either a stored or macro query.
Give a look to these worksheets:
UPCDataBaseWebQuery: it's the macro version of your embedded query (no web service use)
BBCWeather: no API Key required (http://cwebbbi.wordpress.com/2012/07/31/using-the-webservice-function-in-excel-2013/)
WUnderGround: API Key required, free registration (http://blogs.office.com/2013/03/21/...ate-excel-2013-spreadsheets-with-online-data/)
UPCDataBase: API Key required, free registration (http://www.upcdatabase.com/xmlrpc.asp), but in this case the documentation is brief and incomplete, there're no VBA samples of the final URL string to be build, there're no links (I haven't found them) about it, so I recommend to try to contact the webmaster at the email at the posted link. If you happen to find how it works, please do come back here and tell us.

Uploaded file with samples.

Hope it helps.

Regards!