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.
Bookmarks