OLE: added ability to control sorting in AA window from OLE level
Object:
Analysis
New method:
SortByColumn( iColumn, bAscending, bMultiMode )
where iColumn - is zero-based column index to sort bybAscending - True/False decides the order we wantbMulti - if
set to False - it means that we want to sort by single column OR we define starting column for multi-column sortif set to
True - it means that we are defining additional columns for multiple-column sort.So to sort by many columns you need to call SortByColumn once with bMulti set to
False AND then call SortByColumn for all remaining sort columns with bMulti set to True
.
Example (multiple column sort by column 1 AND 2):
AB = new ActiveXObject("Broker.Application");AA = AB.Analysis;
// sort by date/time column
AA.SortByColumn( 1, False, False );
// add secondary sort column (see last argument = True)
AA.SortByColumn( 2, False, True );
OLE: added Application.Visible property
AB = new ActiveXObject("Broker.Application");
AB.Visible = True;
WScript.Sleep(1000);
AB.Visible = False;
WScript.Sleep(1000);
AB.Visible = True;
WScript.Sleep(1000);
AB.Quit();
--
Cheers
Graham
AB-Write >< Professional AFL Writing Service
Yes, I write AFL code to your requirements
http://e-wire.net.au/~eb_kavan/ab_write.htm