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

Click here to load this message in the networking platform