View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jarle Jarle is offline
external usenet poster
 
Posts: 32
Default 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