I wish to use the results of a querytable update in the local worksheet as
the basis for loading up / populating a VBA Recordset WITHOUT needing to
re-hit the database for the information.
I am taking this approach so as to retain visibilty of the raw data and have
it on hand, in entirety, to mannually inspect / analyse if my automated logic
and integrity checks in VBA highlight that there is a need to delve deeper
into the integrity of the data.
There is likely to be great amounts of data in a real-time warehousing
environment so I want to avoid placing extra loads on the database / bandwith.
Here's what I've tried and been stumped at :
The vba refresh :
Worksheets("qryInventoryData").QueryTables(1).Refresh BackgroundQuery:=False
And here's the failing attempt to populate the VBA recordset :
Set rsData = Worksheets("qryInventoryData").QueryTables(1).Recordset
Does anyone think this iss too much to expect ? Is there another way to
skin tis cat ?
Aaron
Bookmarks