Sida loo furo Excel cusub daaqad gaar ah

Weligaa ma ku qasbanaatay inaad dhawr daqiiqo sugto buuggaaga shaqada ee Excel si uu u socodsiiyo makro, u cusboonaysiiyo Query Query, ama dib u xisaabiyo hababka culus? Dabcan, waxaad ku buuxin kartaa hakadka koob shaaha iyo kafeega ah oo ku saabsan sifo sharci ah, laakiin waxaa laga yaabaa inaad leedahay fikrad kale: maxaad u furi weyday buug-shaqeedka Excel kale oo u dhow oo aad hadda ula shaqeyso?

Laakiin sidaas uma fududa.

Haddii aad u furto faylal badan oo Excel ah sida caadiga ah (laba-guji gudaha Explorer ama adigoo isticmaalaya Faylka - Fur gudaha Excel), waxay si toos ah u furmaan isla tusaale ahaan Microsoft Excel. Sidaa darteed, haddii aad dib u xisaabiso ama macro mid ka mid ah faylashaas, markaa codsiga oo dhan wuxuu noqon doonaa mid mashquul ah oo dhammaan buugaagta furan ayaa xayiri doona, sababtoo ah waxay leeyihiin habka nidaamka Excel caadiga ah.

Dhibaatadan si fudud ayaa loo xalliyaa - waxaad u baahan tahay inaad Excel ku bilowdo hab cusub oo gooni ah. Waxay noqon doontaa mid ka madax bannaan kan ugu horreeya waxayna kuu ogolaaneysaa inaad ku shaqeyso faylal kale si nabad ah halka tusaalihii hore ee Excel uu ka shaqeynayo hawl culus oo barbar socota. Waxaa jira dhowr siyaabood oo tan loo sameeyo, kuwaas oo qaarkood laga yaabo ama laga yaabo inay shaqeeyaan iyadoo ku xiran nooca Excel iyo cusbooneysiinta aad rakibtay. Haddaba isku day wax kasta mid mid.

Habka 1. Hore

Doorashada ugu fudud uguna cad waa inaad ka doorato liiska ugu muhiimsan Bilaw – Barnaamijyada – Excel (Bilow - Barnaamijyada - Excel). Nasiib darro, habkan asaasiga ahi wuxuu ku shaqeeyaa oo keliya noocyada hore ee Excel.

Habka 2: badhanka jiirka dhexe ama Alt

Sida loo furo Excel cusub daaqad gaar ah

  1. Riix midka saxda adigoo gujinaya sumadda Excel ee ku taal barta shaqada - menu macnaha guud ayaa furmi doona oo wata liis galkii dhawaa.
  2. Xagga hoose ee liiskan waxaa jiri doona saf Excel - ku dhufo Bidix badhanka jiirka, haysta halka furaha Alt.

Excel kale waa inuu ku bilaabmaa hannaan cusub. Sidoo kale, halkii aad ka gujin lahayd bidixda Alt waxaad isticmaali kartaa badhanka jiirka dhexe - haddii jiirkaagu leeyahay (ama giraangiraha cadaadiska ayaa doorkiisa ciyaaraya).

Habka 3. line Command

Ka dooro liiska ugu muhiimsan Bilow – Orod (Bilow - Orod) ama taabo furaha kiiboodhka Win+R. Goobta soo muuqata, geli amarka:

Sida loo furo Excel cusub daaqad gaar ah

Ka dib guji OK tusaale cusub oo Excel ah waa inuu ku bilaabmaa hab gaar ah.

Habka 4. Macro

Doorashadani way ka yara dhib badan tahay kuwii hore, laakiin waxay ku shaqeysaa nooc kasta oo Excel ah marka loo eego indha-indhayntayda:

  1. Furitaanka Tifaftiraha Aasaasiga ah ee Visual iyadoo loo marayo tab Horumarinta - Visual Basic (Developer — Visual Basic) ama kiiboodhka gaaban Alt + F11. Haddii tabs sameeysa aan la arki karin, waxaad ku soo bandhigi kartaa iyada oo loo marayo Faylka - Ikhtiyaarada - Dejinta Ribbon (Faylka - Ikhtiyaarada - Habboon Ribbon).
  2. Daaqada Visual Basic, geli module cusub oo maran koodka menu-ka Geli - Module.
  3. Ku koobbi koodka soo socda halkaas:
Sub Run_New_Excel() Deji NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Ku dar NewExcel.Visible = Run End Sub

Haddii aad ku socodsiiso macro hadda la abuuray Horumarinta - Macros (horumariye-Makro) ama kiiboodhka gaaban Alt+F8, ka dibna tusaale gaar ah oo Excel ah ayaa la abuuri doonaa, sidii aan rabnay.

Si ay ugu habboonaato, koodhka kor ku xusan waxaa lagu dari karaa buuga hadda jira, laakiin buug-gacmeedka shakhsi ahaaneed ee Macros oo ku dheji badhan gaar ah habkan guddiga helitaanka degdega ah - ka dibna qaabkani wuxuu had iyo jeer ku jiri doonaa gacanta.

Habka 5: faylka VBScript

Habkani wuxuu la mid yahay kii hore, laakiin wuxuu isticmaalaa VBScript, oo ah nooca aadka loo fududeeyey ee Visual Basic Language, si uu u sameeyo ficillo fudud oo sax ah gudaha Windows. Si aad u isticmaasho samee sida soo socota:

Marka hore, awood soo bandhiga kordhinta faylasha Explorer iyada oo loo marayo Fiiri - Faylka Kordhinta (Arag - Kordhinta Faylka):

Sida loo furo Excel cusub daaqad gaar ah

Kadibna waxaan ka abuurnaa faylka qoraalka gal kasta ama miiska (tusaale ahaan NewExcel.txt) oo koobi ka samee koodka VBScript ee soo socda:

Deji NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = Runta dhigay NewExcel = waxba

Kaydi oo xidh faylka, ka dibna ka beddel kordhintiisa txt on qiyaastii. Magacaabista ka dib, digniin ayaa soo bixi doonta taas oo ay tahay inaad ogolaato, oo sumadda faylka ayaa isbedeli doonta:

Sida loo furo Excel cusub daaqad gaar ah

Wax walba. Hadda laba jeer gujinta badhanka jiirka bidix ee faylkan waxay bilaabi doontaa tusaale madax banaan oo cusub oo Excel ah markaad u baahato.

PS

Maskaxda ku hay in marka lagu daro faa'iidooyinka, socodsiinta tusaalooyin badan oo Excel ah ayaa sidoo kale leh qasaarooyinkeeda. Nidaamyadani "ma arkaan" midba midka kale. Tusaale ahaan, ma awoodi doontid inaad sameyso xiriir toos ah oo ka dhexeeya unugyada buugaagta shaqada ee Excel kala duwan. Sidoo kale, koobiyeynta inta u dhaxaysa xaaladaha kala duwan ee barnaamijka, iwm ayaa si aad ah u xaddidi doona. Kiisaska intooda badan, si kastaba ha ahaatee, tani maaha qiimo sidaas u weyn oo lagu bixinayo waqti la'aanta sugitaanka.

  • Sida loo yareeyo cabbirka faylka oo loo dedejiyo
  • Waa maxay Buugga Macro-shaqsiyeedka iyo sida loo isticmaalo

Leave a Reply