Computer Based Training: Office 97, Windows 95 & NT Basics

home *** CD-ROM | disk | FTP | other *** search

/ Computer Based Training: …, Windows 95 & NT Basics / a1454501.iso / mo97w04 / PW01.CTL < prev next >

Wrap

Text File | 1997-05-14 | 40.0 KB | 1,452 lines

* Screen 1 1 15 ********************************* * Course: Word 97 for Power Users * Unit: Macros Unit No.:01 * Topic: Recording and running macros Topic No.: 1 **** eff.exe p01_101.gif 86 443 0 1 0 15 15 15 * If you have worked with Word b isave 4 456 253 388 text1 textbox 4 456 253 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_102a.gif 263 400 0 1 0 15 15 15 eff.exe p01_102b.gif 423 125 0 1 0 15 15 15 * Macros are used for automating isave 4 393 253 320 text2 growbox 4 393 253 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 4 393 image memory text1 0 4 456 * eff.exe p01_103a.gif 224 419 0 1 0 15 15 15 * In Word 97, macros are created isave 4 457 191 372 text1 textbox 4 457 191 372 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * Previous versions of Word crea notebox 5 343 250 ** eff.exe p01_105a.gif 86 443 0 1 0 15 15 15 * Visual Basic for Applications isave 4 377 191 270 text2 growbox 4 377 191 270 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_106a.gif 179 431 0 1 0 15 15 15 eff.exe p01_106b.gif 224 431 0 1 0 15 15 15 eff.exe p01_106c.gif 179 393 0 1 0 15 15 15 eff.exe p01_106d.gif 224 391 0 1 0 15 15 15 * It combines this programming l isave 4 275 191 185 text3 growbox 4 275 191 185 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 4 275 image memory text2 0 4 377 image memory text1 0 4 457 * eff.exe p01_107a.gif 86 443 0 1 0 15 15 15 * Macros in Word 97, which are n isave 5 455 230 353 text1 textbox 5 455 230 353 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_108a.gif 179 431 0 1 0 15 15 15 eff.exe p01_108b.gif 224 431 0 1 0 15 15 15 eff.exe p01_108c.gif 224 331 0 1 0 15 15 15 * You can create procedures usin isave 5 358 230 302 text2 growbox 5 358 230 302 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** qcall pw01q 010101 eff.exe p01_109a.gif 86 443 0 1 0 15 15 15 * You can edit or modify a macro isave 5 307 230 234 text3 growbox 5 307 230 234 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 307 image memory text2 0 5 358 image memory text1 0 5 455 * Simscrn 1 2 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_110.gif 0 459 0 1 0 15 15 15 * Vicky Jones wants to record a isave 301 380 634 295 text1 textbox 301 380 634 295 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_111a.gif 11 457 0 1 0 15 15 15 * To do this in Word she first o isave 301 300 634 244 text2 growbox 301 300 634 244 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_112a.gif 4 457 0 1 0 15 15 15 * And double-clicks the Blank Do isave 301 249 634 193 text3 growbox 301 249 634 193 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_113a.gif 2 456 0 1 0 15 15 15 eff.exe p01_113b.gif 2 432 0 1 0 15 15 15 * She does everything to this do isave 301 198 634 125 text4 growbox 301 198 634 125 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 301 198 image memory text3 0 301 249 image memory text2 0 301 300 image memory text1 0 301 380 * eff.exe p01_114a.gif 77 457 0 1 0 15 15 15 * Then she chooses Tools - Macro isave 377 448 635 397 text1 textbox 377 448 635 397 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_115a.gif 6 457 0 1 0 15 15 15 eff.exe p01_115b.gif 622 337 0 1 0 15 15 15 eff.exe p01_115c.gif 6 20 0 1 0 15 15 15 eff.exe p01_115d.gif 622 20 0 1 0 15 15 15 * The Record Macro dialog box op isave 377 402 635 363 text2 growbox 377 402 635 363 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 377 402 image memory text1 0 377 448 * eff.exe p01_116a.gif 9 425 0 1 0 15 15 15 eff.exe p01_116b.gif 9 20 0 1 0 15 15 15 * In the Macro Name area Vicky t isave 285 457 637 406 text1 textbox 285 457 637 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * When entering data in this are notebox 387 330 632 ** eff.exe p01_118a.gif 109 365 0 1 0 15 15 15 eff.exe p01_118b.gif 302 376 0 1 0 15 15 15 eff.exe p01_118c.gif 39 185 0 1 0 15 15 15 * In the Description field Vicky isave 285 411 637 355 text2 growbox 285 411 637 355 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * It is important to enter a cle notebox 387 331 632 ** image memory text2 0 285 411 image memory text1 0 285 457 * eff.exe p01_120a.gif 302 376 0 1 0 15 15 15 eff.exe p01_120b.gif 17 262 0 1 0 15 15 15 * You specify where you want to isave 407 454 632 386 text1 textbox 407 454 632 386 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_121a.gif 17 262 0 1 0 15 15 15 * Vicky selects All Documents isave 407 391 632 352 text2 growbox 407 391 632 352 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * The Store macro in drop-down l notebox 382 326 627 ** image memory text2 0 407 391 image memory text1 0 407 454 * eff.exe p01_124a.gif 17 353 0 1 0 15 15 15 eff.exe p01_124b.gif 359 225 0 1 0 15 15 15 * You can choose to assign your isave 388 441 625 373 text1 textbox 388 441 625 373 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_125a.gif 17 376 0 1 0 15 15 15 * Vicky wants to assign the macr isave 388 378 625 305 text2 growbox 388 378 625 305 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_126a.gif 10 409 0 1 0 15 15 15 * The Customize Keyboard dialog isave 388 310 625 220 text3 growbox 388 310 625 220 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 388 310 image memory text2 0 388 378 image memory text1 0 388 441 * eff.exe p01_127a.gif 10 401 0 1 0 15 15 15 * Vicky assigns the macro to the isave 411 406 635 355 text1 textbox 411 406 635 355 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can assign a macro to any notebox 148 435 398 ** qcall pw01q 010102 eff.exe p01_130a.gif 26 383 0 1 0 15 15 15 eff.exe p01_130b.gif 26 20 0 1 0 15 15 15 * Once you assign a macro to a k isave 411 360 635 253 text2 growbox 411 360 635 253 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_131a.gif 77 457 0 1 0 15 15 15 * But you can also access your m isave 411 258 635 185 text3 growbox 411 258 635 185 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 411 258 image memory text2 0 411 360 image memory text1 0 411 406 * Simscrn 1 3 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_132.gif 0 459 0 1 0 15 15 15 * Vicky clicks the Assig isave 337 457 636 406 text1 textbox 337 457 636 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_133a.gif 49 183 0 1 0 15 15 15 eff.exe p01_133b.gif 395 318 0 1 0 15 15 15 * Then she clicks the Close butt isave 337 411 636 372 text2 growbox 337 411 636 372 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_134a.gif 0 436 0 1 0 15 15 15 eff.exe p01_134b.gif 0 19 0 1 0 15 15 15 * And Word returns to the blank isave 337 377 636 338 text3 growbox 337 377 636 338 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 337 377 image memory text2 0 337 411 image memory text1 0 337 457 * eff.exe p01_135a.gif 364 455 0 1 0 15 15 15 * The Stop Recording button appe isave 33 327 296 259 text1 textbox 33 327 296 259 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * The Stop Recording button is a notebox 303 307 607 ** eff.exe p01_138a.gif 299 455 0 1 0 15 15 15 * The Macro Recorder is now read isave 33 264 296 208 text2 growbox 33 264 296 208 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_139a.gif 45 441 0 1 0 15 15 15 eff.exe p01_139b.gif 299 441 0 1 0 15 15 15 eff.exe p01_139c.gif 219 20 0 1 0 15 15 15 * Vicky tabs across the page and isave 33 213 296 140 text3 growbox 33 213 296 140 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 33 213 image memory text2 0 33 264 image memory text1 0 33 327 * qcall pw01q 010103 eff.exe p01_140a.gif 45 430 0 1 0 15 15 15 eff.exe p01_140b.gif 312 430 0 1 0 15 15 15 eff.exe p01_140c.gif 219 20 0 1 0 15 15 15 * It is possible to pause the Ma isave 32 326 256 258 text1 textbox 32 326 256 258 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_141a.gif 45 434 0 1 0 15 15 15 eff.exe p01_141b.gif 272 434 0 1 0 15 15 15 eff.exe p01_141c.gif 219 20 0 1 0 15 15 15 * Vicky, however, wants to stop isave 32 263 256 173 text2 growbox 32 263 256 173 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_142a.gif 0 436 0 1 0 15 15 15 eff.exe p01_142b.gif 0 19 0 1 0 15 15 15 * Vicky's macro has been success isave 32 178 256 122 text3 growbox 32 178 256 122 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 32 178 image memory text2 0 32 263 image memory text1 0 32 326 * Simscrn 1 4 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_143.gif 0 459 0 1 0 15 15 15 * Vicky now wants to run the mac isave 367 457 637 406 text1 textbox 367 457 637 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_144a.gif 85 426 0 1 0 15 15 15 eff.exe p01_144b.gif 33 403 0 1 0 15 15 15 eff.exe p01_144c.gif 85 403 0 1 0 15 15 15 * She closes the document she ha isave 367 411 637 355 text2 growbox 367 411 637 355 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_145a.gif 2 457 0 1 0 15 15 15 * Then she opens a new document isave 367 360 637 321 text3 growbox 367 360 637 321 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 367 360 image memory text2 0 367 411 image memory text1 0 367 457 * qcall pw01q 010104 eff.exe p01_146a.gif 2 457 0 1 0 15 15 15 * Vicky chooses Macro - Macros f isave 398 454 631 386 text1 textbox 398 454 631 386 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * Alternatively, if you have ass notebox 294 361 627 ** eff.exe p01_149a.gif 10 457 0 1 0 15 15 15 * The Macros dialog box opens wi isave 398 391 631 318 text2 growbox 398 391 631 318 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * If more than one macro has bee notebox 381 294 626 ** image memory text2 0 398 391 image memory text1 0 398 454 * eff.exe p01_151a.gif 11 431 0 1 0 15 15 15 * Vicky clicks the Run button isave 414 457 635 423 text1 textbox 414 457 635 423 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_152a.gif 10 427 0 1 0 15 15 15 eff.exe p01_152b.gif 10 20 0 1 0 15 15 15 * The result of running the Comp isave 414 428 635 355 text2 growbox 414 428 635 355 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 414 428 image memory text1 0 414 457 * * Topic: Hands-on: Creating a macro Topic No.: 2 **** Simscrn 1 5 15 ********************************* MoveCtrl 1 493 460 0 0 * Usually, when you open a datab isave 108 364 362 330 text1 textbox 108 364 362 330 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 * image memory text1 0 108 364 ** exercise 01 2 120 70 * task 1 0101 215 300 420 6 50 67 5 5 * pause 1 1 1 1 1 1 1 1 ** * Topic: Ways to run macros Topic No.: 3 **** * * Topic: Hands-on: Modifying a macro group Topic No.: 4 **** Simscrn 1 6 15 MoveCtrl 1 493 460 0 0 * Suppose you wish to use the ke isave 138 345 393 294 text1 textbox 138 345 393 294 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can do this by adding a ma image memory text1 0 138 345 * task 2 0102 317 300 320 2 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * * * Topic: Editing and modifying macros Topic No.: 3 **** Simscrn 1 7 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_301.gif 0 459 0 1 0 15 15 15 * Vicky Jones wants to edit the isave 418 458 635 390 text1 textbox 418 458 635 390 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_302a.gif 0 458 0 1 0 15 15 15 * She wants to use this address isave 418 395 635 271 text2 growbox 418 395 635 271 showtext 0 0 7 pause 1 1 1 1 1 1 1 1 ** * You can also edit a macro or p notebox 347 247 630 ** image memory text2 0 418 395 image memory text1 0 418 458 * eff.exe p01_304a.gif 0 459 0 1 0 15 15 15 * The macro/procedure appears on isave 408 456 631 388 text1 textbox 408 456 631 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * The default view of the Visual notebox 360 364 629 ** eff.exe p01_308a.gif 13 455 0 1 0 15 15 15 eff.exe p01_308b.gif 307 430 0 1 0 15 15 15 eff.exe p01_308c.gif 330 208 0 1 0 15 15 15 * Each step that Vicky executed isave 408 393 631 303 text2 growbox 408 393 631 303 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 408 393 image memory text1 0 408 456 * eff.exe p01_309a.gif 0 459 0 1 0 15 15 15 * Keywords are words or statemen isave 364 457 633 372 text1 textbox 364 457 633 372 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_310.gif 0 459 0 1 0 15 15 15 * They appear in blue on Simscrn isave 364 377 633 338 text2 growbox 364 377 633 338 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 364 377 image memory text1 0 364 457 * eff.exe p01_310a.gif 13 455 0 1 0 15 15 15 eff.exe p01_310b.gif 450 455 0 1 0 15 15 15 eff.exe p01_310c.gif 39 380 0 1 0 15 15 15 * Comments are explanatory text isave 400 456 635 388 text1 textbox 400 456 635 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_312.gif 0 459 0 1 0 15 15 15 * They appear in green on Simscrn isave 400 393 635 354 text2 growbox 400 393 635 354 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * To add comments to macros or p notebox 373 329 633 ** image memory text2 0 400 393 image memory text1 0 400 456 * eff.exe p01_312a.gif 0 459 0 1 0 15 15 15 * The individual steps in the pr isave 448 405 625 337 text1 textbox 448 405 625 337 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 448 405 * Simscrn 1 8 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_313.gif 0 459 0 1 0 15 15 15 * Vicky selects all the text bet isave 36 121 256 53 text1 textbox 36 121 256 53 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_314a.gif 0 459 0 1 0 15 15 15 * Then she chooses Copy from the isave 36 58 256 2 text2 growbox 36 58 256 2 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * She could also click the Copy notebox 9 249 254 ** image memory text2 0 36 58 image memory text1 0 36 121 * eff.exe p01_317a.gif 0 459 0 1 0 15 15 15 * From the Insert menu, Vicky ch isave 420 408 619 357 text1 textbox 420 408 619 357 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_318a.gif 0 458 0 1 0 15 15 15 * The Add Procedure dialog box i isave 420 362 619 306 text2 growbox 420 362 619 306 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_319a.gif 11 455 0 1 0 15 15 15 eff.exe p01_319b.gif 11 431 0 1 0 15 15 15 eff.exe p01_319c.gif 450 431 0 1 0 15 15 15 * Vicky types Letter in the Name isave 420 311 619 255 text3 growbox 420 311 619 255 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 420 311 image memory text2 0 420 362 image memory text1 0 420 408 * eff.exe p01_320a.gif 0 459 0 1 0 15 15 15 * New procedure Sub and End Sub isave 397 378 617 327 text1 textbox 397 378 617 327 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** footnote 1 eff.exe p01_321a.gif 13 455 0 1 0 15 15 15 eff.exe p01_321b.gif 450 455 0 1 0 15 15 15 eff.exe p01_321c.gif 37 118 0 1 0 15 15 15 * First Vicky has to paste in th isave 397 332 617 242 text2 growbox 397 332 617 242 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** footnote 0 image memory text2 0 397 332 image memory text1 0 397 378 * eff.exe p01_400.gif 0 459 0 1 0 15 15 15 qcall pw01q 010301 eff.exe p01_322a.gif 13 455 0 1 0 15 15 15 eff.exe p01_322b.gif 450 455 0 1 0 15 15 15 eff.exe p01_322c.gif 37 118 0 1 0 15 15 15 * Vicky clicks the Paste button isave 253 378 476 344 text1 textbox 253 378 476 344 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_323a.gif 13 455 0 1 0 15 15 15 * The steps of the original macr isave 253 349 476 259 text2 growbox 253 349 476 259 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 253 349 image memory text1 0 253 378 * Simscrn 1 9 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_324.gif 0 459 0 1 0 15 15 15 * Vicky changes the comments in isave 6 380 295 312 text1 textbox 6 380 295 312 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_325a.gif 13 455 0 1 0 15 15 15 eff.exe p01_325b.gif 200 455 0 1 0 15 15 15 eff.exe p01_325c.gif 12 278 0 1 0 15 15 15 eff.exe p01_325d.gif 285 220 0 1 0 15 15 15 * As comments are used to descri isave 6 317 295 244 text2 growbox 6 317 295 244 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 6 317 image memory text1 0 6 380 * eff.exe p01_326a.gif 13 455 0 1 0 15 15 15 eff.exe p01_326b.gif 12 342 0 1 0 15 15 15 * Then she moves the insertion p isave 8 450 263 382 text1 textbox 8 450 263 382 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_327a.gif 13 455 0 1 0 15 15 15 eff.exe p01_327b.gif 37 326 0 1 0 15 15 15 eff.exe p01_327c.gif 620 240 0 1 0 15 15 15 * And presses Enter to move to a isave 8 387 263 331 text2 growbox 8 387 263 331 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 8 387 image memory text1 0 8 450 * eff.exe p01_328a.gif 13 455 0 1 0 15 15 15 eff.exe p01_328b.gif 450 455 0 1 0 15 15 15 eff.exe p01_328c.gif 37 326 0 1 0 15 15 15 * She wants to insert some blank isave 11 456 288 388 text1 textbox 11 456 288 388 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_329a.gif 13 455 0 1 0 15 15 15 eff.exe p01_329b.gif 200 455 0 1 0 15 15 15 eff.exe p01_329c.gif 37 326 0 1 0 15 15 15 eff.exe p01_329d.gif 239 205 0 1 0 15 15 15 * In VB code, pressing Enter is isave 11 393 288 303 text2 growbox 11 393 288 303 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_330.gif 0 459 0 1 0 15 15 15 * "Selection.TypeParagraph" *isave 11 342 288 303 text3 *growbox 11 342 288 303 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** eff.exe p01_330a.gif 13 455 0 1 0 15 15 15 eff.exe p01_330b.gif 25 374 0 1 0 15 15 15 * So Vicky types this line four isave 11 308 288 252 text3 growbox 11 308 288 252 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * When you are typing new lines notebox 295 437 583 ** image memory text3 0 11 308 image memory text2 0 11 393 image memory text1 0 11 456 * eff.exe p01_333a.gif 13 455 0 1 0 15 15 15 eff.exe p01_333b.gif 37 431 0 1 0 15 15 15 eff.exe p01_333c.gif 37 115 0 1 0 15 15 15 * Vicky wants her new letter mac isave 5 445 267 360 text1 textbox 5 445 267 360 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_334a.gif 13 455 0 1 0 15 15 15 eff.exe p01_334b.gif 25 374 0 1 0 15 15 15 * First she types the lin isave 5 365 267 292 text2 growbox 5 365 267 292 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_335.gif 0 459 0 1 0 15 15 15 * Selection.TypeText Text:="Dear *isave 5 331 267 292 text3 *growbox 5 331 267 292 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 365 image memory text1 0 5 445 * eff.exe p01_335a.gif 13 455 0 1 0 15 15 15 eff.exe p01_335b.gif 245 430 0 1 0 15 15 15 eff.exe p01_335c.gif 37 75 0 1 0 15 15 15 eff.exe p01_335d.gif 310 148 0 1 0 15 15 15 * Vicky is going to insert an In isave 9 452 271 367 text1 textbox 9 452 271 367 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * An InputBox prompts the user f notebox 9 342 254 ** MoveCtrl 1 0 460 0 0 eff.exe p01_337a.gif 13 455 0 1 0 15 15 15 eff.exe p01_337b.gif 37 455 0 1 0 15 15 15 eff.exe p01_337c.gif 37 374 0 1 0 15 15 15 * On a new blank line, she type isave 9 372 271 299 text2 growbox 9 372 271 299 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_337.gif 0 459 0 1 0 15 15 15 * Selection.TypeText Text:=Input *isave 5 445 180 335 text3 *growbox 5 445 180 335 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** eff.exe p01_338a.gif 13 455 0 1 0 15 15 15 eff.exe p01_338b.gif 37 431 0 1 0 15 15 15 eff.exe p01_338c.gif 37 148 0 1 0 15 15 15 * A list of the format of an Inp isave 9 304 271 248 text3 growbox 9 304 271 248 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 9 304 image memory text2 0 9 372 image memory text1 0 9 452 * eff.exe p01_339a.gif 13 455 0 1 0 15 15 15 eff.exe p01_339b.gif 37 431 0 1 0 15 15 15 eff.exe p01_339c.gif 37 127 0 1 0 15 15 15 * The Prompt part of the argumen isave 5 454 404 403 text1 textbox 5 454 404 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_340a.gif 13 455 0 1 0 15 15 15 eff.exe p01_340b.gif 37 431 0 1 0 15 15 15 eff.exe p01_340c.gif 37 150 0 1 0 15 15 15 * Vicky type isave 5 408 404 335 text2 growbox 5 408 404 335 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_342.gif 0 459 0 1 0 15 15 15 * "Please type recipient name fo *isave 12 338 256 282 text3 *growbox 12 338 256 282 *showtext 0 0 3 *pause 1 1 1 1 1 1 1 1 ** MoveCtrl 1 493 460 0 0 eff.exe p01_341a.gif 13 455 0 1 0 15 15 15 eff.exe p01_341b.gif 37 455 0 1 0 15 15 15 eff.exe p01_341c.gif 37 374 0 1 0 15 15 15 * Then she inserts another blank isave 5 340 404 284 text3 growbox 5 340 404 284 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 340 image memory text2 0 5 408 image memory text1 0 5 454 * qcall pw01q 010302 eff.exe p01_342a.gif 13 457 0 1 0 15 15 15 eff.exe p01_342b.gif 37 374 0 1 0 15 15 15 * To insert eight blank lines, V isave 7 406 300 321 text1 textbox 7 406 300 321 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_345.gif 0 459 0 1 0 15 15 15 * Selection.TypeParagrap *isave 5 399 299 360 text2 *growbox 5 399 299 360 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** * To save time, she could use th notebox 8 294 253 ** eff.exe p01_344a.gif 15 457 0 1 0 15 15 15 eff.exe p01_344b.gif 69 434 0 1 0 15 15 15 eff.exe p01_344c.gif 15 214 0 1 0 15 15 15 eff.exe p01_344d.gif 69 214 0 1 0 15 15 15 * To insert the words at the end isave 7 326 300 236 text2 growbox 7 326 300 236 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_348.gif 0 459 0 1 0 15 15 15 * Selection.TypeText Text:="Your *isave 5 314 299 275 text3 *growbox 5 314 299 275 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** image memory text2 0 7 326 image memory text1 0 7 406 * eff.exe p01_345a.gif 13 455 0 1 0 15 15 15 eff.exe p01_345b.gif 524 358 0 1 0 15 15 15 eff.exe p01_345c.gif 30 246 0 1 0 15 15 15 eff.exe p01_345d.gif 525 230 0 1 0 15 15 15 * She enters a blank line by typ isave 5 406 248 338 text1 textbox 5 406 248 338 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_346.gif 0 459 0 1 0 15 15 15 * Selection.TypeParagrap *isave 5 445 180 335 text2 *growbox 5 445 180 335 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** eff.exe p01_346a.gif 15 455 0 1 0 15 15 15 eff.exe p01_346b.gif 450 455 0 1 0 15 15 15 eff.exe p01_346c.gif 30 161 0 1 0 15 15 15 * And copies and pastes this lin isave 5 343 248 287 text2 growbox 5 343 248 287 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 343 image memory text1 0 5 406 * eff.exe p01_347a.gif 0 459 0 1 0 15 15 15 * Vicky wants to insert another isave 6 405 242 320 text1 textbox 6 405 242 320 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 6 405 * qcall pw01q 010303 MoveCtrl 1 493 330 0 0 eff.exe p01_349a.gif 0 459 0 1 0 15 15 15 * She can have as many InputBoxe isave 5 409 472 324 text1 textbox 5 409 472 324 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_354.gif 0 459 0 1 0 15 15 15 * Selection.TypeText Text:=Input *isave 5 445 180 335 text2 *growbox 5 445 180 335 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** image memory text1 0 5 409 * eff.exe p01_350a.gif 13 455 0 1 0 15 15 15 eff.exe p01_350b.gif 150 455 0 1 0 15 15 15 eff.exe p01_350c.gif 0 148 0 1 0 15 15 15 eff.exe p01_350d.gif 150 148 0 1 0 15 15 15 * Vicky also wants a message box isave 7 454 368 403 text1 textbox 7 454 368 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_351a.gif 13 455 0 1 0 15 15 15 eff.exe p01_351b.gif 150 455 0 1 0 15 15 15 eff.exe p01_351c.gif 2 118 0 1 0 15 15 15 eff.exe p01_351d.gif 150 118 0 1 0 15 15 15 * A message box allows you to di isave 7 408 368 335 text2 growbox 7 408 368 335 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** MoveCtrl 1 493 460 0 0 eff.exe p01_352a.gif 13 455 0 1 0 15 15 15 eff.exe p01_352b.gif 69 430 0 1 0 15 15 15 eff.exe p01_352c.gif 13 173 0 1 0 15 15 15 eff.exe p01_352d.gif 69 173 0 1 0 15 15 15 * Vicky type isave 7 340 368 267 text3 growbox 7 340 368 267 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** *eff.exe p01_353.gif 0 459 0 1 0 15 15 15 * MsgBox "You may now type the t *isave 5 445 180 335 text4 *growbox 5 445 180 335 *showtext 0 0 2 *pause 1 1 1 1 1 1 1 1 ** image memory text3 0 7 340 image memory text2 0 7 408 image memory text1 0 7 454 * Simscrn 1 10 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_353.gif 0 459 0 1 0 15 15 15 * Vicky is now going to delete t isave 19 302 241 234 text1 textbox 19 302 241 234 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_354a.gif 13 455 0 1 0 15 15 15 eff.exe p01_354b.gif 152 457 0 1 0 15 15 15 * To do this she chooses Macros isave 19 239 241 183 text2 growbox 19 239 241 183 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_355a.gif 0 459 0 1 0 15 15 15 * The Macros dialog box opens isave 19 188 241 149 text3 growbox 19 188 241 149 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_356a.gif 1 456 0 1 0 15 15 15 eff.exe p01_356b.gif 1 431 0 1 0 15 15 15 * With the CompanyAddress macro isave 19 154 241 81 text4 growbox 19 154 241 81 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** * If you are not in Visual Basic notebox 20 432 344 ** image memory text4 0 19 154 image memory text3 0 19 188 image memory text2 0 19 239 image memory text1 0 19 302 * eff.exe p01_358a.gif 0 459 0 1 0 15 15 15 * Vicky clicks the Save button o isave 9 270 247 185 text1 textbox 9 270 247 185 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_359a.gif 0 459 0 1 0 15 15 15 * Then she closes the Visual Bas isave 9 190 247 100 text2 growbox 9 190 247 100 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 9 190 image memory text1 0 9 270 * eff.exe p01_360a.gif 0 459 0 1 0 15 15 15 * Vicky wants to run her Letter isave 431 458 636 339 text1 textbox 431 458 636 339 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_361a.gif 0 459 0 1 0 15 15 15 * The Macros dialog box opens wi isave 431 344 636 254 text2 growbox 431 344 636 254 showtext 0 0 5 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 431 344 image memory text1 0 431 458 * eff.exe p01_362a.gif 0 459 0 1 0 15 15 15 * The CTI address in Boston, the isave 405 459 638 374 text1 textbox 405 459 638 374 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_363a.gif 0 459 0 1 0 15 15 15 * Vicky types Mr Lee, into the I isave 405 379 638 323 text2 growbox 405 379 638 323 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_364a.gif 0 459 0 1 0 15 15 15 * "Mr Lee" is inserted after the isave 405 328 638 221 text3 growbox 405 328 638 221 showtext 0 0 6 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 405 328 image memory text2 0 405 379 image memory text1 0 405 459 * eff.exe p01_365a.gif 24 380 0 1 0 15 15 15 * Vicky types her name in the In isave 376 457 637 406 text1 textbox 376 457 637 406 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_366a.gif 0 459 0 1 0 15 15 15 * Her name is inserted and a mes isave 376 411 637 338 text2 growbox 376 411 637 338 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_367a.gif 0 459 0 1 0 15 15 15 * She clicks OK isave 376 343 637 304 text3 growbox 376 343 637 304 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_368a.gif 0 459 0 1 0 15 15 15 * As she was only checking her m isave 376 309 637 236 text4 growbox 376 309 637 236 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 376 309 image memory text3 0 376 343 image memory text2 0 376 411 image memory text1 0 376 457 * qcall pw01q 010304 eff.exe p01_369a.gif 0 459 0 1 0 15 15 15 * Vicky could have clicked the C isave 32 192 248 107 text1 textbox 32 192 248 107 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 32 192 * Simscrn 1 11 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_370.gif 0 459 0 1 0 15 15 15 * You can use macros to create t isave 5 230 294 196 text1 textbox 5 230 294 196 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_371a.gif 0 459 0 1 0 15 15 15 * Vicky wants to use the Letter isave 5 201 294 128 text2 growbox 5 201 294 128 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_372a.gif 0 459 0 1 0 15 15 15 * From the File menu, Vicky choo isave 5 133 294 94 text3 growbox 5 133 294 94 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_373a.gif 0 459 0 1 0 15 15 15 * The New dialog box opens and s isave 5 99 294 26 text4 growbox 5 99 294 26 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 5 99 image memory text3 0 5 133 image memory text2 0 5 201 image memory text1 0 5 230 * eff.exe p01_374a.gif 13 453 0 1 0 15 15 15 eff.exe p01_374b.gif 363 453 0 1 0 15 15 15 eff.exe p01_374c.gif 49 371 0 1 0 15 15 15 eff.exe p01_374d.gif 363 261 0 1 0 15 15 15 * Vicky double-clicks the Blank isave 20 202 264 151 text1 textbox 20 202 264 151 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_375a.gif 0 459 0 1 0 15 15 15 * A new blank document is opened isave 20 156 264 117 text2 growbox 20 156 264 117 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 20 156 image memory text1 0 20 202 * eff.exe p01_376a.gif 0 459 0 1 0 15 15 15 * Vicky chooses File from the In isave 266 244 539 176 text1 textbox 266 244 539 176 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_377a.gif 0 459 0 1 0 15 15 15 * The Insert File dialog box ope isave 266 181 539 108 text2 growbox 266 181 539 108 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 266 181 image memory text1 0 266 244 eff.exe p01_378a.gif 0 459 0 1 0 15 15 15 * The CTI logo appears in the do isave 49 138 322 70 text1 textbox 49 138 322 70 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 49 138 * qcall pw01q 010305 eff.exe p01_379a.gif 0 459 0 1 0 15 15 15 * Vicky chooses Print Preview fr isave 364 307 634 256 text1 textbox 364 307 634 256 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_380a.gif 0 459 0 1 0 15 15 15 * Vicky is satisfied with the po isave 364 261 634 188 text2 growbox 364 261 634 188 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 364 261 image memory text1 0 364 307 * Simscrn 1 12 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_381.gif 0 459 0 1 0 15 15 15 * Vicky now wants to run her Let isave 6 316 260 248 text1 textbox 6 316 260 248 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 6 316 * eff.exe p01a381a.gif 0 459 0 1 0 15 15 15 qcall pw01q 010306 eff.exe p01_382a.gif 0 459 0 1 0 15 15 15 * The Macros dialog box opens an isave 22 239 266 171 text1 textbox 22 239 266 171 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text1 0 22 239 * eff.exe p01_383a.gif 0 459 0 1 0 15 15 15 * The first InputBox in the Lett isave 168 176 451 108 text1 textbox 168 176 451 108 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_384a.gif 0 459 0 1 0 15 15 15 * She doesn't insert a name beca isave 168 113 451 40 text2 growbox 168 113 451 40 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 168 113 image memory text1 0 168 176 * eff.exe p01_385a.gif 0 453 0 1 0 15 15 15 eff.exe p01_385b.gif 0 434 0 1 0 15 15 15 * She does the same thing when t isave 5 455 279 370 text1 textbox 5 455 279 370 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_386a.gif 0 459 0 1 0 15 15 15 * And clicks OK when the message isave 5 375 279 319 text2 growbox 5 375 279 319 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 5 375 image memory text1 0 5 455 * eff.exe p01_387a.gif 13 457 0 1 0 15 15 15 eff.exe p01_387b.gif 577 430 0 1 0 15 15 15 * Vicky chooses Save from the Fi isave 348 456 635 422 text1 textbox 348 456 635 422 showtext 0 0 1 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_388a.gif 0 459 0 1 0 15 15 15 * The Save As dialog box opens w isave 348 427 635 371 text2 growbox 348 427 635 371 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 348 427 image memory text1 0 348 456 * eff.exe p01_389a.gif 0 459 0 1 0 15 15 15 * In the File name field, Vicky isave 389 219 596 168 text1 textbox 389 219 596 168 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_390a.gif 0 459 0 1 0 15 15 15 * And clicks the Save button isave 389 173 596 134 text2 growbox 389 173 596 134 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text2 0 389 173 image memory text1 0 389 219 * Simscrn 1 13 15 ********************************* MoveCtrl 1 493 460 0 0 eff.exe p01_391.gif 0 459 0 1 0 15 15 15 * Vicky closes the document she isave 5 156 307 105 text1 textbox 5 156 307 105 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_392a.gif 0 459 0 1 0 15 15 15 * Then she chooses New from the isave 5 110 307 71 text2 growbox 5 110 307 71 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_393a.gif 0 459 0 1 0 15 15 15 * The Boston Letter template she isave 5 76 307 3 text3 growbox 5 76 307 3 showtext 0 0 4 pause 1 1 1 1 1 1 1 1 ** image memory text3 0 5 76 image memory text2 0 5 110 image memory text1 0 5 156 * qcall pw01q 010307 eff.exe p01_394a.gif 0 459 0 1 0 15 15 15 * Vicky could move this template isave 41 184 316 133 text1 textbox 41 184 316 133 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can move a template to ano notebox 43 365 288 ** image memory text1 0 41 184 * eff.exe p01_396a.gif 48 373 0 1 0 15 15 15 eff.exe p01_396b.gif 621 430 0 1 0 15 15 15 eff.exe p01_396c.gif 48 109 0 1 0 15 15 15 eff.exe p01_396d.gif 621 109 0 1 0 15 15 15 * Vicky double-clicks the Boston isave 382 454 636 403 text1 textbox 382 454 636 403 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_397a.gif 0 459 0 1 0 15 15 15 * And a new document opens with isave 382 408 636 352 text2 growbox 382 408 636 352 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_398a.gif 13 457 0 1 0 15 15 15 eff.exe p01_398b.gif 577 430 0 1 0 15 15 15 * She chooses Print Preview from isave 382 357 636 301 text3 growbox 382 357 636 301 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** eff.exe p01_399a.gif 0 459 0 1 0 15 15 15 * The logo has been inserted as isave 382 306 636 267 text4 growbox 382 306 636 267 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** image memory text4 0 382 306 image memory text3 0 382 357 image memory text2 0 382 408 image memory text1 0 382 454 * * Topic: Hands-on: Modifying a macro Topic No.: 4 **** Simscrn 1 14 15 ********************************* MoveCtrl 1 493 460 0 0 * isave 123 347 439 296 text1 textbox 123 347 439 296 showtext 0 0 2 pause 1 1 1 1 1 1 1 1 ** * You can do this by adding a ma image memory text1 0 123 347 * * exercise 02 2 120 70 * task 3 0103 317 71 320 6 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * Simscrn 1 15 15 MoveCtrl 1 493 460 0 0 * task 4 0104 317 300 320 4 50 67 5 5 * pause 1 1 1 1 1 1 1 1 * isave 177 226 454 158 text1 textbox 177 226 454 158 showtext 0 0 3 pause 1 1 1 1 1 1 1 1 ** * You can do this by adding a image memory text1 0 177 226 *