View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default View a non-Excel file whose name is in a cell

rtn = Shell("""C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe"" """
& Range("A1").Value & """", 1)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dgfrank99" wrote in message
...
I'm fairly new to VBA, and have been through the existing threads. Good
info, but:

I'm still trying to determine how I can get a non-Excel filename (PDF,
actually) to display in a separate window using the default reader for
that
filetype where the active cell contains the filename. I have the full
pathname in the active cell.

Thanks for any help you can throw my way.