Skip to main content

[archive] First line in Excel on top (activex)

  • January 11, 2007
  • 2 replies
  • 0 views
D

[Migrated content. Thread originally posted on 10 January 2007]

Does anyone know how to have the first line in Excel stay on top.
I made a macro which was: ActiveWindow.SplitRow = 1

How do I translate this in cobol (using ActiveX)?

Andre

    2 replies

    D

    [Migrated content. Thread originally posted on 10 January 2007]

    Does anyone know how to have the first line in Excel stay on top.
    I made a macro which was: ActiveWindow.SplitRow = 1

    How do I translate this in cobol (using ActiveX)?

    Andre
    I have not looked at the dictionary, but presuming you application object is in OApp, I would do this:

    MODIFY OApp ActiveWindow::SplitRow = 1.
    D

    [Migrated content. Thread originally posted on 10 January 2007]

    Does anyone know how to have the first line in Excel stay on top.
    I made a macro which was: ActiveWindow.SplitRow = 1

    How do I translate this in cobol (using ActiveX)?

    Andre
    Yes that's it.
    Thanks a lot.

    Andre

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement