Zumasys Homepage
Forum Home Forum Home > AccuTerm > Code Samples
  New Posts New Posts RSS Feed - Object Bridge FreezePanes in Excel
  FAQ FAQ  Forum Search   Register Register  Login Login

Object Bridge FreezePanes in Excel

 Post Reply Post Reply
Author
Message
Colvy View Drop Down
Newbie
Newbie
Avatar

Joined: September 14 2015
Location: Arlington, TX
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Colvy Quote  Post ReplyReply Direct Link To This Post Topic: Object Bridge FreezePanes in Excel
    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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

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