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

Try

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

--
Tim Williams
Palo Alto, CA


"Guilherme Soares" <(E-Mail Removed)> wrote in message
news:731E5D00-C471-46E6-828F-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:731E5D00-C471-46E6-828F-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:00492ABF-2C00-40C0-A9CC-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:731E5D00-C471-46E6-828F-(E-Mail Removed)...
> > > 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
> >
> >
> >

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" <(E-Mail Removed)> wrote in message
> news:00492ABF-2C00-40C0-A9CC-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > > news:731E5D00-C471-46E6-828F-(E-Mail Removed)...
> > > > 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
> > >
> > >
> > >
>
>
>

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" <(E-Mail Removed)> wrote in
message news:6B0F5882-02D9-42F8-A198-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in
>> message
>> news:00492ABF-2C00-40C0-A9CC-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote
>> > > in message
>> > > news:731E5D00-C471-46E6-828F-(E-Mail Removed)...
>> > > > 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
>> > >
>> > >
>> > >
>>
>>
>>