Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
look at the attached application.
Regards
ASHFAQ