These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

running acroreader + opening pdf file from within Excel

Cemak
Registered: May 23 2010
Posts: 4

Hello.

I have an Excel spreadsheet from which I would like, in a single stroke, run acroreader and made it open a pdf document (a map of Bahamas). I did it creating a VBA project inside such spreadsheet:

Sub Bahamas()
Dim myfile As String
Dim myprogram As String
Dim myprogrammyfile As String
myfile = "c:\Bahamas.pdf"
myprogram = "C:\program files\Adobe\Reader 9.0\Reader\AcroRd32.exe"
myprogrammyfile = myprogram + " " + myfile
Call Shell(myprogrammyfile, 1)
End Sub

Now I would like to go a step further. Beyond simply opening Bahamas.pdf, I would like to zoom in by (let's say) 200% and highlight the name of a chosen place which shows up in the map.

When I try to add "zoom=200&navpanes=1=OpenActions&search=FAIRMOUNT" to Sub Bahamas, it doesn't work: Acroreader opens Bahamas.pdf but ignores my zoom and search requests.

In Windows XP, if I do:

Start - Run - AcroRd32.exe /A zoom=200&navpanes=1=OpenActions&search=FAIRMOUNT c:\Bahamas.pdf - ENTER

that gives me what I want. However, I badly need to perform my trick from within Excel ...

Any ideas ? I'm far from being a computer expert ... please speak plain english !

Thank you very much for your help.

Cemakro

lkassuba
ExpertTeam
Registered: Jun 28 2007
Posts: 3636
The PDF open parameters only work via the command line and web links. Placing a weblink in Excel and using the open parameters should work.

Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.