>I have tried to have a look but I can't get into it as I don't have access. Could you please help me with the code,
>Here is the code...
>
>select * from excel1 into cursor cur_excel
>
>select cur_excel
>
>copy to c:\filename type xls
>
>temp_sheet = createobject('excel.application')
>
>temp_sheet.application.visible = .T.
>
>...and I don;t know where to go next. I am trying to locate some documentation on the subject but can't find any.
>
>Thanks
>
Hi Nicky,
I think the syntax would temp_sheet.workbooks.open(filename). Look for the file VBAXL8.HLP on your hard drive. It's the Excel VBA help file. It's an optional component and you may have to install it.
George
Ubi caritas et amor, deus ibi est