Hello I am creating a form. I have a dropdown list with yes or no. If
the answer is yes the person has to submit a "certificate" . I want them to
attach the certificate in the excel form (not as an attachment in the e mail)
.. is that possible.?
thanks in advance

See InsertObjectCreate from File

Display as Icon.

The file will be embedded in the workbook.

Save the workbook.

To view the object, double-click on the Icon.

Email recipient must have a suitable application for opening and viewing the
object.


Gord Dibben MS Excel MVP

On Mon, 19 Jan 2009 11:32:00 -0800, Wanna Learn
wrote:

Hello I am creating a form. I have a dropdown list with yes or no. If
the answer is yes the person has to submit a "certificate" . I want them to
attach the certificate in the excel form (not as an attachment in the e mail)
. is that possible.?
thanks in advance

Thanks - perfect.

I tried to create a macro to make it easier for the end user . I wanted to
use a command button then add a macro using the instructions below but I
cannot record the macro
Is a macro possible or is there an another way ?
thanks in advance

"Gord Dibben" wrote:

See InsertObjectCreate from File

Display as Icon.

The file will be embedded in the workbook.

Save the workbook.

To view the object, double-click on the Icon.

Email recipient must have a suitable application for opening and viewing the
object.


Gord Dibben MS Excel MVP

On Mon, 19 Jan 2009 11:32:00 -0800, Wanna Learn
wrote:

Hello I am creating a form. I have a dropdown list with yes or no. If
the answer is yes the person has to submit a "certificate" . I want them to
attach the certificate in the excel form (not as an attachment in the e mail)
. is that possible.?
thanks in advance

Why can you not record a macro whilst following the steps?

I just recorded this macro to insert an *.mdb file that opens in Access when
double-clicked.

ActiveSheet.OLEObjects.Add(Filename:= _
"C:\Program Files\Accu-Chek Compass\Data\compass.mdb", Link:=False, _
DisplayAsIcon:=True, IconFileName:= _
"""C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE""
/NOSTARTUP ""%1""" _
, IconIndex:=0, IconLabel:= _
"C:\Program Files\Accu-Chek Compass\Data\compass.mdb").Select


Gord

On Tue, 20 Jan 2009 08:12:06 -0800, Wanna Learn <Wanna
wrote:

Thanks - perfect.

I tried to create a macro to make it easier for the end user . I wanted to
use a command button then add a macro using the instructions below but I
cannot record the macro
Is a macro possible or is there an another way ?
thanks in advance

"Gord Dibben" wrote:

See InsertObjectCreate from File

Display as Icon.

The file will be embedded in the workbook.

Save the workbook.

To view the object, double-click on the Icon.

Email recipient must have a suitable application for opening and viewing the
object.


Gord Dibben MS Excel MVP

On Mon, 19 Jan 2009 11:32:00 -0800, Wanna Learn
wrote:

Hello I am creating a form. I have a dropdown list with yes or no. If
the answer is yes the person has to submit a "certificate" . I want them to
attach the certificate in the excel form (not as an attachment in the e mail)
. is that possible.?
thanks in advance