I
isapien
I am using Excel 2003. I am trying to bypass the message that states that my
query returned no data, without having to manually select the "OK" button. I
know the web-site that I web query for data will not have the data available
for a minute or so. Eventually it refreshes and presents the data that I am
looking for.
Unfortunately, until I press the OK button, all of my macros stop running.
Is there a way of bypassing this feature automatically, without me having to
manually press the "OK" button? ...Or is there a way to temporairily disable
this feature? Is there a work around that will enable all my other macros to
continue running and suspend this query temporairily, then refresh when the
data becomes available (again, without me having to press the "OK" button)?
I am not a programmer and only know a little about creating my own macros
within Excel. I appreciate all the help I can get on this topic.
query returned no data, without having to manually select the "OK" button. I
know the web-site that I web query for data will not have the data available
for a minute or so. Eventually it refreshes and presents the data that I am
looking for.
Unfortunately, until I press the OK button, all of my macros stop running.
Is there a way of bypassing this feature automatically, without me having to
manually press the "OK" button? ...Or is there a way to temporairily disable
this feature? Is there a work around that will enable all my other macros to
continue running and suspend this query temporairily, then refresh when the
data becomes available (again, without me having to press the "OK" button)?
I am not a programmer and only know a little about creating my own macros
within Excel. I appreciate all the help I can get on this topic.