453 449
454 450
455 451
456 452
457 453
458 454
459 455
460 456
461 457
462 458
463 459
464 460
465 461
466 462
467 463
468 464
469 465
470 466
471 467
472 468
473 469
474 470
475 471
476 472
477 473
478 474
479 475
480 476
481 477
482 478
483 479
484 480
485 481
486 482
487 483
488 484
489 485
490 486
491 487
492 488
493 489
494 490
495 491
496 492
497 493
498 494
499 495
500 496
501 497
502 498
503 499
504 500
505 501
506 502
507 503
508 504
509 505
510 506
511 507
512 508
513 509
514 510
515 511
516 512
517 513
518 514
519 515
520 516
521 517
522 518
523 519
524 520
525 521
526 522
527 523
528 524
529 525
530 526
531 527
532 528
533 529
534 530
535 531
536 532
537 533
538 534
539 535
540 536
541 537
542 538
543 539
544 540
545 541
546 542
547 543
548 544
549 545
550 546
551 547
552 548
553 549
554 550
555 551
556 552
557 553
558 554
559 555
560 556
561 557
562 558
563 559
564 560
565 561
566 562
567 563
568 564
569 565
570 566
571 567
572 569
573 570
574 571
575 572
576 573
577 574
578 575
579 576
580 577
581 578
582 579
583 580
584 581
585 582
586 583
587 584
588 585
589 586
590 587
591 588
592 589
593 590
594 591
595 592
596 593
597 594
598 595
599 596
600 597
601 599
602 600
603 601
604 602
605 603
606 604
607 605
608 606
609 607
610 608
611 609
612 610
613 611
614 612
615 613
616 614
617 615
618 616
619 617
620 618
621 619
622 620
623 621
624 622
625 623
626 624
627 625
628 626
629 627
630 628
631 629
632 630
633 631
634 632
635 633
636 634
637 635
638 637
639 638
640 639
641 640
642 641
643 642
644 643
645 644
646 645
647 646
648 647
649 648
650 649
651 650
652 651
653 652
654 653
655 654
656 655
657 656
658 657
659 659
660 660
661 661
662 662
663 663
664 664
665 665
666 666
667 667
668 668
669 669
670 670
671 671
672 672
673 673
674 674
675 675
676 676
677 677
678 678
679 679
680 680
681 681
682 682
683 683
684 684
685 685
686 686
687 687
688 688
689 689
690 690
691 691
692 692
693 693
694 694
695 695
696 696
697 697
698 698
699 699
700 700
701 701
702 702
703 703
704 704
705 705
706 706
707 707
708 708
709 709
710 710
711 711
712 713
713 715
714 716
715 717
716 718
717 719
718 720
719 721
720 722
721 723
722 725
723 726
724 727
725 728
726 729
727 730
728 731
729 732
730 733
731 734
732 735
733 736
734 737
735 738
736 739
737 740
738 741
739 742
Excel® 2019 Power Programming with VBA
Michael Alexander
Dick Kusleika
Previously by John Walkenbach

For most of us, the path to Excel VBA programming starts with the need to perform some task that can't be done with the standard tools in Excel. That task is different for each of us. Maybe that task is to create separate workbooks automatically for all the rows in a data set. Maybe that task is to automate the emailing of dozens of reports. Whatever that task is for you, you can bet that someone has started their own journey into Excel VBA with the same need.
The beautiful thing about Excel VBA is that you don't have to be an expert to start solving problems with it. You can learn just enough to solve a particular problem, or you can go further and discover ways to handle all kinds of automation scenarios.
Whatever your goals may be, Excel 2019 Power Programming with VBA will help you harness the power of the VBA language to automate tasks, work smarter, and be more productive.
This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it shows you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.
You can approach this book in any way you please. You can read it from cover to cover, or you can skip around, picking up useful tidbits here and there. VBA programming is often a task-oriented endeavor. So, if you're faced with a challenging task, you might try the index first to see where the book might specifically address your problem.
This book does not cover Microsoft Visual Studio Tools for Office (VSTO), a technology that uses Visual Basic .NET and Microsoft Visual C#. VSTO can also be used to control Excel and other Microsoft Office applications.
As you may know, Excel 2019 is available for other platforms. For example, you can use Microsoft's Excel Web App in your browser and even iPads and tablets. These versions do not support VBA. In other words, this book is for the desktop version of Excel 2019 for Windows.
This is not a book for beginning Excel users. If you have no experience with Excel, a better choice might be the Excel 2019 Bible (Wiley, 2018), which provides comprehensive coverage of all the features of Excel and is meant for users of all levels.
To get the most out of this book, you should be a relatively experienced Excel user who knows how to do the following:
Create workbooks, insert sheets, save files, and so on
Navigate through a workbook
Use the Excel Ribbon user interface
Enter formulas
Use Excel's worksheet functions
Name cells and ranges
Use basic Windows features, such as file management techniques and the Clipboard
Excel is available in several versions, including a web version and a version for tablets and phones. This book was written exclusively for the desktop version of Microsoft Excel 2019 for Windows. If you plan to develop applications that will be used in earlier versions of Excel, we strongly suggest you use the earliest version of Excel that your target audience will be using. Over the last few years, Microsoft has adopted an agile release cycle for the web version of Excel with Office 365, generating release updates practically on a monthly basis.
Читать дальше