Report in excel or word

HCL Domino Domino Forum
1

Is there a way to have PDF attachment in excel or word?

I am creating a report to export data from notes document to excel. I want to also export all the PDF attachments for each documents. When user goes into the excel they should see PDF attached, when doubl-click on the icon, open the PDF file from the excel. If this is possible to do in word. I need some ideas.

any suggestion would help asap.

amp

2

Subject: report in excel or word

You’ll want to check with the MS guys on this one. You’re probably writing OLE/COM type code and that’s just VBA written in LS. The VBA folks would know if you can do this and how.

Once you have that information, just re-do the code in LS.

Doug

3

Subject: report in excel or word

User this macro code. You will have to update so that is works correctly in LotusScript. Copying and pasting the code in script will cause errors. The syntax is different.

Selection.InlineShapes.AddOLEObject ClassType:=“AcroExch.Document.7”, _

    FileName:="C:\FolderName\FileName.pdf", LinkToFile:=False, DisplayAsIcon _

    :=True, IconFileName:= _

    "C:\WINDOWS\Installer\{AC76BA86-7AD7-1033-7B44-A80000000002}\PDFFile_8.ico" _

    , IconIndex:=0, IconLabel:="""Label name to display.pdf"""
4

Subject: RE: report in excel or word

You code is capture files from c: directory. The PDF file are stored in document Not in C drive. please advise.

amp

5

Subject: RE: report in excel or word

Please respond to my message. thanks