Open a file from share

[Maik]

Hello,

what is the best way to open a file from a share?

The following code will get the error 5: runtime error

rc = Shell("\\server\share\test.txt")

Thanks for your help

Maik

 

[Jim Cone]

Try...
rc = Shell("Notepad.exe " & """\\server\share\test.txt""", vbNormalFocus)
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ExtrasXL




"Maik" <[email protected]>
wrote in message
Hello,
what is the best way to open a file from a share?
The following code will get the error 5: runtime error
rc = Shell("\\server\share\test.txt")
Thanks for your help
Maik