Re: Copy Excel worksheet to another workbook

Dne 16.2.2017 v 17:48 Paul Newton napsal(a):

Hi all

I want to use automation to copy the active worksheet into another workbook (as an additional worksheet) I believe I need something like this ActiveSheet.Copy After:=Workbooks("YourWorkbookName.xls"). Sheets("Sheet3") But I can't find how to send the correct way to do it in VFP

o = CreateObject("Excel.Application") o.Visible = .t. o.Workbooks.Open("C:\O32\OperaNext\Opera32\DEMODATA\SQSLACL.XLS") o.ActiveSheet.Copy(What to put here?)

And what about a little different way?

1. select all 2. copy 3. open another workbook 4. paste

Any help would be much appreciated

Paul Newton

[excessive quoting removed by server]