Maitiro ekuvhura Excel nyowani mune imwe hwindo

Wakambofanira kumirira maminetsi akati wandei kuti bhuku rako reExcel riite macro, gadziridza Power Query, kana kuverengazve zvinorema mafomula? Iwe unogona, chokwadi, kuzadza kumbomira nekapu yetii nekofi pazvikonzero zviri pamutemo, asi ungangove uine imwe pfungwa: wadii kuvhura rimwe bhuku rekushanda reExcel padhuze uye woshanda naro izvozvi?

Asi hazvisi nyore kudaro.

Kana iwe ukavhura akawanda eExcel mafaera nenzira yakajairika (tinya-kaviri muExplorer kana kuburikidza ne Faira - Vhura muExcel), ivo vanovhura otomatiki mune imwecheteyo muenzaniso weMicrosoft Excel. Saizvozvo, kana iwe uchimhanyisa kuverenga kana macro mune imwe yeaya mafaera, ipapo iyo yese application ichave yakabatikana uye mabhuku ese akavhurika anozoomesa nechando, nekuti ivo vane yakajairwa Excel system process.

Dambudziko iri rinogadziriswa zviri nyore - unofanirwa kutanga Excel mune imwe nzira yakaparadzana. Ichave yakasununguka kune yekutanga uye ichakubvumidza kuti ushande pane mamwe mafaera murunyararo nepo yapfuura muenzaniso weExcel iri kushanda pane rinorema basa rakafanana. Pane nzira dzakati wandei dzekuita izvi, dzimwe dzacho dzinogona kana kusashanda zvichienderana neshanduro yako yeExcel uye zvigadziriso zvawakaisa. Saka edza zvese chimwe nechimwe.

Nzira 1. Pamberi

Iyo iri nyore uye yakanyanya kujeka sarudzo ndeyekusarudza kubva kune huru menyu Kutanga - Zvirongwa - Excel (Tanga - Zvirongwa - Excel). Nehurombo, iyi nzira yekutanga inongoshanda mumashanduro ekare eExcel.

Method 2: Pakati mbeva bhatani kana Alt

Maitiro ekuvhura Excel nyowani mune imwe hwindo

  1. Click iro rakarurama nekudzvanya paExcel icon pabhara rebasa - menyu yemukati inovhura ine runyoro rwemafaira achangoburwa.
  2. Pazasi pemenu iyi pachave neExcel mutsara - tinya pairi ruboshwe bhatani rembeva, holding nepo kiyi alt.

Imwe Excel inofanira kutanga mune itsva maitiro. Zvakare, pachinzvimbo chekudzvanya-kuruboshwe ne alt unogona kushandisa bhatani repakati mbeva - kana mbeva yako inayo (kana vhiri rekumanikidza rinotamba basa raro).

Nzira 3. Command line

Sarudza kubva kumenyu huru Kutanga – Mhanya (Tanga - Mhanya) kana kudzvanya keyboard shortcut kunda+R. Mundima inooneka, isa murairo:

Maitiro ekuvhura Excel nyowani mune imwe hwindo

Mushure mekunge mavharidza OK chiitiko chitsva cheExcel chinofanira kutanga mune imwe nzira.

Nzira 4. Macro

Iyi sarudzo yakanyanya kuomarara kupfuura yapfuura, asi inoshanda mune chero vhezheni yeExcel maererano nezvandinoona:

  1. Kuvhura iyo Visual Basic Mharidzo kuburikidza netabhu Mugadziri - Visual Basic (Mugadziri - Visual Basic) kana nzira yekudimbudzira keyboard alt + F11. Kana ma tabo yokuvaka isingaonekwe, unogona kuiratidza kuburikidza Faira - Sarudzo - Ribhoni Setup (Faira - Sarudzo - Gadzirisa Ribhoni).
  2. MuVisual Basic hwindo, isa nyowani isina chinhu module yekodhi kuburikidza nemenyu Pinza – Module.
  3. Kopa kodhi inotevera ipapo:
Sub Run_New_Excel() Set NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = True End Sub

Kana iwe uchimhanyisa ikozvino yakagadzirwa macro kuburikidza Mugadziri - Macros (Mugadziri - Macro) kana nzira yekudimbudzira keyboard alt+F8, ipapo imwe muenzaniso yeExcel ichagadzirwa, sezvataida.

Kuti zvive nyore, iyo kodhi iri pamusoro inogona kuwedzerwa kwete kubhuku razvino, asi kuBhuku Rega reMacros uye isa bhatani rakaparadzana reiyi maitiro pane yekukurumidza kupinda panhizha - ipapo chimiro ichi chinogara chiripo.

Nzira 5: VBScript file

Iyi nzira yakafanana neyakapfuura, asi inoshandisa VBScript, shanduro yakareruka yeVisual Basic mutauro, kuita zviito zviri nyore muWindows. Kuti uishandise ita zvinotevera:

Kutanga, gonesa kuratidzwa kwekuwedzera kwemafaira muExplorer kuburikidza Maonero - Faira Mawedzero (Ona - Faira Mawedzero):

Maitiro ekuvhura Excel nyowani mune imwe hwindo

Zvadaro tinogadzira faira remavara mune chero folda kana padesktop (semuenzaniso NewExcel.txt) uye kopira inotevera VBScript kodhi ipapo:

Seta NewExcel = GadziraObject("Excel.Application") NewExcel.Mabhuku ekushanda.Wedzera NewExcel.Visible = True set NewExcel = Hapana

Sevha uye uvhare faira, uye wozoshandura kuwedzera kwayo kubva txt on vbs. Mushure mekutumidza zita, yambiro ichaonekwa yaunofanirwa kubvumirana nayo, uye icon yefaira ichachinja:

Maitiro ekuvhura Excel nyowani mune imwe hwindo

Zvose. Iye zvino kudzvanya kaviri bhatani rekuruboshwe pafaira iri kuchatangisa imwe yakazvimirira muenzaniso yeExcel paunenge uchiida.

PS

Ramba uchifunga kuti mukuwedzera kune zvakanakira, kumhanya akawanda maekisi eExcel ane hunhu hwayo zvakare. aya masisitimu maitiro "haaonane" mumwe nemumwe. Semuenzaniso, haugone kuita chinongedzo chakananga pakati pemaseru ebhuku rebasa mune akasiyana Excel. Zvakare, kukopa pakati pezviitiko zvakasiyana zvechirongwa, nezvimwe zvichave zvishoma. Muzviitiko zvakawanda, zvisinei, uyu hausi mutengo wakakura kudaro kubhadhara nekuda kwekusatambisa nguva kumirira.

  • Maitiro ekudzikisa saizi yefaira uye nekumhanyisa
  • Chii chinonzi Personal Macro Book uye nzira yekuishandisa

Leave a Reply