Opening Images with VBA

[GilesC]

Hi,
I have a problem in that I want to be able to specify the path of an image, stored in a text box and by clicking a button I want the correct application to open up and display the image.
So far I've used

dim myFilePath as string
myFilePath=txtFilePath
Shell "Path of Application " & myFilePath

Which is working well unless myFilePath has a space in it!
Please help.
Thanks,
Giles

 

[dsi]

Try using the ShellExecute API call:

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Call ShellExecute(0&, vbNullString, myFilePath, vbNullString, vbNullString, 5)