Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement