Hello,
I'm trying to open a .PDF from Acces using VBA. I have the following code attached to a command buttom :
Private Sub Acrobat_test_Click()
On Error GoTo Err_Acrobat_test_Click
Dim stAppName As String
stAppName = "C:\Program Files\Adobe\Acrobat 4.0\Reader\AcroRd32.exe D:\WINTERTHUR\PFP\PFP Tool\NL\test.pdf"
Call Shell(stAppName, 1)
Exit_Acrobat_test_Click:
Exit Sub
Err_Acrobat_test_Click:
MsgBox Err.Description
Resume Exit_Acrobat_test_Click
End Sub
When clicking the CB, Acrobat opens, but gives the following remarks :
"There was an error opening this document. The file does not exists."
"There was an error opening this document. The path does not exists."
Can anyone help me find and solve the problem...??
WFS
I'm trying to open a .PDF from Acces using VBA. I have the following code attached to a command buttom :
Private Sub Acrobat_test_Click()
On Error GoTo Err_Acrobat_test_Click
Dim stAppName As String
stAppName = "C:\Program Files\Adobe\Acrobat 4.0\Reader\AcroRd32.exe D:\WINTERTHUR\PFP\PFP Tool\NL\test.pdf"
Call Shell(stAppName, 1)
Exit_Acrobat_test_Click:
Exit Sub
Err_Acrobat_test_Click:
MsgBox Err.Description
Resume Exit_Acrobat_test_Click
End Sub
When clicking the CB, Acrobat opens, but gives the following remarks :
"There was an error opening this document. The file does not exists."
"There was an error opening this document. The path does not exists."
Can anyone help me find and solve the problem...??
WFS