Questions:
1. Can anyone think of a way to disable alerts on background queries when
the Excel application is in control. (please see below before answering that
I should set displayalerts = false).
2. Is there a timeout property that can be set on a web query.

This might seem a bit arcane, but is quite critical to a web data capture
routine. I need to turn off alerts WHILE excel, NOT vba is in control of
operations.

I have a vba routine that generates potentialy thousands of web queries in a
workbook. Madness I know but there is method. These queries run massively
quicker when they are performed as background queries - ie. once excel gets
back in control when the vba routine that built the queries has finished. I
have a timer running (ported from vb in an activex wrapper) that monitors
the progress of the queries, then runs some clean up routines when
everything has been completed.

Problems a
1. If there is an error at the server or in the query, Excel displays an
alert. VBA is not running at this point other than the periodic timer
routine, so displayalerts = false makes no difference to the error message
being displayed. Excel help has the following to say about displayalerts: If
you set this property to False, Micorosoft Excel sets this property to True
when the code is finished, unless you are running cross process code.
2. If the queries take too long, I get a time out error, also leading to
problem 1. And, once the errors start, they are hard to stop since the app
is halted for the error, meaning data returns are probably creating errors.

Finally, having spent ages trying to work out a robust timer solution in
vba, akin to the vb timer, I'll post the activex solution in the next few
days for general usage. If anyone would like to give it a whirl in the
meantime for a bit of testing, please let me know.

Thanks in advance,

Robin Hammond
www.enhanceddatasystems.com

Hi Robin
AFAIK you can't set this property to False outside VBA. As I'm not
using Web queries, don't they have a setting to omitt error messages?

--
Regards
Frank Kabel
Frankfurt, Germany


Robin Hammond wrote:
Questions:
1. Can anyone think of a way to disable alerts on background queries
when the Excel application is in control. (please see below before
answering that I should set displayalerts = false).
2. Is there a timeout property that can be set on a web query.

This might seem a bit arcane, but is quite critical to a web data
capture routine. I need to turn off alerts WHILE excel, NOT vba is in
control of operations.

I have a vba routine that generates potentialy thousands of web
queries in a workbook. Madness I know but there is method. These
queries run massively quicker when they are performed as background
queries - ie. once excel gets back in control when the vba routine
that built the queries has finished. I have a timer running (ported
from vb in an activex wrapper) that monitors the progress of the
queries, then runs some clean up routines when everything has been
completed.

Problems a
1. If there is an error at the server or in the query, Excel displays
an alert. VBA is not running at this point other than the periodic
timer routine, so displayalerts = false makes no difference to the
error message being displayed. Excel help has the following to say
about displayalerts: If you set this property to False, Micorosoft
Excel sets this property to True when the code is finished, unless
you are running cross process code.
2. If the queries take too long, I get a time out error, also leading
to problem 1. And, once the errors start, they are hard to stop since
the app is halted for the error, meaning data returns are probably
creating errors.

Finally, having spent ages trying to work out a robust timer solution
in vba, akin to the vb timer, I'll post the activex solution in the
next few days for general usage. If anyone would like to give it a
whirl in the meantime for a bit of testing, please let me know.

Thanks in advance,

Robin Hammond
www.enhanceddatasystems.com

Frank,

I really hope so. I just can't find it.

Robin Hammond
www.enhanceddatasystems.com

"Frank Kabel" wrote in message
...
Hi Robin
AFAIK you can't set this property to False outside VBA. As I'm not
using Web queries, don't they have a setting to omitt error messages?

--
Regards
Frank Kabel
Frankfurt, Germany


Robin Hammond wrote:
Questions:
1. Can anyone think of a way to disable alerts on background queries
when the Excel application is in control. (please see below before
answering that I should set displayalerts = false).
2. Is there a timeout property that can be set on a web query.

This might seem a bit arcane, but is quite critical to a web data
capture routine. I need to turn off alerts WHILE excel, NOT vba is in
control of operations.

I have a vba routine that generates potentialy thousands of web
queries in a workbook. Madness I know but there is method. These
queries run massively quicker when they are performed as background
queries - ie. once excel gets back in control when the vba routine
that built the queries has finished. I have a timer running (ported
from vb in an activex wrapper) that monitors the progress of the
queries, then runs some clean up routines when everything has been
completed.

Problems a
1. If there is an error at the server or in the query, Excel displays
an alert. VBA is not running at this point other than the periodic
timer routine, so displayalerts = false makes no difference to the
error message being displayed. Excel help has the following to say
about displayalerts: If you set this property to False, Micorosoft
Excel sets this property to True when the code is finished, unless
you are running cross process code.
2. If the queries take too long, I get a time out error, also leading
to problem 1. And, once the errors start, they are hard to stop since
the app is halted for the error, meaning data returns are probably
creating errors.

Finally, having spent ages trying to work out a robust timer solution
in vba, akin to the vb timer, I'll post the activex solution in the
next few days for general usage. If anyone would like to give it a
whirl in the meantime for a bit of testing, please let me know.

Thanks in advance,

Robin Hammond
www.enhanceddatasystems.com