B
briancperson
I routinely get worksheets that have many embedded objects in them
such as other spreadsheets, zip files, word docs, etc.
I need to create a macro (or any other way if someone is aware of)
that will go through the sheet, take each embedded object
individually, and extract and save it to a folder on the hard drive
with the name it has in the sheet in the correct file format.
I have searched the internet for hours and have seen many code
postings with people doing this with embedded objects in Word, but
none in Excel. Apparently word seems to have some functionality for
identifying embedded objects that Excel doesn't contain, or so I
gather from my research.
Please help, and thanks.
such as other spreadsheets, zip files, word docs, etc.
I need to create a macro (or any other way if someone is aware of)
that will go through the sheet, take each embedded object
individually, and extract and save it to a folder on the hard drive
with the name it has in the sheet in the correct file format.
I have searched the internet for hours and have seen many code
postings with people doing this with embedded objects in Word, but
none in Excel. Apparently word seems to have some functionality for
identifying embedded objects that Excel doesn't contain, or so I
gather from my research.
Please help, and thanks.