{"id":515,"date":"2017-09-12T10:57:28","date_gmt":"2017-09-12T08:57:28","guid":{"rendered":"http:\/\/markusheinemann.com\/wordpress\/?p=515"},"modified":"2017-09-12T10:57:28","modified_gmt":"2017-09-12T08:57:28","slug":"datei-beschreiben-ueberschreiben","status":"publish","type":"post","link":"https:\/\/markusheinemann.com\/wordpress\/?p=515","title":{"rendered":"Datei beschreiben (\u00fcberschreiben)"},"content":{"rendered":"<p><em>vorhandene Dateien mit dem gew\u00e4hlten Namen werden \u00fcberschrieben<\/em><\/p>\n<pre><code>\r\nDim pfad As String\r\npfad = ActiveWorkbook.Path &amp; \"\" &amp; \"datensatz.txt\" '&lt;- Pfad der ge\u00f6ffneten Exceldatei\r\nOpen pfad For Output As #1\r\nzeile = \"Text in der Datei\"\r\nPrint #1, zeile\r\nzeile = \"\/\/ noch mehr text\" &amp; vbCrLF '&lt;- Zeilenumbruch\r\nPrint #1, zeile\r\nClose #1\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>vorhandene Dateien mit dem gew\u00e4hlten Namen werden \u00fcberschrieben Dim pfad As String pfad = ActiveWorkbook.Path &amp; &#8222;&#8220; &amp; &#8222;datensatz.txt&#8220; &#8218;&lt;- Pfad der ge\u00f6ffneten Exceldatei Open pfad For Output As #1 zeile = &#8222;Text in der Datei&#8220; Print #1, zeile zeile = &#8222;\/\/ noch mehr text&#8220; &amp; vbCrLF &#8218;&lt;- Zeilenumbruch Print #1, zeile Close #1<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-515","post","type-post","status-publish","format-standard","hentry","category-vba-codebeispiele"],"_links":{"self":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/515","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=515"}],"version-history":[{"count":1,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/515\/revisions"}],"predecessor-version":[{"id":516,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/515\/revisions\/516"}],"wp:attachment":[{"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markusheinemann.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}