hi,

[#1]

Hi,

Any idea why my macro to export a chart to excel was working when my Excel was in 2010 but now that I have 2013 in the server,

the macro is only generating 1 line of data in my chart.

My macro is as follows :-

sub Cab()

set Chart = ActiveDocument.GetSheetObject( "CH01" )

"C:\DailyReports\CAB\CAB.xls",5

end sub

[Siva_Sankar]

Jenny

Try the below macro replacing with your path.

sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\temp\t.xls"

end sub

[#3]

Hi Siva,

With the biff, it is not exporting. Is there a compatibility issue with Excel 2013?

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

[Siva_Sankar]

Jenny,

Are you trying to run the macro using IE client or AJAX?

[#5]

Hi Siva,

The macro is run within Qlikview report after reloading.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

[Siva_Sankar]

Ensure that you are granting System Access to your macros in the server through QEMC (System, Setup, QlikView Servers, expand and click, Seucrity tab in the right pane "Allow unsafe macro execution on server" and "Allow macro execution on server" ticked) and in the Macro editor, (Ctrl + M, bottom left drop downs)

[petter]

If that is your entire macro nothing will end up in Excel. There shouldnt be compatibility issues with Excel 2013 AFAIK I have used them together with macros for more than a year.

[#8]

Hi Jive,

My macro is as follows:-

sub Cab()

ActiveDocument.ClearAll

set Chart = ActiveDocument.GetSheetObject( "CH01" )

chart.exportex "C:\DailyReports\CAB\CAB.xls",5

end sub

With ActiveDocument.ClearAll, it exported only 1 line of data.

But when I commented out ActiveDocument.Clearall, it exported all the data.

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

[#9]

Hi Siva,

I am not using Qlikview Server but Qlikview 9.0.

My settings are as follows :-

Best regards,

Jenny Tan

MIS Manager

Angliss Singapore Pte Ltd

A member of Bidvest Asia Pacific Group

Mobile: 97839001

DID: 6770 4194

Tel: 6778 8787

Fax: 6770 4126

Email address: tan_jenny@angliss.com.sg<mailto:tan_jenny@angliss.com.sg>

Website: www.angliss.com.sg<http://www.angliss.com.sg/>

<http://www.angliss.asia/>

[Siva_Sankar]

May be your current selection returns only one row in your chart. use

ActiveDocument.ClearAll false

or upload your application