VBA-Using clipboard

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi everybody,
I want to write some code in either PP2007 to paste a chart in PP with it's
path ( chart is in Excel and it's copied in the clipboard) , pasting
clipboard contenet is a trivial task , but the challenge is how can I paste
not only the chart itself but also idealy paste it's path on a slid ( well
ideally I want to use the path as a tag to the chart which is pasted as EMF).
If you guys wonder why I need the path for a chart because I want to write a
code to automatically update charts that are pasted as EMF in PP, so I need
to know the path for the source file.
 
The quick and dirty solution would be to paste link and then get the source
file link from the ...LinkFormat.SourceFullName property. Then you can
delete it.

Regards,
Shyam Pillai

Image Importer Wizard: http://skp.mvps.org/iiw.htm
 
Thanks Shyam , I think this the easiest way of doing it, because I save the
linked path somewhere , and then break the link to make the chart a ppicture,
is it possibile to programatically use the link path and apply it to the
shape and activate the update?
--
Best regards,
Edward


Shyam Pillai said:
The quick and dirty solution would be to paste link and then get the source
file link from the ...LinkFormat.SourceFullName property. Then you can
delete it.

Regards,
Shyam Pillai

Image Importer Wizard: http://skp.mvps.org/iiw.htm
Click to expand...
 
Back
Top