Well after much frustration and few successes, I've finally been able to pass parameters for a PDF while opening Acrobat from its default location via the registry. I'm certain there are other methods to do this, but this method is short and sweet.

I'm posting this with the assumption that it will likely work with other programs that can pass command line parameters. Also, I expect this solution could be used for most if not all programs incorporating VBA.

VBA is highly limited by its access to APIs. These can be manually coded, but can be extremely time consuming and confusing. Fortunately, the procedure required for ShellExecute, through the Shell32.dll (or Shell.dll on 16bit), is reasonably simple.

SOLUTION

[vba]
Option Explicit
'Declare the ShellExecute function by accessing the Shell library's procedure
Private Declare Function ShellExecute Lib "shell32.dll" _
Alias "ShellExecuteA" _
'Declare arguments
(ByVal hWnd As Long, ByVal lpszOp As String, _
ByVal lpszFile As String, ByVal lpszParams As String, _
ByVal LpszDir As String, ByVal FsShowCmd As Long) _
As Long

'Used to display a window
Const SW_SHOWNORMAL = 1

'Open pdf occurs on button click
Private Sub cmdPDF_Click()
Dim strPath, strParam As String

strPath = "C:\Example.pdf"
strParam = " /A " & Chr(34) & "page=14" & Chr(34) & strPath

Call ShellExecute(0&, "open", "AcroRd32.exe", strParam, "", SW_SHOWNORMAL)
End Sub
[/vba]
Hopefully this can help someone else out!

Cheers,
Cameron