Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
shell - open document Jarle Excel Programming 6 April 8th 08 10:01 PM
Using Shell to open files with more than one word in their name Phil1982 Excel Programming 3 March 16th 06 09:26 PM
Using Shell to open files with more than one word in their name Tom Ogilvy Excel Programming 0 March 16th 06 06:55 PM
Shell can open an application, can it close an app too? quartz[_2_] Excel Programming 4 April 26th 05 03:30 PM
Shell to different app then open file within Justin[_12_] Excel Programming 0 November 30th 04 11:26 PM


All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"