Open PDF & RTF files from Excel

  • Thread starter Thread starter Chris
  • Start date Start date
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!
 
You can to test:
TaskID = Shell("C:\Program Files\Adobe\Acrobat 5.0\Reader\readme.txt", 1)

Cleber
 
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?
 
You must log in or register to reply here.

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

Similar Threads

Find and replace in Word from Excel 2
Prompt saveas location in Word from Excel 2
Change paragraph format in Word from Excel... 1
After pasting a Chart in Word, excel makes a "restart" 2
Macro copying an array and pasting to a Word bookmark 5
find doc 8
Open new Word file via Excel 3
Import Table / Field Code Data from Word 1

Back
Top