Macro for exporting object as image?

[#1]

Hi all,

I need help with a macro for exporting object to .JPG image.

I have a Dashboard with various gauge charts that needs to be exported to .JPG for presentation externally. In the best of worlds it's possible to export two (2) objects to one (1) image (.JPG). Any help is welcome regarding macro or other ways to achieve this!

Best regards

Torbjörn Ungvall (@Ungvall)

Senior Business Discovery Manager @ Advectas AB

[#2]

hi,

Try This:

This can export all object of current sheet but seperately...

Sub ExpBmp

set sh = ActiveDocument.ActiveSheet

for i = 0 to sh.NoOfSheetObjects-1

    set obj = sh.SheetObjects(i)

obj.ExportBitmapToFile "MyImage"&i&".bmp"

next

End Sub

Regards,

Arun Goel

[ashfaq_haseeb]

Hi,

look at the attached application.

Regards

ASHFAQ