Freeze Panes

[JRudisill]

How do I freeze panes with foxpro automation in excel?
Tried range(A1).select
activewindow.freezepanes=.t.
....

 

[JRB-Bldr]

I have not tried this particular operation yet, but typically when I need to discover how to do an Excel Automation operation, I go into Excel and create a Macro of that same operation. I then examine the Macro's resultant VBA code to see what is involved. And finally do the same process with VFP code.

I might suggest that you consider using the same process.

Good Luck,
JRB-Bldr

 

[JRudisill]

I tried this already and I get Activewindow.freezepanes= true. Not sure how activewindow transfers over to VFP.

 

[JRB-Bldr]

Try this in your VFP Command window and see if it gets close to doing what you need:

oExcel = CreateObject("Excel.Application")
oExcel.WorkBooks.add
oExcel.Columns("C:E").Select
oExcel.ActiveWindow.FreezePanes = .T.
<whatever>
oExcel.Quit
RELEASE oExcel

Good Luck,
JRB-Bldr