Print Page | Close Window

Object Bridge FreezePanes in Excel

Printed From: Rocket Software
Category: AccuTerm Knowledge Base (read only)
Forum Name: Code Samples
Forum Description: Share your code samples and discuss the bundled sample programs
Printed Date: February 25 2024 at 4:29am
Software Version: Web Wiz Forums 12.03 -

Topic: Object Bridge FreezePanes in Excel
Posted By: Colvy
Subject: Object Bridge FreezePanes in Excel
Date Posted: January 15 2016 at 6:52am
I have tried to freeze the top row of an Excel spreadsheet using the Object Bridge subroutines, but it does appear to be working.  Does anyone have any suggestions?

* Freeze the top 1 rows:   (DOES NOT WORK!)
     CALL ATGETPROPERTY(Worksheet, 'Rows':SVM:'2',WSROWS,ERRMSG,OPTS)  ;*** Set rows to 1 past the last heading line
     CALL ATSETPROPERTY(ACTIVE.WINDOW,'FreezePanes','1',ERRMSG,OPTS)   ;*** 1=True, 0=False

Does anyone have any documentation on the passed variables to the ATGETPROPERTY and ATSETPROPERTY subroutines?



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 -
Copyright ©2001-2019 Web Wiz Ltd. -