topic How to export to Excel include Title Caption? in QlikView

How to export to Excel include Title Caption?

Mon, 09 Apr 2012 04:56:48 GMT

How to export to Excel include Title Caption? May be someone know this setting.

Thanks

Re: How to export to Excel include Title Caption?

Mon, 09 Apr 2012 10:48:12 GMT

Danny,

Please go through this link

http://community.qlik.com/message/138642#138642

This is the macro code

Sub ExcelExpwCaption

'Set the path where the excel will be saved

filePath = "E:\TestBB.xls"

'Create the Excel spreadsheet

Set excelFile = CreateObject("Excel.Application")

excelFile.Visible = true

'Create the WorkBook

Set WorkBook = excelFile.WorkBooks.Add

'Create the Sheet

Set Sheet = WorkBook.WorkSheets(1)

'Get the chart we want to export

Set tableToExport = ActiveDocument.GetSheetObject("LB02")

Set chartProperties = tableToExport.GetProperties

tableToExport.CopyTableToClipboard true

'Get the caption

chartCaption = tableToExport.GetCaption.Name.v

'MsgBox chartCaption

'Set the first cell with the caption

Sheet.Range("A1") = chartCaption

'Paste the rest of the chart

Sheet.Paste Sheet.Range("A2")

excelFile.Visible = true

'Save the file and quit excel

WorkBook.SaveAs filePath

WorkBook.Close

excelFile.Quit

'Cleanup

Set WorkBook = nothing

Set excelFile = nothing

End Sub

Regards

..........

How to export to Excel include Title Caption?

Tue, 10 Apr 2012 01:50:04 GMT

Thanks

Re: How to export to Excel include Title Caption?

Fri, 13 Apr 2012 13:38:54 GMT

Danny,

Please mark the correct answer if it works.So that others can able to get the solution.

Regards

................

How to export to Excel include Title Caption?

Sat, 14 Apr 2012 01:45:39 GMT

Why can't i use this code? I only use Open Office, not using Excel. May be I don't have ActiveX to execute this code.