Macro to Copy Pictures fom Excel to PowerPoint

[Jeff]

I have many ranges of data in excel, that include charts and text in cells.
I copy each picture from excel to powerpoint so I can then save each as a PNG
file for uploading onto a SharePoint site. I know it must be possible to
write a macro that copies each range of cells from Excel, pastes to
powerpoint as a Windows metafile, then copies each picture and repastes it as
a PNG file, then saves the PNG as a picture. I do this process manually for
each picture and it is time consuming, but I have found that this process
produces the best looking pictures on the SharePoint site. Any help with the
VBA will be appreciated.

Jeff

 

[Jeff]

We experimented at length, and found this lengthy process to yeild the
clearest pictures on the SharePoint site. Some possilbe contributory factors
include: the ranges in excel include graphs and text in cells (just the
graphs are easier the pictures are shown on the SharePoint site about 480
pixels wide - pretty small.

I will try Image Export and report on the results, but would still be
interested in a more automated method than exporting each range individually.