Disabling error message with Web Query
 

Hi everyone,

I have developed an Excel Web Query that queries data from a web server and
put them into a database through VBA after refreshing. That query is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query shows an
error message box ("Unalbe to http://webserver... Cannot locate the internet
server..."). The poblem is when this box appears the After_Refresh method not
execute as long as somebody clicks on the "OK" command button of the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares

Disabling error message with Web Query
 

Try

Application.Displayalerts=False
'refresh query
Application.Displayalerts=True

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Hi everyone,

I have developed an Excel Web Query that queries data from a web server and
put them into a database through VBA after refreshing. That query is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query shows an
error message box ("Unalbe to http://webserver... Cannot locate the internet
server..."). The poblem is when this box appears the After_Refresh method not
execute as long as somebody clicks on the "OK" command button of the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares

Disabling error message with Web Query
 

Tim, thanks for your response.
You're almost there. But, not worked properly because the Refresh method
from web query is not triggered by a macro. It's a process that runs in
background (do you know how we can deal with it?). This property only disable
alert messages coming from macro.
Any other idea?

--
Guilherme Soares


"Tim Williams" wrote:

Try

Application.Displayalerts=False
'refresh query
Application.Displayalerts=True

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Hi everyone,

I have developed an Excel Web Query that queries data from a web server and
put them into a database through VBA after refreshing. That query is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query shows an
error message box ("Unalbe to http://webserver... Cannot locate the internet
server..."). The poblem is when this box appears the After_Refresh method not
execute as long as somebody clicks on the "OK" command button of the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares

Disabling error message with Web Query
 

Have you tried using a mcro to refresh the query instead of having it run automatically ?
You could use Application.OnTime()

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Tim, thanks for your response.
You're almost there. But, not worked properly because the Refresh method
from web query is not triggered by a macro. It's a process that runs in
background (do you know how we can deal with it?). This property only disable
alert messages coming from macro.
Any other idea?

--
Guilherme Soares


"Tim Williams" wrote:

Try

Application.Displayalerts=False
'refresh query
Application.Displayalerts=True

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Hi everyone,

I have developed an Excel Web Query that queries data from a web server and
put them into a database through VBA after refreshing. That query is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query shows an
error message box ("Unalbe to http://webserver... Cannot locate the internet
server..."). The poblem is when this box appears the After_Refresh method not
execute as long as somebody clicks on the "OK" command button of the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares

Disabling error message with Web Query
 

How can I do that? How can I trigger the Refresh method from the query?

--
Guilherme Soares


"Tim Williams" wrote:

Have you tried using a mcro to refresh the query instead of having it run automatically ?
You could use Application.OnTime()

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Tim, thanks for your response.
You're almost there. But, not worked properly because the Refresh method
from web query is not triggered by a macro. It's a process that runs in
background (do you know how we can deal with it?). This property only disable
alert messages coming from macro.
Any other idea?

--
Guilherme Soares


"Tim Williams" wrote:

Try

Application.Displayalerts=False
'refresh query
Application.Displayalerts=True

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in message
...
Hi everyone,

I have developed an Excel Web Query that queries data from a web server and
put them into a database through VBA after refreshing. That query is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query shows an
error message box ("Unalbe to http://webserver... Cannot locate the internet
server..."). The poblem is when this box appears the After_Refresh method not
execute as long as somebody clicks on the "OK" command button of the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares

Disabling error message with Web Query
 

Create the query with automatic refresh tuned off, then use the Refresh
method to update it.

activesheet.querytables("tablename").refresh

I haven't tested that this doesn't still show the dialog though....

Tim


"Guilherme Soares" wrote in
message ...
How can I do that? How can I trigger the Refresh method from the query?

--
Guilherme Soares


"Tim Williams" wrote:

Have you tried using a mcro to refresh the query instead of having it run
automatically ?
You could use Application.OnTime()

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote in
message
...
Tim, thanks for your response.
You're almost there. But, not worked properly because the Refresh
method
from web query is not triggered by a macro. It's a process that runs in
background (do you know how we can deal with it?). This property only
disable
alert messages coming from macro.
Any other idea?

--
Guilherme Soares


"Tim Williams" wrote:

Try

Application.Displayalerts=False
'refresh query
Application.Displayalerts=True

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" wrote
in message
...
Hi everyone,

I have developed an Excel Web Query that queries data from a web
server and
put them into a database through VBA after refreshing. That query
is running
in background and refreshes data every 30 minutes.
It happens the web server is not always available and the web query
shows an
error message box ("Unalbe to http://webserver... Cannot locate the
internet
server..."). The poblem is when this box appears the After_Refresh
method not
execute as long as somebody clicks on the "OK" command button of
the message
box.
Any idea to by pass this error message or making it not appear?

Regards,

--
Guilherme Soares