DDE : ShowToolbar

The toolbar of the Acrobat application is displayed.
Only Acrobat can be used. It is not possible to use it with Acrobat Reader.




true The toolbar is shown successfully.
false Otherwise.

Notes: The return value cannot be acquired with DDE of VBA of Excel.

Sample: VBA of Excel

The toolbar of the Acrobat application is displayed.

  • Please confirm the test by the step execution with F8 key.

Sub DDE_ShowToolbar()
  Dim lChanNo As Long ‘DDE channel number
  ‘A double quotation mark is added for blank starting full path.
  Const CON_PDF_PATH = “””E:\Test01.pdf”””

‘The Acrobat application is Started.
  Shell “C:\Program Files\Adobe\Acrobat 7.0\Acrobat\Acrobat.exe”
  ‘Open of DDE channel
  lChanNo = DDEInitiate(“Acroview”, “Control”)

‘Open of PDF file
  DDEExecute lChanNo, “[DocOpen(” & CON_PDF_PATH & “)]”
  ‘The toolbar is concealed.
  DDEExecute lChanNo, “[HideToolbar()]”
  ‘The toolbar is displayed.
  DDEExecute lChanNo, “[ShowToolbar()]”

‘The Acrobat application is ended.
  ‘If this is not done, the Acrobat process remains.

  DDEExecute lChanNo, “[AppExit()]” 
  ‘The DDE channel is shut.
  DDETerminate lChanNo
End Sub


  • It doesn’t operate in Acrobat Reader.
  • The Acrobat application maintains the state to display the toolbar though it ends. In a word, when the Acrobat application will start next time, the toolbar is started while displayed.

Environment to confirm the operation

  • WindowsXP + SP3 + WindowsUpdate
  • Adobe Acrobat Pro 7.0.8 + Office Pro 2003
  • Adobe Acrobat Pro 9.1.0 + Office Pro 2003

The programming operates DDE Message of Acrobat and Adobe Reader with VBA of MS Excel.