Seeking VBA equivalent of launching MSPAINT c:\image.bmp with XP's START button

[MLH]

What's the best way to launch MSPAINT c:\image.bmp
from a VBA procedure. Seeking the route with the least
number of complications. Hopefully there will be no more
complications than if I clicked START and typed in the
command myself.

[fredg]

On Sun, 17 Feb 2008 18:56:44 -0500, MLH wrote:

What's the best way to launch MSPAINT c:\image.bmp
from a VBA procedure. Seeking the route with the least
number of complications. Hopefully there will be no more
complications than if I clicked START and typed in the
command myself.

Are your .bmp file types set up to open in Paint?
Simplest for me is:

Application.FollowHyperlink "c:\Foldername\ImageName.bmp"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Dominic Vella]

' Specifying 1 as the second argument opens the application in
' normal size and gives it the focus.
Dim RetVal
RetVal = Shell("c:\windows\system32\mspaint.exe", 1) ' Run MSPaint.
"MLH" <CR**@NorthState.netwrote in message
news:r7********************************@4ax.com...

What's the best way to launch MSPAINT c:\image.bmp
from a VBA procedure. Seeking the route with the least
number of complications. Hopefully there will be no more
complications than if I clicked START and typed in the
command myself.

[MLH]

Putting it in click event did the trick nicely.
Thx.