opkpoly.blogg.se

Basic excel macros
Basic excel macros








basic excel macros

You can use this property to get the screen object for any macro in a session project. InfoConnect provides several other properties that you can use to get key objects when you are creating macros in session projects. For more about these properties, see Using the InfoConnect Object Model. This macro uses an InfoConnect property (ThisScreen for Open Systems or ThisIbmScreen for IBM) to get the screen object for the session. (If your screen doesn't have any text in the upper left part of the display area, you may need to change the row and column arguments and run the macro again to display some text.)

basic excel macros

The message box should display the text on the first line.

  • Place the cursor anywhere in the procedure (Sub) you just created and then press F5.
  • ScreenText = ThisScreen.GetText2(1, 1, 30, 30)

    basic excel macros

    Dim screenText As String 'Get text from the screen starting at screeen column 1, row 1










    Basic excel macros