attach file as icon in a worksheet (hope it's not so tricky)
 

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.

attach file as icon in a worksheet (hope it's not so tricky)
 

Not completely reliable, but:

SendKeys "{TAB}{TAB}{TAB}{TAB}{RIGHT}%a%n"
Application.Dialogs(xlDialogInsertObject).Show

--

Vasant



"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.

attach file as icon in a worksheet (hope it's not so tricky)
 

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.

attach file as icon in a worksheet (hope it's not so tricky)
 

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.

attach file as icon in a worksheet (hope it's not so tricky)
 

Excellent!!! Billions thanks to Tom!! and Vasant too!

"Tom Ogilvy" wrote:

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.