Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 2 12:19:41 CST 2007
Dear List: I am trying to do a Freeze Panes on an Excel spreadsheet I create in an access app. But I can't seem to get the code right. I'm using: objXLS.Range("B2").Select objXLS.ActiveWindow.FreezePanes = True but the compiler doesn't like ActiveWindow, says Method or Data Member not found. There's a bunch of other formatting that's working OK. Mostly cribbed from recording macros in Excel. Does anyone know offhand the correct syntax for freezing the panes? MTIA Rocky