Using Excel Paste Link in VFP

[pristau]

I cannot deduce how to implement Excel's Paste Link function in VFP (v.8 in this case). Recording a macro in Excel results in the following VB code (snippet):

...
Selection.Copy
Sheets("Sheet1").Select
ActiveSheet.Paste Link:=True
...

What is the VFP equivalent of .Paste Link:=True? I have tried .PasteLink(),which fails.

Moreover, is there a convention or rule for translating these kinds of VB statements to equivalent VFP statements?

Thanks, Tamar and Della, for your getting me thus far by your book Microsoft Office Automation with Visual FoxPro.

Regards,

Peter Ristau

 

[bborissov]

ActiveSheet.Paste(, .t.)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[pristau]

Perfect! Works great; thanks, Borislav.

-Peter