Microsoft Office Forums - View Single Post

Catalin.B · 08-17-2012, 07:55 AM

Try the macro recorder, it will give you a good start point. The recorder is used by many users, from begginers to advanced...
Here is what the macro recorder came up after i manually pasted a link:

Code:

Sub Macro1()
'
' Macro1 Macro
'

'
    Windows("diverse calcule.xls").Activate
    Range("F11").Select
    Selection.Copy
    Windows("New Microsoft Excel Worksheet.xlsx").Activate
    Range("D21").Select
    ActiveSheet.Paste Link:=True
End Sub