[AccessD] Automating Excel

[John Colby]

I have always automated Excel by doing a "recorder capture", saving that 
as vba in a template spreadsheet and then called that function.

I need to do a whole set of cross tabs.  Has anyone actually performed 
crosstabs in this manner?  ATM I paste the data into a spreadsheet, then 
manually select crosstab from the menu, then manually drag the three 
sets of data, the column names, row names and data, into their 
respective positions in the crosstab widget that pops up from the menu item.

-- 
John W. Colby