Retrieve source path of a picture in clipboard

[Edward]

Hi everybody,
When we paste a picture or chart ( previously copied from excel , and
already in the clipboard) , is it possibile to retrive it's source path ?

 

[macropod]

Hi Edward,

If you paste using the paste link option, you can retrieve the path from the object's field code. You can then, if necessary, unlink
the object.

 

[Edward]

Thanks , yes that's what I did. Now , that I have the path I broke to link to
make a picture from the chart. I need to be able to find the same chart in
excel and paste it back in case there is a new update.
Do you know how I can find the exact chart in Excel
here is the path gernerated by .sourcefullName
C:\WINDOWS\Standard\Desktop\Book999-test.xlsx!Sheet1![Book999-test.xlsx]Sheet1 Chart 1
--
Best regards,
Edward

Hi Edward,

If you paste using the paste link option, you can retrieve the path from the object's field code. You can then, if necessary, unlink
the object.

 

[macropod]

Hi Edward,

Why don't you just leave the link active? That way Word can take care of any updates for you - all you need to do is have the
'update auotomatic links at open' option checked under Tools|Options|General.

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks , yes that's what I did. Now , that I have the path I broke to link to
make a picture from the chart. I need to be able to find the same chart in
excel and paste it back in case there is a new update.
Do you know how I can find the exact chart in Excel
here is the path gernerated by .sourcefullName
C:\WINDOWS\Standard\Desktop\Book999-test.xlsx!Sheet1![Book999-test.xlsx]Sheet1 Chart 1
--
Best regards,
Edward

Hi Edward,

If you paste using the paste link option, you can retrieve the path from the object's field code. You can then, if necessary,
unlink
the object.

--
Cheers
macropod
[Microsoft MVP - Word]

Hi everybody,
When we paste a picture or chart ( previously copied from excel , and
already in the clipboard) , is it possibile to retrive it's source path ?

 

[Edward]

well, the simple reason is security , we don't want people to change the data
, if it's pased as a picture users can't change it.
--
Best regards,
Edward

Hi Edward,

Why don't you just leave the link active? That way Word can take care of any updates for you - all you need to do is have the
'update auotomatic links at open' option checked under Tools|Options|General.

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks , yes that's what I did. Now , that I have the path I broke to link to
make a picture from the chart. I need to be able to find the same chart in
excel and paste it back in case there is a new update.
Do you know how I can find the exact chart in Excel
here is the path gernerated by .sourcefullName
C:\WINDOWS\Standard\Desktop\Book999-test.xlsx!Sheet1![Book999-test.xlsx]Sheet1 Chart 1
--
Best regards,
Edward

Hi Edward,

If you paste using the paste link option, you can retrieve the path from the object's field code. You can then, if necessary,
unlink
the object.

--
Cheers
macropod
[Microsoft MVP - Word]


Hi everybody,
When we paste a picture or chart ( previously copied from excel , and
already in the clipboard) , is it possibile to retrive it's source path ?

 

[macropod]

Hi Edward,

If you use the vba to extract the field's complete code and store it in, say, a custom document property, it's a simple matter to
then insert the code from the custom document property into a new field and update it, before unlinking again.

--
Cheers
macropod
[Microsoft MVP - Word]

well, the simple reason is security , we don't want people to change the data
, if it's pased as a picture users can't change it.
--
Best regards,
Edward

Hi Edward,

Why don't you just leave the link active? That way Word can take care of any updates for you - all you need to do is have the
'update auotomatic links at open' option checked under Tools|Options|General.

--
Cheers
macropod
[Microsoft MVP - Word]

Thanks , yes that's what I did. Now , that I have the path I broke to link to
make a picture from the chart. I need to be able to find the same chart in
excel and paste it back in case there is a new update.
Do you know how I can find the exact chart in Excel
here is the path gernerated by .sourcefullName
C:\WINDOWS\Standard\Desktop\Book999-test.xlsx!Sheet1![Book999-test.xlsx]Sheet1 Chart 1
--
Best regards,
Edward


:

Hi Edward,

If you paste using the paste link option, you can retrieve the path from the object's field code. You can then, if necessary,
unlink
the object.

--
Cheers
macropod
[Microsoft MVP - Word]


Hi everybody,
When we paste a picture or chart ( previously copied from excel , and
already in the clipboard) , is it possibile to retrive it's source path ?