Hi All,

Im looking for a way to not only insert/embed an object into my worksheet
(which works below), but have the directory select the file based on an
existing PDF named file. I have users entering data into certain cells which
in turn uses a formula to concatenate their entries into cell A1. This cell
will be the name of the file thats already residing out on the noted path.
So far, I can only get it to embed the file when the name is static
(hardcoded name in question mark fields). Id like to instead have it select
the file based on the name in the A1 cell. The worksheet is called Sheet1
and again the cell that names the PDF is A1.

Any thoughts or ideas on how to make this happen?

Thanks in advance €“ Jenny B.




Sub InsertNamedObject()

ActiveSheet.OLEObjects.Add(Filename:= _
"C:\Documents and Settings\Jenny B.\My Documents\???????", Link:= _
False, DisplayAsIcon:=True, IconFileName:= _

"C:\WINDOWS\Installer\{AC76BA86-1033-F400-7760-000000000004}\_PDFFile.ico", _
IconIndex:=0, IconLabel:= _
"C:\Documents and Settings\Jenny B\My
Documents\BKA1303005.PDF").Select

End Sub