Extract OLE Objects from Workbook

Extract OLE Objects from a Workbook

Creating a Template Workbook

  1. Created a spreadsheet in Microsoft Excel.
  2. Add a Microsoft Word document, an Excel workbook and a PDF document as OLE objects on the first worksheet.

Extract OLE Objects

The code below does the actual work of finding and extracting OLE objects as DOCX, XLSX, PPTX and PDF files.

Conclusion: