04 ShowIE - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

ShowIE method

Show a Xdata object in an IE window.

Applies to

TableData ArrData RsetData Xdata XShared
Name Type Description
Xd Xdata The Xdata object to be shown.
MaxRows Long (optional) The maximum number of rows to show.

When developing code, there is often a need to view the results as the code progresses - particularly with ArrData and RsetData (with TableData, results are visible on the worksheet). This can be done by defining a XShared object and using its ShowIE method, for example

Dim Xs as New XShared
Xs.ShowIE Ad1

This shows the contents of the ArrData object Ad1 in an Information Explorer window. It is possible to limit the number of rows displayed if required by setting the MaxRows parameter. The ShowIE line can be built into the code, but it is often more convenient to pause the code where required and then type this line in the immediate pane. This can be repeated as often as required while stepping through the code just by selecting the line in the immediate pane and pressing Enter.