Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FreezePanes in Excel
Message
 
 
To
31/08/2006 22:28:59
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01150285
Message ID:
01150286
Views:
24
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform