Export the specific chart data into excel after reloading data

[deepakqlikview_123]

My requirement is

Export the specific chart data into excel after reloading data, is this possible by using macro.

Thanks

[#2 · Accepted solution]

hi,

yes use trigger to run macro after reload the application.

Regards

Vimlesh

[Anonymous]

Yes you can.

See this doc

Useful Qlikview Macros

Thanks

BKC

[deepakqlikview_123]

I am using macro as per below

FUNCTION ExcelExport(CH78) set obj = ActiveDocument.GetSheetObject( CH78 ) w = obj.GetColumnCount if obj.GetRowCount>1001 then h=1000 else h=obj.GetRowCount end if Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Add objExcel.Worksheets(1).select() objExcel.Visible = True set CellMatrix = obj.GetCells2(0,0,w,h) column = 1 for cc=0 to w-1 objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text objExcel.Cells(1,column).EntireRow.Font.Bold = True column = column +1 next c = 1 r =2 for RowIter=1 to h-1 for ColIter=0 to w-1 objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text c = c +1 next r = r+1 c = 1 next END FUNCTION  SUB CallExample ExcelExport( "CH78" ) END SUB

but it is giving me error as macro parse failed functionality was lost.

Thanks

[Srinivas]

Hi Vimlesh,

I want to export specific chart(straight table) to excel after reloading ,This reloading also happen every day morning times so for every day reloading I have created batch file, So automatically application reloading and excel exporting to specific folder I need.

So how to export excel after reloading.this is my question could you please help on this.

Advance Thanks,

Munna 

[#6]

hi,

Create a macro to send report.

and trigger the macro afterpost reload.

search code in google.i don't have right now.