Paste special -->Paste & Link and update picture files!

Paste special -->Paste & Link and update picture files!

Post by T0RJ » Tue, 15 Nov 2005 22:02:02


I posted several times the simple question:
How do I paste linked (not embedded!) pictures in Excel 2003, so that the
picture can be updated and visible in Excel. I don't want a hyperlink or an
icon to open the files.

Did Microsoft forget to enable OLE-functions in Excel 2003 for graphics? I
tried followings to paste a picture as a link, no success!
1) I copy the picture into system clipboard, but under paste special in
Excel "paste link" is not activated.
2) It's also not possible to link a picture file through: Insert/ Picture/
From file... which is possible in Word 2003.
3) Insert/ Object/ Create from file... doesn't show the picture but an icon
or an empty frame, although "display as icon" is not checked and it links the
file as "package" instead of picture

Will it be possible to paste and link a picture in Excel 2003 after
ServicePack2?

Thanks for an answer! I'm desperately waiting for a solution.
ODI

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.yqcomputer.com/
 
 
 

Paste special -->Paste & Link and update picture files!

Post by SmFuY » Sat, 11 Mar 2006 01:05:27

I am having the same problem and I have Excel 2003 ServicePack2. I found
this Knowledge Base article http://www.yqcomputer.com/
following it's advice installed Photo Editor from Office 2000, but it didn't
make any difference. Also their instructions to choose Insert>Picture>From
File, tell you to click the down arrow on the Insert button, and then click
Link to File. That isn't available in Excel. I'm frustrated too. I hope
someone knows what to do.

 
 
 

Paste special -->Paste & Link and update picture files!

Post by T0RJ » Sat, 11 Mar 2006 18:03:28

i Jana,

I contacted Microsoft directly, and they accepted that this is a "design
bug" that means, there will be no patches. And it works in Excel 12. The only
way to resolve the problem is to install the old OLE-Server for pictures,
which is the Photo Editor from XP. I didn't have the time to test it. But
Microsoft did it for us and they ensured that it works. I will probably work
on it next week again. I proposed in December Microsoft to post an KB-article
about this. No reaction until now...

I found another workaround for this problem: i listed the files that i need
in an Excel sheet. And i'm reembedding them, if i need to update. (i use
chart-pictures with always the same filename, which are automatically
generated out of a statistics application, that's why i need to update them!)

That's the original code I used:
==============
Sub Main
Dim i As Integer
Dim sFilename As String
Dim bcontinue As Boolean
Dim spath As String
i = 1
bcontinue = True
spath = "C:\Documents and Settings\All Users\Documents\My
Pictures\Sample Pictures\"

Set oFSo = CreateObject("Scripting.FileSystemObject")

'reads file names from a list in a worksheet
While bcontinue
sFilename = Worksheets(2).Cells(i, 1).Value
'worksheets is the number of the sheets, e.g. sheet1 = 1 sheet 2 = 2 etc.
'cells is the cell, the first parameter the row, the second the column
If sFilename = "" Then
bcontinue = False
Else
Worksheets(1).Cells(i, 1).Select 'selects the cell where it should be
inserted

sFilename = spath + sFilename ' + ".jpg"
If oFSo.fileExists(sFilename) Then

ActiveSheet.Pictures.Insert(sFilename).Select
'inserts picture and select it
Selection.ShapeRange.ScaleWidth 0.47, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.47, msoFalse, msoScaleFromTopLeft
End If
i = i + 1
End If
Wend

End Sub
===========

Hope my answer helps you a little bit in this hopeless Case!

"Jana" wrote: