Open files in another program, like pdf, xls or ppt

U

Ulf Nilsson

Hi,

How do I open a pdf-file using VBA? The name can vary.

Following code works:
Dim RetVal
RetVal = Shell("C:\\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe
c:\test\123.pdf", vbMaximizedFocus)

Follwing code does not work:
Dim RetVal
Const fPDF = "C:\Test\123.pdf"
RetVal = Shell("C:\\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe
fPDF", vbMaximizedFocus)

What´s the solution?

/ Ulf
 
W

Word Heretic

G'day "Ulf Nilsson" <[email protected]>,

activedocument.followhyperlink blah de blah


Ulf Nilsson said:
Hi,

How do I open a pdf-file using VBA? The name can vary.

Following code works:
Dim RetVal
RetVal = Shell("C:\\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe
c:\test\123.pdf", vbMaximizedFocus)

Follwing code does not work:
Dim RetVal
Const fPDF = "C:\Test\123.pdf"
RetVal = Shell("C:\\Adobe\Acrobat 5.0\Acrobat\Acrobat.exe
fPDF", vbMaximizedFocus)

What´s the solution?

/ Ulf
Click to expand...

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email: [email protected]
Products: http://www.geocities.com/word_heretic/products.html
Spellbooks: 728 pages of dump left and dropping...

The VBA Beginner's Spellbook: For all VBA users.
 
Top