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

[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

 

[Word Heretic]

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

activedocument.followhyperlink blah de blah

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

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
Email: (e-mail address removed)
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.

 

[Ulf Nilsson]

Thanks Steve,

So easy it is when one knows....

/ Ulf