{"id":3039,"date":"2023-11-17T10:05:20","date_gmt":"2023-11-17T10:05:20","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/"},"modified":"2023-12-03T11:22:08","modified_gmt":"2023-12-03T11:22:08","slug":"uberprufen-sie-die-geoffnete-arbeitsmappe","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/","title":{"rendered":"Wie kann ich \u00fcber vba pr\u00fcfen, ob eine arbeitsmappe ge\u00f6ffnet ist?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-768683348\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Um mithilfe von VBA-Code zu \u00fcberpr\u00fcfen, ob eine Arbeitsmappe ge\u00f6ffnet ist, m\u00fcssen Sie <a href=\"https:\/\/exceladvisor.org\/de\/fur-die-schleife\/\">die FOR EACH-<\/a> Schleife verwenden, die alle derzeit ge\u00f6ffneten Arbeitsmappen durchlaufen und den Namen jeder Arbeitsmappe mit dem von Ihnen genannten Namen vergleichen kann. Sie k\u00f6nnen ein <a href=\"https:\/\/exceladvisor.org\/de\/vba-nachrichtenbox\/\">Meldungsfeld<\/a> verwenden, um das Ergebnis der Schleife abzurufen. Oder Sie k\u00f6nnen den Code auch ausf\u00fchren, um das Ergebnis in eine Zelle einzugeben.<\/p><h2 class=\"wp-block-heading\"> \u00dcberpr\u00fcfen Sie, ob eine Arbeitsmappe ge\u00f6ffnet ist<\/h2><ol><li> Zuerst m\u00fcssen Sie <a href=\"https:\/\/exceladvisor.org\/de\/variablen\/\">die Variablen deklarieren,<\/a> die im Code verwendet werden sollen, um eine Schleife zu erstellen. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-erstelle-eine-Schleife\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"create a loop\" width=\"365\" height=\"180\"><\/li><li> Verwenden Sie ein Eingabefeld, um den Namen der Arbeitsmappe abzurufen, nach der Sie suchen m\u00f6chten. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-verwendet-ein-Eingabefeld\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-une-zone-de-saisie.png\" sizes=\"auto, \" srcset=\"\" alt=\"use an input box\" width=\"448\" height=\"172\"><\/li><li> Starten Sie die Schleife, um alle ge\u00f6ffneten Arbeitsmappen durchzugehen. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-Start-Loop-to-Loop\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-demarrer-la-boucle-a-boucle.png\" sizes=\"auto, \" srcset=\"\" alt=\"start the loop to loop\" width=\"451\" height=\"204\"><\/li><li> Schreiben Sie Code mit <a href=\"https:\/\/exceladvisor.org\/de\/wenn-2\/\">der IF-Anweisung<\/a> , um den Arbeitsmappennamen mit dem Namen zu vergleichen, den Sie in das Eingabefeld eingegeben haben. Sobald der Name \u00fcbereinstimmt, wird die Arbeitsmappe aktiviert, ein Meldungsfeld angezeigt, das besagt, dass die Arbeitsmappe gefunden wurde, und der Vorgang wird beendet. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-Code-mit-if-Anweisung\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-code-avec-instruction-if.png\" sizes=\"auto, \" srcset=\"\" alt=\"code with if statement\" width=\"436\" height=\"332\"><\/li><li> Schlie\u00dfen Sie am Ende die Schleife ab und verwenden Sie ein Meldungsfeld, um ein Meldungsfeld anzuzeigen, wenn nichts gefunden wurde. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-End-the-Loop-and-Use-Message-Box\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-terminer-la-boucle-et-utiliser-une-boite-de-message.png\" sizes=\"auto, \" srcset=\"\" alt=\"end the loop and use a message box\" width=\"477\" height=\"332\"><\/li><\/ol><p class=\"content-box-grey\"><mark class=\"has-inline-color\" style=\"background-color: #ffdc1a;\"> <strong>N\u00fctzliche Links:<\/strong> <a href=\"https:\/\/exceladvisor.org\/de\/ein-makro-ausfuhren-2\/\">Ausf\u00fchren eines Makros<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/de\/ein-makro-aufzeichnen\/\">Makrorecorder<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/de\/einfacher-visueller-editor\/\">Visual Basic Editor<\/a> \u2013 <a href=\"https:\/\/exceladvisor.org\/de\/personliches-makro-notizbuch\/\">Handbuch zu pers\u00f6nlichen Makros<\/a><\/mark><\/p><p> Hier ist der vollst\u00e4ndige Code.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_check_workbook() Dim WB As Workbook Dim myWB As String myWB = InputBox(Prompt:=\"Enter the workbook name.\") For Each WB In Workbooks If WB.Name = myWB Then WB.Activate MsgBox \"Workbook Found!\" Exit Sub End If Next WB MsgBox \"Not Found\" End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/de\/vba\/\">Was ist VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Verwandte Tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/de\/excel-datei-kopieren\/\">Kopieren Sie eine Excel-Datei (Arbeitsmappe) mit VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/arbeitsmappe-aktivieren\/\">VBA-Arbeitsmappe aktivieren (Excel-Datei)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/schliessen-sie-die-arbeitsmappe\/\">VBA-Arbeitsmappe schlie\u00dfen (Excel-Datei)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/arbeitsmappen-kombinieren\/\">VBA Arbeitsmappen kombinieren (Excel-Dateien)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/eine-arbeitsmappe-erstellen\/\">VBA Erstellen Sie eine neue Arbeitsmappe (Excel-Datei)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-3039","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T11:22:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/\",\"name\":\"Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\",\"datePublished\":\"2023-11-17T10:05:20+00:00\",\"dateModified\":\"2023-12-03T11:22:08+00:00\",\"description\":\"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie kann ich \u00fcber vba pr\u00fcfen, ob eine arbeitsmappe ge\u00f6ffnet ist?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?","description":"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/","og_locale":"de_DE","og_type":"article","og_title":"Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?","og_description":"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren","og_url":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T11:22:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/","url":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/","name":"Wie \u00fcberpr\u00fcfe ich, ob eine Arbeitsmappe \u00fcber VBA in Excel ge\u00f6ffnet ist?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","datePublished":"2023-11-17T10:05:20+00:00","dateModified":"2023-12-03T11:22:08+00:00","description":"In diesem Tutorial lernen Sie, wie Sie mit VBA pr\u00fcfen, ob eine bestimmte Excel-Datei ge\u00f6ffnet ist, und diese nach der Pr\u00fcfung aktivieren","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-une-boucle.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/de\/uberprufen-sie-die-geoffnete-arbeitsmappe\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie kann ich \u00fcber vba pr\u00fcfen, ob eine arbeitsmappe ge\u00f6ffnet ist?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3039","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3039"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3039\/revisions"}],"predecessor-version":[{"id":4103,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3039\/revisions\/4103"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3039"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}