I want to be able to click a button and prompt an Open file Dialog box and then I want to copy the file (.jpg, .gif, .bmp) selected and paste it on the excel sheet in (A1). I'm using excel 2000.
:eek2:
Printable View
I want to be able to click a button and prompt an Open file Dialog box and then I want to copy the file (.jpg, .gif, .bmp) selected and paste it on the excel sheet in (A1). I'm using excel 2000.
:eek2:
Does this help?
vb Code:
Private Sub CommandButton1_Click() Dim sFilename As String sFilename = Application.GetOpenFilename("All files (*.*), *.*") ' To Exit if Cancel was pressed If sFilename = "False" Then Exit Sub ActiveSheet.Pictures.Insert(sFilename).Select End Sub
Yes, thanks!!!:wave: