Nice one, Tom!

Regards,

Vasant

"Tom Ogilvy" wrote in message
...
Sub showDialog()
'INSERT.OBJECT?(object_class, file_name, link_logical,
' display_icon_logical, icon_file, icon_number, icon_label)
ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)"
End Sub


--
Regards,
Tom Ogilvy


"jacko" wrote in message
...
i wish to create a button (from forms) and when click on it, it will pop
up
the Insert Object dialog box, and automatically go to Create From File
tab
with Display As Icon selected. Then it allows the user to select any
file
to
attach to the worksheet.

how do i do this with the button and macro? i hope it's not the tricky
one
and appreciate experts out there can help.