I hadn't seen anyone mention this, but this class library may be helpful. Greg Greene was attempting to manipulate XLSX files without the need for Excel at all.
https://vfpx.codeplex.com/wikipage?title=XLSXWorkbook&referringTitle=Hom...
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Paul Newton Sent: Thursday, February 16, 2017 11:48 AM To: profox@leafe.com Subject: Copy Excel worksheet to another workbook
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?)
Any help would be much appreciated
Paul Newton
[excessive quoting removed by server]