Freezing Panes in Excel from Access 1

[smgeorge99]

I have an Access database that contains code to generate Excel Workbooks/Sheets using information contained in the database. The generated spreadsheets have various formatting and protection features enabled. But what I can't figure out is how to freeze the panes in Excel from within the Access code while the workbook is being generated. The users of the spreadsheet would like to be able to scroll through the page while the row & column headers remain visible.

The only property that seems to be even remotely close to what I'm trying to do is the Worksheet.ScrollArea property, but that doens't seem to do what I want.

Any help would be greatly appreciated.

Sean

 

[GHolden]

Hi, this is an example of how to freeze the panes...

Dim appExcel As New Excel.Application
Dim strPath As String

'set workbook path

strPath = "C:\Test\Test.xls"

With appExcel

'open excel and make application visible
.Visible = True

'Open workbook "C:\Test\Test.xls"
.Workbooks.Open strPath

'move to cell where you wish to freeze the panes
.Range("B2&quot.Select

'freeze panes
.ActiveWindow.FreezePanes = True

'Save workbook
.ActiveWorkbook.Save

'Quit excel
.Quit

End With

Set appExcel = Nothing

Hope this helps.



There are two ways to write error-free programs; only the third one works.

 

[smgeorge99]

Thanks! One purple star for you!