Freeze Panes from Access

[AlexanderBB]

I'm building a Excel Workbook from Access after setting a new Excel.Application.

Set ws= objExcelApp.Workbooks.Open(Myfile).Sheets(1)

With this I am able to use methods ws.cells, ws.columns etc.

I would like to freeze the top row of sheets(1) but haven't been able to figure it out.
In Excel this would be

Range("A2").Select
ActiveWindow.FreezePanes= true

I am able to select the range of my Excel object, but would need some other way to FreezePanes.
Does anyone know if this is possible ?

 

[Norie]

Have you tried using objExcelApp?

objExcelApp.ActiveWindow.FreezePanes = True

PS You should probably use objExcelApp to select the cell and include worksheet/workbook references.

 

[AlexanderBB]

Many thanks Norie that did it nicely. Not sure if I'm using objExcelApp as you suggest. I have

 Set objExcelApp = CreateObject("Excel.Application")
 Set wb = objExcelApp.Workbooks.Open(Fullpath & Me.Code & ".xlsx")
 Set ws = wb.Sheets(1)
 With ws
...