SHELL Function - parameters, open specific page in a PDF document

[Leo_Polla_Psemata]

Hi
Is it possible to use shell function and open an external pdf file but in a specific page?

 

[isladogs]

A Google search for "Open PDF at specific page VBA" gave lots of hits including this one:
https://www.devhut.net/2013/12/04/vba-open-a-pdf-to-a-specific-page/

I've not tested it but its by Daniel Pineault who knows his stuff

 

[Leo_Polla_Psemata]

Thank you for the very useful post, I made it. It works.
I am testing it , the problem I get is an annoying warning, although I reach my goal,
the below warning message pops up after every click or change field focus.
What have I done wrong ?


The expression on Current you entered as the event property setting produced the following error.
The object doesn't contain the Automation object <<field2>>
The expression may not result in the name of a macro, the name of a user-defined function or [event procedure]

Help

This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.

 

[isladogs]

As I said, I haven't used Daniel's code though I will do so for my own purposes at some point.
Suggest you step through the code to determine the line it breaks at.
Then post back ...or contact Daniel direct from his website