>>>>>>>>To create a report in Excell spreadsheet I pass data from VFP table
>>>>>>>>into worksheet through OLE-Automation.
>>>>>>>>While opening saved worksheet in Excell I have to WINDOW/UNHIDE
>>>>>>>>it manually. Can I change a worksheet property before saving
>>>>>>>>to make this sheet unhidden?
>>>>>>>>TIA
>>>>>>>>Ed
>>>>>>>
>>>>>>>oExcel=createobject('Excel.Application')
>>>>>>>oExcel.Visible=.t.
>>>>>>
>>>>>>Hi, Ed!
>>>>>>I tried it already but it doesn't work.
>>>>>>The oExcell is visible while running vfp program.
>>>>>>I need to save this object and open it in Excell later.
>>>>>>Thanks
>>>>>>Ed
>>>>>
>>>>>then why not to save excel file and open it in Excel later?
>>>>
>>>>Yes, I do it. But worksheet is hidden and I have to click on
>>>>UNHIDE in window menu.
>>>>ED
>>>
>>>Normally, xls file shouldn't appear as hidden. To bring it up as OLE automation, you can use this code:
>>>oExcel=createobject('Excel.Application')
>>>oWorkbook=oExcel.Workbooks
>>>oWorkbook.open('c:\temp\tmp.xls')
>>>oExcel.visible=.t.
>>
>>Thank you very much for help.
>>Where can I find more about OLE automation ?
>>Ed
>
>You need to know just first command: createobject.... All other things are from Excel help file.

Thanks for help.
Have a good day
Ed