I wan to link cells in my Source.xls into my Recieving.xls workbook. I kow you can do this by the following (without code, i.e in Excel)

Open both workbooks.
Select the range on the "sending" worksheet.
edit|copy
select the range on the "receiving" worksheet that should be linked.
edit|Paste special|paste link

But can this be done withing VBA, VB or VB.Net?