Calculate subtotals from Access to Excel

[dani75]

Hi!

I'm programming an Access application which calculates the subtotal of a range in a Excel Worksheet.

The problem is that when I make a subtotal of selected cells, the selection doesn't change. If I realize that from Excel it works but If I do it from Access the range is not updated.

The code that I use is:

Selection.Subtotal GroupBy:=6, Function:=xlSum, TotalList:=Array(5), replace:=True, PageBreaks:=False, SummaryBelowData:=True

Please help me!

Thank you!

Dani.

 

[SkipVought]

What do you mean by...

"the selection doesn't change"

??? Skip,
metzgsk@voughtaircraft.com