Inserting Object in Excel using VB

I have a command button within a userform I am developing, which will automatically take the user to the Excel Insert Object function

Private Sub CommandButton2_Click()
Application.Dialogs(xlDialogInsertObject).Show
End Sub

What I need to understand is how, using VB script, once the user has selected the file and clicks on OK within the Insert Object function, that the selected file is then 'attached' to a specific cell within the userform.

Also, within the existing CommandButtom script, is there anyway when the Insert Object function opens, to default it to Create From File, Vs Create New as it currently defaults to?

[712 byte] By [LanceClark] at [2008-1-7]