>Hi All,
>
>This is my 1st attempt at OLE Automation. I have a table from a x-tab query that I would like to transfer to an Excel worksheet for viewing, maybe even create a report with Text and company logo. I'm a little confused, do I use CREATEOBJECT('Excel.sheet') and export the data to the worksheet?? VFP help is a little vague in the matter.
>
>TIA
select yourtable
copy to c:\temp\test.xls type xls
oExcel=createobject("Excel.Application")
oExcel.Workbooks.open("c:\temp\test.xls")
oExcel.visible=.t.
Edward Pikman
Independent Consultant