Export chart as image using ExportBitmapToFile

[richard_chilvers]

Hi

I have a button which runs a small script using ExportBitmapToFile to create jpg image of a chart using the following:

ActiveDocument.GetSheetObject("CH64").ExportBitmapToFile  <filename.jpg>

This works perfectly if the chart is on the same sheet as the button.

However, I would like the button to be on a different sheet to the relevant chart.

Can anyone tell me what the command should be ?

Thanks

Richard

[v_iyyappan]

Hi,

You can get all sheetid from the below code. so you can mention get desired sheetid.

sub LoopSheet

for i = 0 to ActiveDocument.NoOfSheets - 1

set ss= ActiveDocument.GetSheet(i)

msgbox(ss.GetProperties.SheetId)

next

end sub

Hope its help,

Regards,