Word embedded Excel file to open automatically

Hi,

I am looking to have my macro search for and open up an embedded Excel file in word (eventually to automatically update the excel embed and exit back to the word document)

I want it to stop at the end of the word document, but my code seems to have it continue forever--

Please Login or Register  to view this content.

I have tried adding

Please Login or Register  to view this content.

just to have it stop, once it finds my embedded Excel file (in the document), but that doesn't seem to work either.

Any ideas?

Thanks!

Seems to me that you only need the For Each loop and not the other parts of the Do loop.