Excel 2019 Power Programming with VBA. Michael Alexander

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

Introduction

      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.

Topics Covered

      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