Import Images/Pictures/Shapes from a Closed Excel Workbook

I have a Closed Excel workbook in which there are pictures inserted in a sheet.

I want to import these pictures or Shapes from this CLOSED temporary workbook into my current Workbook.

• Does ADO have a method to write an SQL Query to import Images/Pictures/Shapes embedded in an Excel Sheet without opening the Excel Workbook?
• Any alternative methods to import the Images/Pictures/Shapes?
• Can ADODB.STREAM object pull all the images from the Sheet of the Closed Excel Workbook as HEX or BLOB data and store them in a Collection Class or Dictionary Class for later use?
• Can an MSMXML2.Document object be able to read the Sheet (.Load File OR .LoadXML Range.Value() ) of a the Closed Excel Workbook and have information of the Images/Pictures/Shapes in its XML, that can be processed further to recreate the images into the Current Workbook?

Any help will be most appreciated.

Thanks for your kind reply.

Your idea of zipping the closed temp.xlsx workbook and extracting the images using XMLDOM and XML nodes sounds interesting. Is there an example available for this excel zipping and extracting images from zip?

Just a random thought:

• Is there a way to hold the pictures in memory (maybe as a BLOB or a Picture itself) using some Custom Class (Dictionary or Collection Class) till the workbook (session) is open, and then, whenever needed, use them (convert them back from BLOB to picture) for inserting into a worksheet cells of current workbook for report creation? If so, how can such a Custom Class be created?

• Long ago, I had seen somewhere an example of someone converting a bunch of images pulled from a folder into HEX data, storing them into a Custom Array Class (to maintain live session) and then reconverting the HEX data back to individual images to be inserted into worksheets, whenever required. Unfortunately, i was unable to locate this code anymore.