Hi there,
I'm looking to use the shell function to dynamically call different pdfs that are in a directory. However I'm getting run time error 5 "Invalid procedure or call argument".
Here is the code (very basic I know)..
Private Sub Liste_Documentation_DblClick(Cancel As Integer)
Dim PathName As String
PathName = Me.Liste_Documentation.Column(2)
' Debug.Print PathName
Shell PathName
End Sub
A typical filepath name is as follows..
S:\Vente\Vendeurs\Marc\CRM\DOCS\Diligences KYC - LABFT - V 2013 04 23.pdf
Any help would be greatly appreciated.
Many thanks,
MOR
I'm looking to use the shell function to dynamically call different pdfs that are in a directory. However I'm getting run time error 5 "Invalid procedure or call argument".
Here is the code (very basic I know)..
Private Sub Liste_Documentation_DblClick(Cancel As Integer)
Dim PathName As String
PathName = Me.Liste_Documentation.Column(2)
' Debug.Print PathName
Shell PathName
End Sub
A typical filepath name is as follows..
S:\Vente\Vendeurs\Marc\CRM\DOCS\Diligences KYC - LABFT - V 2013 04 23.pdf
Any help would be greatly appreciated.
Many thanks,
MOR