VBA Automation for Excel 2019 Cookbook
VisualBasicforApplications(VBA)isaprogramminglanguagedevelopedbyMicrosofttoautomatetasksinMSOfficeapplications.ThisbookwillhelpyoutofocusontheessentialaspectsofyourrolebyautomatingmundanetasksinExcelandotherOfficeapplications.WithcomprehensivecoverageofVBAdeliveredintheformofpracticeproblemsandbite-sizedrecipes,thisbookwillhelpyoutohitthegroundrunning.Unlikemostbooksthatassumepriorprogrammingexperience,thisbookstartswiththefundamentalsandgraduallyprogressestosolvingbiggerproblems.You’llstartbybecomingfamiliarwithVBAsothatyoucanstartrecordingmacrosrightaway.Withthisfoundationinplace,you’lladvancetousingthefullcapabilitiesofthelanguageasyouapplyloops,functions,andcustomdialogboxestodesignyourownautomationprograms.You'llalsogettogripswithembeddedmacrosandotheradvancedtoolstoenhanceproductivityandexploretopicsrelatingtoappperformanceandsecurity.ThroughoutthisVBAbook,you’llcovermultiplepracticeprojectsinExcel,Word,andPowerPointwhileexploringtipsandbestpracticestohoneyourskills.Bytheendofthisbook,you’llhavedevelopedtheskillsyouneedtouseVBAtocreateyourownprogramsthatcontrolMSOfficeapplications.
·5.8萬字