Macro to Control Chart Property

[qlik_venu]

Hi,

I am trying to use a macro to Enable the Title Setting in the Chart.

I normally have the Windows Titlte Enabled, as it saves me space. So whenever I try to export it to Excel ( through a macro which i found in the http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/#downloads_97... ), the wiindows title is not getting exported to excel.

So I am tring to use a macro to enable the Title only when the report is exported to Excel. To be more specific i have added the snapshot of the property i am trying to control.

I used the following code but it still is not working fine.

sub EnableTitle

Dim objSource
Dim p
Dim title
set objSource=ActiveDocument.GetSheetObject("CH102")
set p=objSource.GetProperties
p.Title = false
objSource.SetProperties p

end Sub

Thanks,

Venu