Yadda ake bude sabon Excel a wata taga daban

Shin kun taɓa jira mintuna da yawa don littafin aikinku na Excel don gudanar da macro, sabunta Tambayoyin Wuta, ko sake ƙididdige ƙididdiga masu nauyi? Kuna iya, ba shakka, cika dakatarwar tare da ƙoƙon shayi da kofi akan filaye na doka gabaɗaya, amma wataƙila kuna da wani tunani: me yasa ba za ku buɗe wani littafin aikin Excel kusa ba kuma kuyi aiki da shi yanzu?

Amma ba haka ba ne mai sauki.

Idan kun buɗe fayilolin Excel da yawa a cikin hanyar da aka saba (danna sau biyu a cikin Explorer ko ta hanyar Fayil - Buɗe a cikin Excel), suna buɗewa ta atomatik a cikin misalin Microsoft Excel. Don haka, idan kun kunna recalculation ko macro a cikin ɗayan waɗannan fayilolin, to duk aikace-aikacen za su kasance cikin aiki kuma duk buɗaɗɗen littattafan za su daskare, saboda suna da tsarin tsarin Excel gama gari.

Ana magance wannan matsalar a sauƙaƙe - kuna buƙatar fara Excel a cikin sabon tsari daban. Zai zama mai zaman kanta daga na farko kuma zai ba ku damar yin aiki a kan wasu fayiloli a cikin kwanciyar hankali yayin da misali na Excel na baya yana aiki akan aiki mai nauyi a layi daya. Akwai hanyoyi da yawa don yin wannan, wasu daga cikinsu ƙila ko ba za su yi aiki ba dangane da sigar Excel ɗin ku da sabuntawar da kuka shigar. Don haka gwada komai daya bayan daya.

Hanyar 1. Gaba

Zaɓin mafi sauƙi kuma mafi bayyane shine zaɓi daga babban menu Fara - Shirye-shirye - Excel (Fara - Shirye-shirye - Excel). Abin baƙin ciki shine, wannan tsarin na farko yana aiki ne kawai a cikin tsoffin juzu'in Excel.

Hanyar 2: Maɓallin linzamin kwamfuta na tsakiya ko Alt

Yadda ake bude sabon Excel a wata taga daban

  1. Click da 'yancin ta danna gunkin Excel akan ma'aunin aiki - menu na mahallin zai buɗe tare da jerin fayilolin kwanan nan.
  2. A kasan wannan menu za a sami layin Excel - danna kan shi bar linzamin kwamfuta, rike yayin da key alt.

Wani Excel ya kamata ya fara a cikin sabon tsari. Hakanan, maimakon danna hagu tare da alt zaka iya amfani da maɓallin linzamin kwamfuta na tsakiya - idan linzamin kwamfuta yana da shi (ko motsin matsa lamba yana taka rawarsa).

Hanyar 3. Layin umarni

Zaɓi daga babban menu Fara - Gudu (Fara - Gudu) ko danna gajeriyar hanyar madannai Win+R. A cikin filin da ya bayyana, shigar da umarni:

Yadda ake bude sabon Excel a wata taga daban

Bayan danna kan OK wani sabon misali na Excel yakamata ya fara a cikin wani tsari daban.

Hanyar 4. Macro

Wannan zaɓin ya ɗan fi rikitarwa fiye da na baya, amma yana aiki a kowace sigar Excel bisa ga abubuwan da na lura:

  1. Buɗe Editan Kayayyakin Kayayyakin Kayayyakin Ta hanyar shafi Developer - Kayayyakin Kayayyakin Kayayyakin Kayayyakin (Mai haɓakawa - Kayayyakin Kayayyakin gani) ko gajeriyar hanyar keyboard alt + F11. Idan tabs developer ba a bayyane ba, zaku iya nunawa ta hanyar Fayil - Zaɓuɓɓuka - Saitin Ribbon (Fayil - Zaɓuɓɓuka - Keɓance Ribbon).
  2. A cikin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Kayayyakin Lamba don lamba ta cikin menu Saka - Module.
  3. Kwafi wannan lambar a can:
Sub Run_New_Excel() Saita NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Ƙara NewExcel.Visible = Gaskiya Ƙarshen Sub.

Idan kun kunna macro da aka ƙirƙira ta hanyar Developer - Macros (Developer - Macro) ko gajeriyar hanyar keyboard alt+F8, sannan za a ƙirƙiri wani misali na daban na Excel, kamar yadda muke so.

Don dacewa, za'a iya ƙara lambar da ke sama ba zuwa littafin na yanzu ba, amma zuwa Littafin Keɓaɓɓen Macros kuma sanya maɓalli daban don wannan hanya a kan kwamitin samun damar gaggawa - to wannan fasalin koyaushe zai kasance a hannu.

Hanyar 5: Fayil na VBScript

Wannan hanyar tana kama da wacce ta gabata, amma tana amfani da VBScript, sigar Sauƙaƙen Harshen Kayayyakin Kayayyakin Kayayyakin Kayayyakin, don aiwatar da ayyuka masu sauƙi daidai a cikin Windows. Don amfani da shi, yi haka:

Da farko, kunna nunin kari don fayiloli a cikin Explorer ta hanyar Duba – Fayil Extensions (Duba - Fayilolin Fayil):

Yadda ake bude sabon Excel a wata taga daban

Sannan muna ƙirƙirar fayil ɗin rubutu a kowace babban fayil ko akan tebur (misali NewExcel.txt) kuma kwafi lambar VBScript mai zuwa a can:

Saita NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Add NewExcel.Visible = Gaskiya saitin NewExcel = Babu komai

Ajiye kuma rufe fayil ɗin, sannan canza tsawo daga txt on vbs. Bayan sake suna, gargadi zai bayyana wanda dole ne ku yarda da shi, kuma gunkin fayil ɗin zai canza:

Yadda ake bude sabon Excel a wata taga daban

Komai. Yanzu danna maɓallin linzamin kwamfuta na hagu sau biyu akan wannan fayil ɗin zai ƙaddamar da sabon misali mai zaman kansa na Excel lokacin da kuke buƙata.

PS

Ka tuna cewa ban da ribobi da fursunoni, gudanar da lokuta da yawa na Excel yana da fursunoni kuma. waɗannan tsarin tsarin "ba sa ganin" juna. Misali, ba za ku iya yin hanyar haɗin kai kai tsaye tsakanin sel littafin aiki a cikin Excel daban-daban ba. Hakanan, yin kwafi tsakanin lokuta daban-daban na shirin, da sauransu za a iyakance su sosai. A mafi yawan lokuta, duk da haka, wannan ba shine babban farashin da za a biya don rashin ɓata lokaci ba.

  • Yadda za a rage girman fayil da sauri
  • Menene Littafin Macro na Keɓaɓɓen da yadda ake amfani da shi

Leave a Reply