#1
|
|||
|
|||
Attaching/Saving Embedded Objects
I am building a manual intake form. The user will fill out the necessary fields of the form. Sometimes the user will need to add an attachment/embedded object when completing the form. Here is my problem. I need a macro that will browse for a file (all file types: doc, excel, pdf and etc), then allows the user to attach a document to the form. The name of the Excel worksheet is name "Manual Intake Request"...Is it possible to save the attachment/embedded object in cell A105 of the "Manual Intake Request" worksheet of my workbook?
I would like to save the document(s) to a specified file location on the C drive. But before the document is saved, I would like to rename the attachment based off the information in a cell located on Sheets("Data").Range ("O3"). Finally after the document has been renamed and saved, I would like to delete the attachment/embedded object from the workbook. Can you help me??? Please.... |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening Embedded objects with a hyperlink | ml920 | Word | 1 | 07-10-2014 09:36 PM |
Embedded objects with Password protection | Simy | Word | 6 | 04-16-2014 04:47 AM |
Using objects to pull up embedded youtube videos | jaredmccullough | PowerPoint | 0 | 01-22-2014 07:34 AM |
Converting linked objects to embedded in Word 2010 | wduvall | Word | 0 | 01-15-2014 03:50 PM |
PowerPoint Embedded Chart Objects Resizing | aeddipa | PowerPoint | 0 | 07-06-2009 09:41 AM |