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
Lori Kassuba is an AUC Expert and Community Manager for AcrobatUsers.com.