Skip to main content
Participant
April 21, 2020
Question

Open an attachment in VBA Excel

  • April 21, 2020
  • 1 reply
  • 516 views

Hi,

Can i open a word attachment in a pdf with Excel VBA?

thx if someone have an answer.

 

Best regards

Axel

 

This topic has been closed for replies.

1 reply

Thom Parker
Community Expert
Community Expert
April 27, 2020

There is a way to do this, but you'll need to test it be sure. It's not a straight forward path.

1) Write a folder level JavaScript function to open the word attachment. Use the "doc.exportDataObject()" function.

Here's the reference entry:

https://help.adobe.com/en_US/acrobat/acrobat_dc_sdk/2015/HTMLHelp/#t=Acro12_MasterBook%2FJS_API_AcroJS%2FDoc_methods.htm%23TOC_exportDataObjectbc-31&rhtocid=_6_1_8_23_1_30

 

2)In the Excel VBA, use the IAC to call this function.   

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Participant
April 29, 2020

Hi Tom,

I am so grateful to your help.

I work on an other project right now but i test your solution as soon as possible.

But i think it's gone be perfect.

Best regards 

Alex