Freeze Panes with Object Model
 

Is the Excel application.Visible?
Is the workbook visible?

Workbooks("Book1.xls").Windows(1).Visible = True
Workbooks("Book1.xls").Activate
Worksheets("Sheet1").Activate
Rows(1).Select
ActiveWindow.FreezePanes = true


Regards,
Tom Ogilvy


"John Renkar" wrote in message
...
I am using Access to export a query to an Excel Workbook.
I then need to format the workbook from Access. I am able
to do everything I need except freexe the top row.

The online help suggests using:

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activa te
ActiveWindow.FreezePanes = True

I get a run time error '438':
Object doesn't support this property or method

Is there another way to accomplish this?

Thank you in advance

John