Embedded Objects

[keltic]

When embedding a word document in Excel it increments the object by one each time.

Does anyone know of any code which will allow you to delete the object already there before embedding the new one over the top ?

 

[Ivan F Moala]

On 2002-09-04 10:13, keltic wrote:
When embedding a word document in Excel it increments the object by one each time.

Does anyone know of any code which will allow you to delete the object already there before embedding the new one over the top ?

<pre/>
Dim objWd As Object

For Each objWd In ActiveSheet.OLEObjects
objWd.Delete
Next
</pre>

 

[keltic]

Many Thanks

Regards

Mike
This message was edited by keltic on 2002-09-11 04:57