Skip to main content

how to copy a worksheet to the end of workbook?

  • July 31, 2012
  • 3 replies
  • 0 views
D

i got this method in Micro Focus\\Net Express\\Base\\DEMO\\COMDEMOS\\EXCEL\\MSEXCEL.CPY:

      *> Method: "Copy".
      *> 01 Before-CBL                  VARIANT.
      *> 01 After-CBL                   VARIANT.
      *> invoke using
      *>       by value Before-CBL     *> [IN][OPTIONAL]
      *>       by value After-CBL      *> [IN][OPTIONAL].

but i don't know how to use it.

    3 replies

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • August 1, 2012

    i got this method in Micro Focus\\Net Express\\Base\\DEMO\\COMDEMOS\\EXCEL\\MSEXCEL.CPY:

          *> Method: "Copy".
          *> 01 Before-CBL                  VARIANT.
          *> 01 After-CBL                   VARIANT.
          *> invoke using
          *>       by value Before-CBL     *> [IN][OPTIONAL]
          *>       by value After-CBL      *> [IN][OPTIONAL].

    but i don't know how to use it.

    i got it.

    example:

    *>get a variant object by any which method can

    invoke xlApp "getMailSession" returning variantObj.

    *>firstly it is Null

    invoke xlSheet "Copy" using variantObj xlSheet.

    thanks for Rick's help.

    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • April 19, 2018

    i got this method in Micro Focus\\Net Express\\Base\\DEMO\\COMDEMOS\\EXCEL\\MSEXCEL.CPY:

          *> Method: "Copy".
          *> 01 Before-CBL                  VARIANT.
          *> 01 After-CBL                   VARIANT.
          *> invoke using
          *>       by value Before-CBL     *> [IN][OPTIONAL]
          *>       by value After-CBL      *> [IN][OPTIONAL].

    but i don't know how to use it.

    Hi Lazycop, Thanks for your very RICH help.
    You should work in Micro Focus technical support.
    D
    • Dominique SacreRocketeer
    • Author
    • Rocketeer
    • 19312 replies
    • April 19, 2018

    i got this method in Micro Focus\\Net Express\\Base\\DEMO\\COMDEMOS\\EXCEL\\MSEXCEL.CPY:

          *> Method: "Copy".
          *> 01 Before-CBL                  VARIANT.
          *> 01 After-CBL                   VARIANT.
          *> invoke using
          *>       by value Before-CBL     *> [IN][OPTIONAL]
          *>       by value After-CBL      *> [IN][OPTIONAL].

    but i don't know how to use it.

    Hi Lazycop, Thanks for your very RICH help.
    You should work in Micro Focus technical support.


    Terms & ConditionsAccessibility statement