[AccessD] Freeze Panes

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Mar 2 13:14:35 CST 2007


Charlotte:

When I change the line to:

    objXLS.ActiveSheet.FreezePanes = True

Then I get the same error but on ActiveSheet instead of FreezePanes.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, March 02, 2007 10:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Freeze Panes

Off the top of my head, shouldn't it be ActiveSheet?

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, March 02, 2007 10:20 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Freeze Panes

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
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date: 3/1/2007
2:43 PM
 




More information about the AccessD mailing list