I have a Word document that is full of embedded Excel sheets. These embedded worksheets are not searchable using the Ctrl+F function in Word. I would like to be able to search these embedded sheets without having to open each one individually, as there are A LOT.

So, using VBA, I am looking to find/open each embedded Excel worksheet and save each into a new Excel file. (Each embedded worksheet would now be its own .xls file, say on the Desktop). That way, I can then write a Excel VBA subroutine to search all of the new workbooks for a specific string, for example.

I have explored some ways to do this online, but none are promising. Is this possible? Is there a better way to do this? I am new to VBA.