Code to Insert File as Icon & Open Browse Dialog Box
'for the second part of the question
strFile = Application.GetOpenFilename
ActiveSheet.OLEObjects.Add Filename:=strFile, Link:=False, _
DisplayAsIcon:=True, IconFileName:=strIconFile, IconIndex:=0, _
IconLabel:=strFile
'Record a macro..and edit to suit...
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
strFile = Application.GetOpenFilename
If this post helps click Yes
---------------
Jacob Skaria
"Joyce" wrote:
Hi,
I am wondering if it's possible to get users of a file to the Browse dialog
box when inserting an object as an icon.
This gets me almost there...
ExecuteExcel4Macro "INSERT.OBJECT?(,""C:\"",False,True,)"
Thank you.
|