Высокоуровневые методы информатики и программирования: Методические указания для выполнения лабораторных работ

  • View
    224

  • Download
    5

Embed Size (px)

Transcript

  • -

    ..

    - 2006

  • 2

    681.3

    .. // - . . 2006.

    . -

    Excel VBA VBA , -

    Excel VBA -

    VBA, Excel.

    , -

    351400 ,

    -

    ,

    .

    :

    . .

    . . , 2006

  • 3

    .................................................................................................................................................................. 3

    EXCEL VBA.................................................6

    Excel,

    Excel................................................................................................................................................................................... 6 ............................................................................................................................................... 6 ........................................................................................................................................................................ 10 .................................................................................................................................... 10 ............................................................................................................................................... 12 ............................................................................................................................................................ 13

    VBA ................................................................................................... 15 ............................................................................................................................................. 15 ........................................................................................................................................................................ 17 .................................................................................................................................... 18 ............................................................................................................................................... 19 ............................................................................................................................................................ 20

    Excel VBA ......................................................................................................................... 20 ............................................................................................................................................. 20 ........................................................................................................................................................................ 29 .................................................................................................................................... 30 ............................................................................................................................................... 31 ............................................................................................................................................................ 31

    VBA...................................................................................32

    VBA....................................................................................................................................... 32 ............................................................................................................................................. 32 ........................................................................................................................................................................ 47 .................................................................................................................................... 48 ............................................................................................................................................... 48 ............................................................................................................................................................ 49

    . Excel ................................................................. 49 ............................................................................................................................................. 49 ........................................................................................................................................................................ 57 .................................................................................................................................... 57

  • 4

    ............................................................................................................................................... 58 ............................................................................................................................................................ 59

    ......................................................................................................................................................... 59 ............................................................................................................................................. 59 ........................................................................................................................................................................ 67 .................................................................................................................................... 67 ............................................................................................................................................... 69 ............................................................................................................................................................ 69

    - VBA ............................................................................... 70 ............................................................................................................................................. 70 ........................................................................................................................................................................ 74 .................................................................................................................................... 74 ............................................................................................................................................... 76 ............................................................................................................................................................ 76

    VBA .......................................................................................................... 76 ............................................................................................................................................. 76 ........................................................................................................................................................................ 79 .................................................................................................................................... 80 ............................................................................................................................................... 81 ............................................................................................................................................................ 81

    EXCEL VBA 82

    Excel........................................................................................................... 82 ............................................................................................................................................. 82 ........................................................................................................................................................................ 88 .................................................................................................................................... 89 ............................................................................................................................................... 89 ............................................................................................................................................................ 90

    ............................................................................................................................................... 90 ............................................................................................................................................. 90 ........................................................................................................................................................................ 97 .................................................................................................................................... 97 ............................................................................................................................................... 97 ............................................................................................................................................................ 98

    VBA, Excel ...................................................................................................... 98 ..........................