I have an excel file which I use to create Word documents.
I am able to copy data, table, images.
However I have a PDF file in my excel file(which I have inserted using Insert option). I want that to Insert in the word document that I create.
Currently I am trying to use the following Code for this, BUT GETTING Error 4198 while executing. Could someone help please.
I am able to copy data, table, images.
However I have a PDF file in my excel file(which I have inserted using Insert option). I want that to Insert in the word document that I create.
Currently I am trying to use the following Code for this, BUT GETTING Error 4198 while executing. Could someone help please.
Code:
oDoc.Shapes.AddOLEObject ClassType:="AcroExch.Document.11", _
Filename:= _
ThisWorkbook.Worksheets("ABCD").OLEObjects("AAAA") _
, LinkToFile:=False, DisplayAsIcon:=True, IconFileName:= _
"C:\Windows\Installer\{AC76BA86-7AD7-1033-7B44-AB0000000001}\PDFFile_8.ico" _
, IconIndex:=0, IconLabel:= _
"AAAA"