How to Open A File with Visual Basic
 

I am trying to write a command for a command button in
Excel (on click). When I got to the visual basic editor
what is the syntax for opening a file such
as "C:\Reports\Reports.pdf. Thank you

How to Open A File with Visual Basic
 

Lance

something like:

Shell "C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe
C:\WRATBlue[1].pdf"

Regards

Trevor


"Lance" wrote in message
...
I am trying to write a command for a command button in
Excel (on click). When I got to the visual basic editor
what is the syntax for opening a file such
as "C:\Reports\Reports.pdf. Thank you