Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to unhide Excell worksheet
Message
De
08/07/1998 16:00:20
 
 
À
08/07/1998 15:51:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00115430
Message ID:
00115452
Vues:
17
>>>>>>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
Fil
Voir

Click here to load this message in the networking platform