Hi T-Rex,

Thanks but still not too sure how to run the Function - I normally just use
subroutines. Can this be adapted? I have put in my path but where in this
functiion do I insert my filename? Thanks in advance.

--
Andrew


"T-®ex" wrote:


Hi! Maybe this can help...

Function OpenPDFFile(PDFFile As String) As Double
OpenPDFFile = Shell("C:\Program Files\Adobe\Acrobat
6.0\Reader\AcroRd32.exe " & PDFFile, vbNormalFocus)
End Function

You should change "C:\Program Files\Adobe\Acrobat
6.0\Reader\AcroRd32.exe " to your appropriate adobe install path. *Mind
the SPACE after the application name (AcroRd32.exe<SPACE_HERE).*

;)

Andrew Wrote:
Hi,

Can someone please assist with a way of opening an Adobe Acrobat Reader
PDF
file. If Adobe isn't open do I need to I need to 'shell' to it first?
--
Andrew


--
T-®ex
------------------------------------------------------------------------
T-®ex's Profile: http://www.excelforum.com/member.php...o&userid=26572
View this thread: http://www.excelforum.com/showthread...hreadid=398810