{"id":340359,"date":"2024-06-04T12:40:02","date_gmt":"2024-06-04T11:40:02","guid":{"rendered":"https:\/\/learnesy.com\/?p=340359"},"modified":"2024-06-04T12:40:13","modified_gmt":"2024-06-04T11:40:13","slug":"ladda-ned-vart-em-schema","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/ladda-ned-vart-em-schema\/","title":{"rendered":"\u26bd Ladda ned v\u00e5rt EM-schema \ud83d\udcc5"},"content":{"rendered":"<p><em>Hoppas du ser fram emot fotbolls-EM lika mycket som vi p\u00e5 Learnesy! Med v\u00e5rt Excel-schema kan du importera samtliga matcher i sommarens Europam\u00e4sterskap i fotboll till Outlook. F\u00f6lj instruktionerna i den f\u00f6rsta fliken &#8217;Info&#8217; f\u00f6r att s\u00e4kerst\u00e4lla att det blir r\u00e4tt.\u00a0<\/em><\/p>\n<p><em>Du hittar filen <a href=\"\/wp-content\/uploads\/2024\/06\/EM2024-Schema.xlsm\">h\u00e4r<\/a>.<\/em><\/p>\n<hr \/>\n<span id=\"heading-hur-fungerar-filen\"><h2>Hur fungerar filen?<\/h2><\/span>\n<p>Knappen i filen som importerar schemat till din Outlook \u00e4r kopplad till ett makro. Det g\u00e5r att bryta ned koden till detta makro i tre huvudsakliga delar:<\/p>\n<ol>\n<li><strong>Loop genom rader<\/strong>: Makrot anv\u00e4nder en loop f\u00f6r att iterera genom raderna i Excel-arket som inneh\u00e5ller matchschemat.<\/li>\n<li><strong>Skapa Outlook-h\u00e4ndelser<\/strong>: F\u00f6r varje rad skapar makrot en ny Outlook-h\u00e4ndelse med olika egenskaper, inklusive status (tillg\u00e4nglig, upptagen, osv.), viktighet, p\u00e5minnelse och \u00e4mne.<\/li>\n<li><strong>Hyperl\u00e4nk<\/strong>: Slutligen \u00f6ppnar makrot en webbl\u00e4nk till en landningssida.<\/li>\n<\/ol>\n<span id=\"heading-vad-ar-vba-makron-for-nagot\"><h3>Vad \u00e4r VBA &amp; makron f\u00f6r n\u00e5got?<\/h3><\/span>\n<p>VBA (Visual Basic for Applications) \u00e4r ett programmeringsspr\u00e5k som anv\u00e4nds f\u00f6r att skapa makron och automatisera uppgifter i program som Excel, Word och andra Microsoft Office-program. Med VBA kan du skriva anpassade funktioner, automatisera processer och skapa egna till\u00e4mpningsprogram. Det \u00e4r ett kraftfullt verktyg f\u00f6r att effektivisera arbetsfl\u00f6den och anpassa Office-program efter dina behov.<\/p>\n<span id=\"heading-jag-vill-lara-mig-mer\"><h3>Jag vill l\u00e4ra mig mer!<\/h3><\/span>\n<p>Kul, vi har n\u00e4mligen en kurs i \u00e4mnet \u2013\u00a0<a href=\"https:\/\/learnesy.com\/sv\/courses\/vba-och-makron\/\"><em>VBA och makron<\/em><\/a>. Just nu ing\u00e5r v\u00e5r nya kurs i Microsoft Copilot vid <a href=\"https:\/\/learnesy.com\/sv\/erbjudande-fa-din-kurs-i-microsoft-copilot-pa-kopet\/\">k\u00f6p av valfri annan kurs<\/a>. Du kan allts\u00e5 f\u00e5 en kurs i VBA och makron, samt en kurs i Copilot p\u00e5 k\u00f6pet!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>F\u00e5 sommarens spelschema i din Outlook!<\/p>\n","protected":false},"author":54291,"featured_media":340395,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[30],"tags":[],"class_list":["post-340359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ovrigt"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/340359","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=340359"}],"version-history":[{"count":1,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/340359\/revisions"}],"predecessor-version":[{"id":340396,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/340359\/revisions\/340396"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/340395"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=340359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=340359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=340359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}