[AccessD] Freeze Panes

Jim:
The problem is the next line which won't compile.  So I can't even test the
Rows statement. :(

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Moss
Sent: Friday, March 02, 2007 12:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Freeze Panes

Rocky,

I think that you probably need a .rows statement before the freezepanes
statement, like:
 objSht.Rows("3:3").select or a columns if you aren't trying to freeze the
sheet below the title line

Jim

> 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
>
>
> --
> 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