Open document with Shell
 

To open a pdf document I can use following line that works.

Shell "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " & filename

I have two questions

Question 1:
Based on tip I find in different vba groups it seems that it should be
possible to generelize the function in order to open any document format. I
find codes that looks like:

Shell "Start.exe " & filename
Shell "Start " & filename
(and also other variations)

For all these I retrieve "File not found"

Question 2:
How to let the macro make the opened document active?


rgds
Jarle

Open document with Shell
 

see your other thread

Regards,
Peter T

"Jarle" wrote in message
...
To open a pdf document I can use following line that works.

Shell "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe " & filename

I have two questions

Question 1:
Based on tip I find in different vba groups it seems that it should be
possible to generelize the function in order to open any document format.
I
find codes that looks like:

Shell "Start.exe " & filename
Shell "Start " & filename
(and also other variations)

For all these I retrieve "File not found"

Question 2:
How to let the macro make the opened document active?


rgds
Jarle