Hi folks,
I'm trying to pull some data from the following URL.
Report
If/when you view it the session may have timed out, though this isn't my issue (yet...).
So, assuming the session is still active:
I understand how to develop .iqy files to pull in data from pages where data is 'hard-coded'. However, for this page, the site is running its own query against a database and it takes a few seconds for the data to appear on the page.
When I run my query it simply states 'please wait while we run this report....running...download'.
Is there a bit of VBA code that I can use to make the query wait until data has loaded? If so, should this be in the .iqy file or in a separate vba module?
My iqy file is below for your info. Any help much appreciated.
WEB
1
Report
Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
I'm trying to pull some data from the following URL.
Report
If/when you view it the session may have timed out, though this isn't my issue (yet...).
So, assuming the session is still active:
I understand how to develop .iqy files to pull in data from pages where data is 'hard-coded'. However, for this page, the site is running its own query against a database and it takes a few seconds for the data to appear on the page.
When I run my query it simply states 'please wait while we run this report....running...download'.
Is there a bit of VBA code that I can use to make the query wait until data has loaded? If so, should this be in the .iqy file or in a separate vba module?
My iqy file is below for your info. Any help much appreciated.
WEB
1
Report
Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
