Iyi tutori inoshandisa kushandisa macro recorder kuti iite macro nyore mu Excel . The macro recorder inoshanda nekunyora zvose zvinyorwa uye kuongororwa kwemushonga. Izvo zvakasikwa mumudzidzisi uyu zvinoshandisa maitiro akawanda ekufambisa kune musoro webasa .
MuEccel 2007 uye 2010, mirairo yose yakabatana-machirwe iri paMusununguri tabu rebhoni . Kazhinji, tabu iyi inofanira kuwedzerwa kubhoni kuitira kuti iwane mirairo macro. Nyaya dzakapoteredzwa nedzidziso iyi dzinosanganisira:
- Kuwedzera Mubhiririri Tab
- Kutanga Excel macro recorder
- Excel macro recorder zvingasarudzwa
- Kunyora macro
- Running the macro
- Maitiro macro / Kugadzira macro
01 of 06
Kuwedzera Mubhiririri Tab
- Dzvanya paDhiyabhorosi tab yebhoni kuti uzarure imenyu yefaira.
- Dzvanya pane Zvimwe zviri mu menu kuti uzarure Excel Options dialog box .
- Dzvanya paChirongwa cheRibbon muwindo rekumanzere kuti uone zviripo zviripo muwindo rekarurama rebhokisi rebhokisi.
- Pasi pechikamu chikuru cheTabs chezviisarudzo, hwindo rinotarisa musarudzo yeChina .
- Dzvanya OK.
- Mubatsiri weTebhu anofanira kunge zvino kuonekwa mubhandi muExcel 2010.
Kuwedzera Mudhidziriri weTabvu muExcel 2007
- MuExcel 2007, pfuurira pane bhodhi yeHofse kuti uzarure mhinduro inodonha.
- Dzvanya paIndec Options Options iri pasi pe menu kuti uzarure Excel Options dialog box.
- Dzvanya paIndaneti yakasarudzwa kumusoro kwewindo reboshwe rebhokisi rebhokisi rebhokisi.
- Dzvanya paGoogle Developer Tab mumubhoni iri kurudyi rwewindo rebhokisi rebhokisi rebhokisi.
- Dzvanya OK.
- Mubatsiri weTebhu anofanira kunge zvino kuonekwa mubhoni.
02 of 06
Kuwedzera Pepa Rokushanda Cheti / The Excel Macro Recorder
Tisati tatanga kutora zvinyorwa zvedu, tinoda kuwedzera musoro webasa rekuti tichave nekugadzirisa.
Sezvo musoro wechikoro chimwe nechimwe kazhinji chichienzaniswa nepeji yebasa iroro, hatidi kubatanidza musoro mune macro. Nokudaro tichawedzera kuri pepa rekushanda, tisati watanga macro recorder.
- Dzvanya pane sero A1 mubasa rekushanda.
- Tora zita racho: Cookie Shop Expenses yaJune 2008 .
- Dhinda pikicha inopinda mubhokisi.
Excel Macro Recorder
Nzira iri nyore yekuumba macro mu Excel ndeyokushandisa macro recorder. Kuita izvi:
- Dzvanya paVatadziri tab.
- Dzvanya paRekodi Macro mubhoni kuitira kuti uzarure Record Macro dialog box.
03 of 06
The Macro Recorder Options
Pane zvingasarudzwa 4 kuti upedze mubhokisi rebhokisi:
- Zita macro - ipa yako macro zita rinotsanangura. Zita racho rinofanira kutanga netsamba uye nzvimbo dzisingabvumirwi. Tsamba chete, nhamba uye mutsara unoremekedzwa zvinobvumidzwa.
- Shortcut key - (zvisarudzo) zadzai tsamba, nhamba, kana zvimwe zvinyorwa munzvimbo iripo. Izvi zvinokubvumira kuti utange macro nekuchengeta pasi CTRL key uye kuomesa tsamba yakasarudzwa pane keyboard.
- Chengetedza macro mukati
- Sarudzo:
- Bhuku rebhuku
- Iko macro inowanikwa chete mune iyi faira.
- Bhuku rekushanda
- Iyi sarudzo inotanga itsva Excel file. Iyo macro inowanikwa chete mune iyi faira.
- Bhuku rebasa guru rebhuku.
- Iyi sarudzo inogadzira faira yakavanzika Personal.xls iyo inochengetedza macros yako uye inoita kuti iwanikwe kwauri mune dzose maFiles mafaira.
- Tsanangudzo - (optional) funga tsanangudzo ye macro.
Pamusoro peTetorial
- Isa zvingasarudzwa muRekodi Macro dialog box kuti ufanane nevaya vari mumufananidzo uri pamusoro.
- Usatora OK - asi - ona pasi apa.
- Kushandura bhokisi rakanaka muRekodi Macro rebhokisi rinotanga kurekora macro yawakangotarisa.
- Sezvambotaurwa, macro recorder inoshanda nekunyora zvose zvinyorwa uye kuongororwa kwemushonga.
- Kuumba ma format_titles macro kunosanganisira kubata pane zvingasarudzwa zvemafaira pamba rebhubhoni neine mouse apo macro recorder iri kushanda.
- Enda kune danho rinotevera usati watanga macro recorder.
04 of 06
Kunyora macro Steps
- Dzvanya bhora rakanaka kuDecrosoft Macro dialog kuti utange macro recorder.
- Dzvanya paImba yebhu yebhoni.
- Simbisai masero A1 kusvika kuF1 mubasa rekushanda.
- Dzvanya paMusanganisi neCentral icon kuti uise musoro wepamusoro pakati pemasero A1 neF1.
- Dzvanya paDzadza Ratidza Mifananidzo icon (rinoratidzika sepende rinogona) kuzarura runyoro rwuri pasi-pasi.
- Sarudza Bhuruu, Tsvaga 1 kubva pakurongwa kuti udzore ruvara rwemashure emasero akasarudzwa kuva bhuruu.
- Kira pa Font Font icon (iri tsamba huru "A") kuti uzarure maruva ekuderedza pasi.
- Sarudza Muchena kubva pakurongwa kuti uende mutsara mumasero akasarudzwa kuti ave machena.
- Dzvanya paSpain Size icon (pamusoro pepende inogona kuisa chiratidzo) kuti uzarure urusi hwekuderera pasi.
- Sarudza 16 kubva pakurongwa kuti uchinje ukuru hwemashoko mumasero akasarudzwa kusvika kumapfumbamwe.
- Dzvanya kuMusununguri tabu rebhoni.
- Dzvanya bhora re Stop Stop kurebhenekera paibhoni kuti usiye kurekodi macro.
- Panguva ino, chinyorwa chebasa rako rinofanirwa kufanana nechokuita mumufananidzo uri pamusoro.
05 of 06
Running the Macro
Kuti utange macro iwe wakanyora:
- Dzvanya paSheet2 tab pane pasi pepasiteteti .
- Dzvanya pane sero A1 mubasa rekushanda.
- Nyora musoro wekuti: Cookie Shop Expenses yaJuly 2008 .
- Dhinda pikicha inopinda mubhokisi.
- Dzvanya kuMusununguri tabu rebhoni.
- Dzvanya bhodhi reMacrosi paibhoni kuti uwedzere kuona Macro dialog box.
- Kira pa format_titles macro mune mazita macro window.
- Dzvanya bhora Run .
- Matanho e-macro anofanirwa kumhanyira ega uye anoshandisa matanho akafanana ekugadzirisa anoshandiswa kune musoro uri peji 1.
- Parizvino, zita rekushanda pepaji 2 rinofanira kufanana nechokuita pane pepa rekushanda 1.
06 of 06
Zvikanganiso zveMacro / Kugadzira Macro
Macro Errors
Kana yako macro isina kuita sezvainotarisirwa, iyo iri nyore, uye yakanakisisa sarudzo ndeyokutevera matanho emudzidzisi zvakare uye zvakare kunyora macro.
Kugadziridza / Nhanho Ku Macro
An Excel macro yakanyorwa mubasa re Visual Basic for Applications (VBA) programming.
Kushandura paIndaneti kana Nhanho Muzvikoni mu Macro dialog box inotanga VBA editor (ona mufananidzo uri pamusoro).
Kushandisa VBA mupepeti uye kuvhara mutauro wekushandura VBA hakuperi mumamiriro emudzidzi uyu.