Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FreezePanes in Excel
Message
From
31/08/2006 22:39:21
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01150285
Message ID:
01150287
Views:
21
I tried that, and got the error message, that the property ActiveWindow was not found. But I will try again tomorrow, just in case I committed some mistake.

>
oExcel.ActiveWindow.FreezePanes = .T.
>
>>How do I automate "Freeze Panes" in Excel?
>>
>>When I freeze panes in Excel, the macro recorder gives me:
>>
>>
>>ActiveWindow.FreezePanes = True
>>
>>
>>To what object should I apply the .FreezePanes property, when using Automation?
>>
>>This.oSheet contains a reference to the current sheet, with which I work all the time.
>>
>>I also have a property This.oExcel, as a reference to Excel.
>>
>>I tried:
>>
>>
>>This.oSheet.FreezePanes = .T. && The active sheet
>>* and:
>>This.oSheet.Parent.FreezePanes = .T. && The workbook
>>
>>
>>but both show error messages, in the sense that the property does not exist.
>>
>>I also tried using This.oExcel.ActiveWindow, but it seems the property ActiveWindow doesn't exist.
>>
>>TIA,
>>
>>Hilmar
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform