Problem with Shell function on .pdf files...

[A. Pach]

This code is giving me an "Invalid argument/component error":

Public Function testShell()
Dim wshell

wshell = Shell("V:\Recruiting\Working Files\Roy's Reports\2005\Period
13\SI Tracking Reports\Summary - Front Office.pdf", 1)

End Function

This is just a test, the path should be replaced with a variant variable
because it came from a list box. Do I need to call the Adobe acrobat
application first?

Also, I use before the FollowHyperlink function, but it doesn't work with
Adobe Reader, it seems to work only with Standard and Professional version
and my users only have the Reader version. Does any one know why?

Thanks!
A. Pach...

 

[Alex Dybenko]

Hi,
long file names with spaces should be double quoted
and suggest to use ShellExecute API instead:
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5

 

[A. Pach]

Thanks for you help Alex! Double quoted works perfect...