export chart macro issue

[#1]

I created 20 buttons with the macro below to export charts. The charts to be exported names are Chart1, Chart2 etc..

Button 1 macro

set obj=ActiveDocument.GetSheetObject("CH12")

obj.ExportBitmapTofile "C:\eWindow\Monthly Stats\August Monthly Stats\TestChart1.jpeg"

The problem now is when I created a Button2 with simlar macro but chart name changed toTestChart2.jpeg, the chart name in macro in Button1 will be changed to TestChart2.jpeg as well.

I need each Button to have a different chart name to be exported. Any suggestions would be much appreciated!

Thanks,
JLee

[marcus_sommer]

I would use only a single button, which read the required charts (possible values from a extra field - created per inline-load) and run within a loop the export-routine. For code-snippets to read fields and using loops see APIGuide.qvw.

- Marcus