Macro array problem

Mon, 30 Jan 2012 23:31:24 GMT

Dear all,

I have a problem with the following macro:

Sub Export_Dashboard_Chart_Images()

ExportCharts(1) = "CH19"

ExportCharts(2) = "CH20"

ExportCharts(3) = "CH23"

ExportCharts(4) = "CH24"

ExportCharts(5) = "CH27"

ExportCharts(6) = "CH28"

ExportCharts(7) = "CH50"

ExportCharts(8) = "CH52"

For i=Lbound(ExportCharts) to Ubound(ExportCharts)

Set obj = ActiveDocument.GetSheetObject(ExportCharts(i))

obj.ExportBitmapToFile "D:\Documents and Settings\All Users\Desktop\Export\" &obj.GetCaption.Name.v &".png"

'ActiveDocument.Variables("vDashboardChartType").SetContent "Absolute", true

End Sub

I want to export certain charts indentified in the array. When I run the macro, the editor appears without any error message. Can someone tell me what is wrong with this macro?

Thanks!

Macro array problem

Mon, 30 Jan 2012 23:37:50 GMT

Ok lbound return 0 instead of 1. Stupid beginners mistake.

topic Macro array problem in QlikView

Macro array problem

Macro array problem