Programatically Add Outline and Grouping with VBA
 

I am exporting an Access 2000 table to an Excel 2000 workbook
record-by-record using VBA code. The rercords are already sorted by the value
in the first field. I would like to group rows by the value in the first
column and add a collapsible subtotal row at the bottom of each group, plus a
grand total at the end of the document. I know this can be done with Data -
Group and Outline in Excel, but I can find no info on how to do this
programmatically with VBA code. Can this be done?

Programatically Add Outline and Grouping with VBA
 

Do it manually with the macro recorder switched on, and you will generate
the necessary code.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"PaulS" wrote in message
...
I am exporting an Access 2000 table to an Excel 2000 workbook
record-by-record using VBA code. The rercords are already sorted by the
value
in the first field. I would like to group rows by the value in the first
column and add a collapsible subtotal row at the bottom of each group,
plus a
grand total at the end of the document. I know this can be done with
Data -
Group and Outline in Excel, but I can find no info on how to do this
programmatically with VBA code. Can this be done?