click a button to open a picture

[clarksonneo]

Hi,

I want to click a button in an Excel file to open a picture in a folder my company, eg ("C:\Users\XX\Desktop\FOLDER1\1.jpg")

How can I do that?

Thanks

[Sean.DiSanti]

the easiest way would be to use Shell to call a program passing the file name as a parameter... like:
[VBA]Shell "mspaint.exe C:\Users\XX\Desktop\FOLDER1\1.jpg"[/VBA]

[clarksonneo]

the easiest way would be to use Shell to call a program passing the file name as a parameter... like:
[vba]Shell "mspaint.exe C:\Users\XX\Desktop\FOLDER1\1.jpg"[/vba]

Thank you for your reply.
Your code is work.

However, i don't want to use mspaint to open the photo.

I have tried to use "WLXPhotoGallery.exe"
it is at C:\Program Files\Windows Live\Photo Gallery\WLXPhotoGallery


However, my code is not work

Sub photo_Click()

Shell "WLXPhotoGallery.exe C:\Users\XX\Desktop\FOLDER1\1.jpg"

End Sub



Could you please tell me any mistake on my code?
I think the problem is at WLXPhotoGallery.exe



On the other hand, how can i insert a picture by checking a button?

Thanks

[Sean.DiSanti]

use the full path:
[VBA]Shell "C:\Program Files\Windows Live\Photo Gallery\WLXPhotoGallery\WLXPhotoGallery.exe C:\Users\XX\Desktop\FOLDER1\1.jpg"[/VBA]
i didn't list the path in mine because mspaint is located in system32 and can be called without the path written out.

[Bob Phillips]

What do you mean by open? Are you trying to insert it into a spreadsheet?

[Sean.DiSanti]

it looks like he wants to open it in another program, i think this one can be marked solved

[clarksonneo]

use the full path:
[vba]Shell "C:\Program Files\Windows Live\Photo Gallery\WLXPhotoGallery\WLXPhotoGallery.exe C:\Users\XX\Desktop\FOLDER1\1.jpg"[/vba] i didn't list the path in mine because mspaint is located in system32 and can be called without the path written out.

hi Sean.DiSanti,
Your code does work.
However, the picture will be closed automatically just after it opens.



it looks like he wants to open it in another program
yes

[Sean.DiSanti]

closed automatically? it shouldn't be

[clarksonneo]

closed automatically? it shouldn't be

closed automatically? it shouldn't be
yes closed automatically.

Now, I use another way

ActiveSheet.Pictures.Insert (" file' location + flie's name)

This work.
It inserts a picure instead of opening the picture by another program

Thanks