Caption Title

[smilingjohn]

Hi All, 

I have a straight table and having a simple Macro to export to excel as shown below .But this Macro is not exporting the caption title of the straight table . Can please someone help me on this.  I am attaching my qlikview file for reference.

sub export
SET obj = ActiveDocument.GetSheetObject("CH01")
obj.SendToExcel
end sub

Thanks in Advance

[martinpohl]

check options:

settings

user settings

export

copy to clipboard

that chart is checked

Regards.

[smilingjohn]

@martinpohl  

That is not hekping , I checked the option everything is checked . 

When i click on the macro button  it exports  to excel sheet  but not with the title. 

I am attaching my qlikview file

[Kushal_Chawda · Accepted solution]

see the attached. Change the below variable in Macro to match your folder path

filePath = "C:\Work\test.xlsx"