Changing an OLE Link (for Excel Charts)

Sethbo

03-13-2003, 02:19 PM

I have a Word (2000) document that contains a linked object - to a single chart that is contained within an Excel spreadsheet. A standard Word dialog ("Links") shows properties such as Source File, Item, and Type.

Using VBA, I can update/change all properties EXCEPT FOR type - however "type" is the only thing I actually want to change (it holds the Sheet Name and Chart Name that is being referenced. My intent is to reference a new sheet and chart within the same workbook).

Does anybody know how to change that reference? I've looked and looked, but I must be missing what I need. Any help is greatly appreciated!

Seth

Samadhi

03-13-2003, 07:37 PM

I tried one time to change the properties of an inserted object. I tried and tried and tried. Couldn't do it, I just inserted a new object.

Sethbo

03-13-2003, 07:59 PM

I tried one time to change the properties of an inserted object. I tried and tried and tried. Couldn't do it, I just inserted a new object.

Unfortunately, I can't insert a new object either. I still wouldn't be able to specify the name of the sheet or the chart...