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.

Not completely reliable, but:

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

--

Vasant



"jacko" <(E-Mail Removed)> wrote in message
news:579037D4-0BF6-41BD-BE65-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:579037D4-0BF6-41BD-BE65-(E-Mail Removed)...
> 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.

Nice one, Tom!

Regards,

Vasant

"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:579037D4-0BF6-41BD-BE65-(E-Mail Removed)...
> > 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.
>
>

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" <(E-Mail Removed)> wrote in message
> news:579037D4-0BF6-41BD-BE65-(E-Mail Removed)...
> > 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.
>
>
>