LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default shell - open document

I want to open a document. Document format may vary.

I try with:

Dim f_name as String
Dim Returnvalue as Variant
f_name ="E:\forlder1\folder2\test.pdf"

ReturnValue = Shell("start " & Chr$(34) & f_name Chr$(34) )

According to a tip on a different web-site this should open the file in the
program it is connected to (he Acrobat Reader).

I always get error message "file not found", but the file is there.
What is wrong?

rgds
Jarle
 
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
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 to open an application and pass parameters to it jwkz Excel Programming 3 August 12th 05 09:41 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 05:35 PM.

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

About Us

"It's about Microsoft Excel"