Export chart as image using ExportBitmapToFile

richard_chilvers — Wed, 23 Apr 2014 09:34:39 GMT

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

Re: Export chart as image using ExportBitmapToFile

v_iyyappan — Wed, 23 Apr 2014 09:43:37 GMT

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)

end sub

Hope its help,

Regards,