Macro to Copy Pictures fom Excel to PowerPoint

[Guest]

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

 

[Steve Rindsberg]

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.

Out of curiosity, why all the extra steps?

Can you not copy from Excel, paste into PPT (or paste special, as metafile) then
do File, Save As and choose PNG to save the entire presentation as a series of
PNGs?

Or because later versions of PPT do such an awful job of exporting images, you
could try the free demo of our Image Exporter addin at
http://www.pptools.com/imageexport/

ImageExport gives you more control over the results and should produce better
quality images.

 

[Guest]

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.

 

[Steve Rindsberg]

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.

I'm sure it can be done; it's mostly a matter of working out how to identify which
ranges need to be processed, I expect.

If you have a budget for this, have a look here:

http://www.reillyand.com/

and contact Brian Reilly. He and I have done something fairly similar to what you're
after in a custom addin he did for one of his customers.