Saving Multiple embedded documents in Excel

Question

I have a large Excel spreadsheet that has about 50 embedded documents in it (The files are actually embedded in the spreadsheet - they are not a link to a file stored somewhere else).  Would someone know of a way to easily save all those embedded documents as individual files outside of the spreadsheet (some are excel spreadsheets, some are in Adobe format, some are WORD documents, etc).  In other words, I would like to "strip" all the embedded documents out of the spreadsheet and save them to my harddrive as individual files.  I am wondering if there is an easy way of doing this (e.g.  highlight all the embedded documents, right click and say "save").  Currently, the only way I know to do it is to individually open each document and then save it.  I am willing to consider some kind of VBA code to do it, if someone has programmed it.

Thanks

Answer 1

Hello,

Thank you for choosing Microsoft Community,

As of now this feature is currently unavailable in Excel to automatically save all the embedded files at once, you will have to do it manually which you are already aware of doing.

In case you need to know if this can be accomplished using VBA then post in below forums.

http://answers.microsoft.com/en-us/office/forum/customize

Thank you.

Answer 2

Hello,

Thank you for choosing Microsoft Community,

As of now this feature is currently unavailable in Excel to automatically save all the embedded files at once, you will have to do it manually which you are already aware of doing.

In case you need to know if this can be accomplished using VBA then post in below forums.

http://answers.microsoft.com/en-us/office/forum/customize

Thank you.

Thank You for your help.  I knew it was a long shot but Forum members have surprised me in the past.