{"id":3728,"date":"2016-01-21T12:30:40","date_gmt":"2016-01-21T10:30:40","guid":{"rendered":"http:\/\/www.ramses.de\/?p=3728"},"modified":"2016-01-21T12:30:40","modified_gmt":"2016-01-21T10:30:40","slug":"excel-vba-good-games-studio-in-hamburg","status":"publish","type":"post","link":"https:\/\/www.ramses.de\/?p=3728","title":{"rendered":"Excel VBA &#8211; Good Games Studio in Hamburg"},"content":{"rendered":"<h1>Zaubern mit VBA<\/h1>\n<p class=\"page_lead\">Wieder einmal waren wir zu Gast bei den netten Damen und Herren der Firma beo GmbH in Hamburg. In den dortigen R\u00e4umen durfte ich ein weiteres Mal die Firma Goodgames Studio schulen. Das Thema des Tages war das Automatisieren des Excel mit Hilfe des VBA.<\/p>\n<h3>Unsere Agenda<\/h3>\n<ul>\n<li>Abgrenzung Makro \/ VBA<\/li>\n<li>Die pers\u00f6nliche Makroarbeitsmappe<\/li>\n<li>Aufzeichnung von Makros<\/li>\n<li>Zuweisung der Makros zu ShortCuts und Symbolen<\/li>\n<li>Der Unterschied zwischen Sub Proceduren und Function<\/li>\n<li>Erstellung eigener Funktionen<\/li>\n<li>Einbindung eigener Functionen als Add-In<\/li>\n<li>Logische Strukturen mit If, Then, Else<\/li>\n<li>Die Fallauswahl Select Case<\/li>\n<li>Z\u00e4hlergesteuerte For Next Schleifen<\/li>\n<li>Ereignisproceduren wie Open und BevorPrint etc.<\/li>\n<\/ul>\n<p>VBA w\u00e4re auch f\u00fcr Sie spannend? Dann senden Sie uns eine Mail und wir unterbreiten gerne ein unverbindliches Angebot.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Zaubern mit VBA Wieder einmal waren wir zu Gast bei den netten Damen und Herren der Firma beo GmbH in Hamburg. In den dortigen R\u00e4umen &#8230; <a title=\"Excel VBA &#8211; Good Games Studio in Hamburg\" class=\"read-more\" href=\"https:\/\/www.ramses.de\/?p=3728\" aria-label=\"Mehr Informationen \u00fcber Excel VBA &#8211; Good Games Studio in Hamburg\">Weiterlesen &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":3730,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"image","meta":{"footnotes":""},"categories":[52],"tags":[101,61],"class_list":["post-3728","post","type-post","status-publish","format-image","has-post-thumbnail","hentry","category-seminare","tag-excel","tag-vba","post_format-post-format-image","resize-featured-image"],"_links":{"self":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/3728","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3728"}],"version-history":[{"count":1,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/3728\/revisions"}],"predecessor-version":[{"id":3731,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/posts\/3728\/revisions\/3731"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=\/wp\/v2\/media\/3730"}],"wp:attachment":[{"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3728"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3728"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ramses.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}