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
URL: https://forum.asent.com/forum_posts.asp?TID=2560
Printed Date: January 29 2023 at 1:34am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


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 ATGETPROPERTY(WSROWS,'ActiveWindow',ACTIVE.WINDOW,ERRMSG,OPTS)
     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?

Thanks!


-------------
Colvy



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net