资源描述：
《excel的宏应用知识入门（introduction to macro application knowledge of excel）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、excel的宏应用知识入门（IntroductiontomacroapplicationknowledgeofExcel）Excelmacroknowledgeentry-novicemustseeMicrosoftexcelisaverypowerfulspreadsheetsoftware.Itcaneasilycompleteallkindsofmathematicaloperationsofdataandrepresenttheminvarioustwo-dimensionalorthree-dimensionalg
2、raphics,thusgreatlysimplifyingtheprocessingofdata.However,ifonlythecommonfunctionsofExcelareusedtoprocessmorecomplexdata,alargeamountofmanualoperationmaystillbenecessary.ButthepowerofExcelisfarmorethanpeopleimagine-theintroductionofmacrosmakesitinfinitelyextensible
3、,soitcansolvethecomplexdataprocessingproblemverywell.WiththeincreasingnumberofapplicationssupportingWindowsandthecontinuousenhancementoffunctions,moreandmoreprogramsaddmacroprocessingtofacilitatethefreeexpansionofusers.Butthemacrolanguageusedinearlyapplicationsisno
4、tuniform,sousersmustrelearnamacrolanguageeverytimetheyuseanapplication.Inordertounifymacrosundervariousapplications,MicrosoftintroducedtheVBA(VisualBasicforApplications)language.VBAisanapplicationorientedlanguagederivedfromthepopularVisualBasicprogramminglanguage,w
5、hichappliestoavarietyofWindowsapplications,andcansolvetheproblemofinconsistencyofmacrolanguageineachapplication.Inaddition,theuseofVBAlanguagehasthefollowingadvantages:1,VBAisageneral-purposeprogramminglanguage,throughwhichnotonlycanshareMicrosoftrelatedsoftware(su
6、chasExcel,word,access)......But,alongwithsomeothersoftware(suchasthefamousAutoCAD2000)onthesupportofVBA,thesoftwarealsohasenteredintothecontrolrangeofVBA;2,canbeusedtocopytheVBAprogramtoVisualBasicdebuggingandrunning,whichisrealizedbyVisualBasictocontroltherelevant
7、applications;3,VBAprovidealargenumberofinternalfunctionsgreatlysimplifytheoperationoftheuser.Fortoday'smacro,notonlythelanguageofunifiedspecifications,butalsoitsfunctionisverypowerful.Butinmostexcelintroduced"Dummies"and"guide","entryandimprovement"andotherreferenc
8、ebooksoftenskip,orovershallow,theknowledgegainedfromreadersarenotenoughtocopewiththecomplexdataprocessingneeds.Inordertocompletethework,letuswork
