QV subtotals in Excel

edvapran — Wed, 13 Mar 2013 13:13:12 GMT

Hi,

I'm trying to add subtotals to exported excel file.

Basically I have a excel file on my drive and I'm trying to add subtotals but with no luck.

Here is the code:

Set oXL=CreateObject("Excel.Application")
f_name="C:\test\test.xls"
    Set oWB=oXL.Workbooks.Open(f_name)
    oXL.Visible = True
    oXL.Range("A1:Q156").Select
    oXL.Selection.Subtotal 1, xlCount, Array( 2, 3 ), False, False, False

I get an error "Subtotal method of Range class failed"

But when I copy

Selection.Subtotal 1, xlCount, Array( 2, 3 ), False, False, False

straight to excel and execute it all goes well.

I also tried

set WW = oXL.Selection.Subtotal(1, xlCount, Array( 2, 3 ), False, False, False)

..then I tried with only 3 parameters, nothing works on QV project.

Why is that and how to solve it?

Re: QV subtotals in Excel

edvapran — Fri, 15 Mar 2013 05:56:04 GMT

anyone?

topic QV subtotals in Excel in QlikView

QV subtotals in Excel

Re: QV subtotals in Excel