Open PDF & RTF files from Excel

C

Chris

I'd like to open PDF and RTF files from Excel. I've tried some codes
but don't work. Followings are my codes which DON'T WORK. Please give
me some advice.

For PDF:
TaskID = Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader
readme.txt,1")

For RTF:

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Set wrdApp = New Word.Application
Set wrdDoc = wrdApp.Documents.Open(FileName)

I need to launch the application and the file. TKS!
 
C

Cleber P. de Souza

You can to test:
TaskID = Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader\readme.txt", 1)

Cleber
 
J

JMMach

Perhaps this is simplistic, but how about taking a cell is Excel, then
manually creating a hyperlink to the file, then have the VBA code run that
hyperlink?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top