Nikki,
The quickest way I have found to see what to do next is to open up excel and start to record a macro. Do whatever you are going to want to do from VFP. Then edit the macro. It will contain the sequence of commands in VBA language. Just convert the VBA to VFP and you are on your way.
PF
>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
>
>Nicky
(On an infant's shirt): Already smarter than Bush