Automate Excel2k subtotals from Access2k

[bournes]

I am exporting to Excel sales information and would like to automate subtotals in the target worksheet. Can anyone advise me how to do this?

Thanks, Bear

 

[PHV]

Import the data from access to excel with a QueryTable (menu Data -> Get external data) and then apply the subtotals.
You may use the macrorecorder to get some code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

...apply Subtotals, using Data>Subtotals... in Excel

Skip,

_[red][/red]

 

[bournes]

Thank you both, that is helpful.

Bear