Delete all Word Objects only

Hello Roasty_1,

Are these Word documents linked or embedded in your worksheet or are there multiple worksheets? Can you post the workbook for review? If you are using Excel 2007, please save the workbook in Excel 2003 format before posting it.

Sincerely,
Leith Ross

hi Leith

Thanks for your reply

The Word documents are embedded. I am using a combo box to select an entity, when selected - delete all word objects

I can do it so it deletes all Objects, but this includes deleting the combo box, which is not what I want.

Cant post spread sorry.

Can you still help?

cheers

Roast

Hello Roasty_1,

Give me a few minutes to write the code and check it.

Sincerely,
Leith Ross

Hello Roasty_1,

This should do it. Works for me.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks for the code

Strange thing is, works on its on, but when I try and place it in my existing code it does not work.

Keep getting this error:

Run-time error '1004':
Unable to get the object property of the OLEObject class

Any ideas?

Thanks for your help

roast

Hello Roasty_1,

Post the code you are using. That will help me to determine the problem. If you can, the best thing would be to post the workbook.

Sincerely,
Leith Ross