Skip to main content
Participant
January 22, 2020
Question

Adobe Acrobat Standard 2017 not working with Excel VBA that worked with Acrobat XI

  • January 22, 2020
  • 1 reply
  • 894 views

I wrote code to open and populate pdf files in excel vba.  When I get to the save file as menu, the code that used to work to save the files is inoperable.  When the dialog box Save as PDF displays, the command 

Application.SendKeys "{Enter}" = True has no effect.  Therefore, programmatically, I am unable to get to the next dialog box that allows me to enter the document name.  Is there a workaround for this problem?

This topic has been closed for replies.

1 reply

Participant
January 22, 2020

After looking at the VBA for send keys I found I can use "~" instead of "{ENTER}" and that works.. Curious.