Hello Experts.
I've found a macro with the function of inserting an embedded file, such as - Insert>Object>create from file>Browse.
I would now like to be able to predefine the borders and lines of the insertet file, so there is none.
My current macro goes like this:
Sub Macro1()
'declare a variable to hold the file name:'
Dim FName As String
On Error Resume Next
'load the variable via an input box:'
FName$ = Application.GetOpenFilename
'get the file:
ActiveSheet.OLEObjects.Add(Filename:=FName, _
Link:=False, _
DisplayAsIcon:=False).Select
End Sub
Is that possible?
Thanks in advance.
Regards - Emil
Bookmarks