topic Re: Caption Title in QlikView

Caption Title

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Caption Title

martinpohl — Tue, 04 Aug 2020 09:14:52 GMT

check options:

settings

user settings

export

copy to clipboard

that chart is checked

Regards.

Re: Caption Title

smilingjohn — Tue, 04 Aug 2020 09:47:02 GMT

@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

Re: Caption Title

Kushal_Chawda — Tue, 04 Aug 2020 12:18:31 GMT

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

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