Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
see the attached. Change the below variable in Macro to match your folder path
filePath = "C:\Work\test.xlsx"
check options:
settings
user settings
export
copy to clipboard
that chart is checked
Regards.
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
see the attached. Change the below variable in Macro to match your folder path
filePath = "C:\Work\test.xlsx"