attached a file to an excel document -maybe

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

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 Insert>Object>Create 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
 
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
 
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
 
Back
Top