Extract OLE Objects from Workbook

Extract OLE Objects from a Workbook

Creating a Template Workbook

  1. Create 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: