Hi:
Using this macro to insert object from file.
'Start - Macro to insert object (Create from file)
Sub AddAttachment()
'declare a variable to hold the file name:'
Dim FName As String
Range("B51").Select
'load the variable via an input box:'
FName$ = Application.GetOpenFilename
'get the file:
ActiveSheet.OLEObjects.Add(Filename:=FName, _
Link:=False, _
DisplayAsIcon:=True).Select
End Sub
'End - Macro to insert object (Create from file)
How can I enhance so that the object shows the file type (example: Word, Excel), file name and has a specific size? Right now the object is created but it fills the entire cell (which is quite wide) and does not show file name or file type.
Thanks.
Bookmarks