I?m using Office 2003
I have a lot of linked Excel-graphs (60) in my Word document. I want to change the source-file by code.
I think I can use the properties ProgID and Linkformat to do this.
But when I type in this little testcode:
[VBA] Sub test()
Dim s As Shape
For Each s In ActiveDocument.Shapes
Debug.Print s.OLEFormat.ProgID
Next s
End Sub
[/VBA] I always get the error:
"Object variable or With block variable not set"
I can?t understand what i have missed to declare.
Anyone have an idea of whats wrong or if some other method is better to use?