worksheet linking in VB

tadleymansions · #1 08-17-2012, 03:39 AM

Hi

I am trying to establish an Excel SpecialPaste "Paste Link" using VB code.

Is it possible? - I cannot see how.

John

Catalin.B · #2 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

tadleymansions · #3 08-18-2012, 08:02 AM

Thanks - I'll certainly give that a try.
John

Catalin.B · #4 08-18-2012, 11:19 PM

You may find useful this approach, which does the same thing:

Code:

ThisWorkbook.Sheets("Sheet3").Range("F8").Formula = "='C:\Users\Catalin\Desktop\[New Microsoft Excel Worksheet.xlsx]Sheet1'!$I$16"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Auto-populating" data-worksheet to worksheet.	meggenm	Excel	4	02-04-2012 02:04 AM
Create/delete New worksheet	ibrahimaa	Excel Programming	5	01-16-2012 11:53 PM
How to delete page not worksheet?	rec	Excel	6	05-20-2011 08:51 PM
Can I use a formula to name a worksheet?	nolesca	Excel	3	06-07-2010 04:02 PM
Worksheet copying?	markg2	Excel	4	01-07-2010 10:08 AM