need help to embed pdf in excel

[vick]

with below code i can embed pdf in excel but i want to add in particular cell let's say A1 not by size.

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Site List.xlsx")
$oExcel.ActiveSheet.OLEObjects.Add (Null, "C:\Users\patelvi.DIAGLABS\Desktop\1M1160054.pdf", False, _
                        True, "C:\Users\patelvi.DIAGLABS\Desktop\pdf2.ico", 0, "Document 1", _
                        0, 10, 10, 0).Select

 

can you help me how to embed in cell pls?

[water]

Can you embed the PDF in cells by hand?

[vick]

yes i can select cell and insert file which will insert in cell .

[water]

Can you please activate the macro recorder, embed the PDF and then post the resulting VBA.

[vick]

Sub Macro3()

' Macro3 Macro
    Range("D7").Select
    ActiveSheet.OLEObjects.Add(Filename:= _
        "C:\Users\patelvi.DIAGLABS\Desktop\1M1160054.pdf", Link:=False, _
        DisplayAsIcon:=True, IconFileName:= _
        "C:\windows\Installer\{AC76BA86-7AD7-1033-7B44-AC0F074E4100}\PDFFile_8.ico", _
        IconIndex:=0, IconLabel:="C:\Users\patelvi.DIAGLABS\Desktop\1M1160054.pdf") _
        .Select
End Sub

 

i think record is same what i did but i need to select first specific cell. how i can achieve it ?

[water]

$oExcel.ActiveSheet.Range("D7").Select

[vick]

Ok got it. Basically almost same as vba.

thanks,

[water]

The only difference is that AutoIt does not support named parameters.

[vick]

thank you sir.

[water]