Programatically Add Outline and Grouping with VBA

  • Thread starter Thread starter PaulS
  • Start date Start date
P

PaulS

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?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating subtotals 22
Outline, expand or collapse via VBA 1
VBA: Collapse Column Groupings 1
How to programmatically determine which rows are outlined using Excel VBA code 1
Open / Close Grouping through VBA 13
Macro to Outline based on Indent Level 3
cannot expand outline on protected sheet 2
Expand and Collapse groups 1

Back
Top