General information
Category:
Coding, syntax & commands
>>>>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only