Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to unhide Excell worksheet
Message
From
08/07/1998 16:00:20
 
 
To
08/07/1998 15:51:51
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00115430
Message ID:
00115452
Views:
16
>>>>>>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
Map
View

Click here to load this message in the networking platform