{"id":2132,"date":"2023-09-30T00:09:48","date_gmt":"2023-09-30T00:09:48","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/"},"modified":"2023-12-10T06:06:19","modified_gmt":"2023-12-10T06:06:19","slug":"metin-dosyalari","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/","title":{"rendered":"Vba kullanarak bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-1506616390\"><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>VBA kodunu kullanarak metin olu\u015fturmak i\u00e7in CreateTextFile y\u00f6ntemini kullanman\u0131z gerekir. Bu y\u00f6ntem, olu\u015fturmak istedi\u011finiz konumu ayarlaman\u0131za olanak tan\u0131r. Bu y\u00f6ntem, konumdaki dosyan\u0131n \u00fczerine yazmak isteyip istemedi\u011finizi belirtebilece\u011finiz ve dosyan\u0131n Unicode olarak m\u0131 yoksa ASCII dosyas\u0131 olarak m\u0131 olu\u015fturuldu\u011funu belirtebilece\u011finiz s\u00f6zdizimine sahiptir.<\/p><h2 class=\"wp-block-heading\"> VBA ile bir metin dosyas\u0131 olu\u015fturun<\/h2><p> A\u015fa\u011f\u0131daki ad\u0131mlar\u0131 kullan\u0131n:<\/p><ol><li> \u00d6ncelikle y\u00f6ntemle kullanmak i\u00e7in bir FileSystemObject veya Folder nesnesi kullanman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-vba kullanarak-bir-metin dosyas\u0131 olu\u015ftur\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-a-text-fie-using-vba\" width=\"522\" height=\"305\"><\/li><li> Bundan sonra CreateTextFile y\u00f6ntemini kullanarak ba\u015fka bir nesne olu\u015fturman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"Metin dosyas\u0131 olu\u015fturman\u0131n 2 y\u00f6ntemi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-Creer-une-methode-de-fichier-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"create-text-file-method\" width=\"779\" height=\"321\"><\/li><li> Bu kodda, klas\u00f6rde ayn\u0131 isimde bir dosya zaten varsa \u00fczerine yazmak i\u00e7in TRUE&#8217;yu kulland\u0131k.<\/li><li> Sonunda bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda klas\u00f6rde a\u015fa\u011f\u0131daki gibi yeni bir metin dosyas\u0131 olu\u015fturun.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub create_text_file() 'object to use as folder Dim fld As Object Set fld = CreateObject(\"Scripting.FileSystemObject\") 'using create text file method Dim myFile As Object Set myFile = fld.CreateTextFile(\"C:UsersDellDesktopmyFoldermyTextFile.txt\", True) End Sub<\/code><\/pre><h2 class=\"wp-block-heading\"> CreateTextFile y\u00f6nteminin s\u00f6zdizimi<\/h2><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">CreateTextFile (filename, [ overwrite, [ unicode ]])<\/code><\/pre><ul><li> <strong>dosya ad\u0131:<\/strong> Olu\u015fturmak istedi\u011finiz dosyan\u0131n yolu ve ad\u0131.<\/li><li> <strong>overwrite:<\/strong> dosyan\u0131n \u00fczerine yazmak isteyip istemedi\u011finizi tan\u0131mlamak i\u00e7in boolean (zaten mevcutsa) (iste\u011fe ba\u011fl\u0131).<\/li><li> <strong>unicode:<\/strong> dosyan\u0131n Unicode olarak m\u0131 yoksa ASCII dosyas\u0131 olarak m\u0131 olu\u015fturuldu\u011funu tan\u0131mlamak i\u00e7in boolean (iste\u011fe ba\u011fl\u0131).<\/li><\/ul><h2 class=\"wp-block-heading\"> VBA kullanarak bir metin dosyas\u0131na yaz\u0131n<\/h2><p> Bir metin dosyas\u0131na veri yazmak i\u00e7in iki ifadeyi kullanabilirsiniz:<\/p><ol><li> <strong data-rich-text-format-boundary=\"true\">Write:<\/strong> Bu ifadeyle, de\u011ferler aras\u0131na virg\u00fcl, dizelerin etraf\u0131na t\u0131rnak i\u015faretleri ve tarihlerin etraf\u0131na # i\u015faretinin yerle\u015ftirilece\u011fi bir metin dosyas\u0131na veri yazabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-yazma beyan\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ecrire-une-declaration.png\" sizes=\"auto, \" srcset=\"\" alt=\"write-statement\" width=\"496\" height=\"291\"><\/li><li> <strong data-rich-text-format-boundary=\"true\">Yazd\u0131r:<\/strong> Bu ifadeyle, verileri bir metin dosyas\u0131na, Excel elektronik tablosundaki g\u00f6r\u00fcn\u00fcm\u00fcn ayn\u0131s\u0131yla yazabilirsiniz. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 karakterli a\u00e7\u0131klama\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-declaration-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"print-statement\" width=\"650\" height=\"344\"><\/li><\/ol><p> \u015eimdi her iki ifade i\u00e7in \u00f6rneklere bakaca\u011f\u0131z ve bir metin dosyas\u0131na yazmak i\u00e7in kodun tamam\u0131n\u0131n nas\u0131l yaz\u0131laca\u011f\u0131n\u0131 anlayaca\u011f\u0131z. Ancak bundan \u00f6nce kodu istedi\u011finiz gibi yazabilmek i\u00e7in <strong>baz\u0131 terminolojileri<\/strong> anlaman\u0131z gerekir.<\/p><ul><li> <strong>\u00c7\u0131kt\u0131 i\u00e7in:<\/strong> Bir metin dosyas\u0131na veri yazmak veya veriyi de\u011fi\u015ftirmek istedi\u011finizde bu komutu kullanabilirsiniz.<\/li><li> <strong>Giri\u015f i\u00e7in:<\/strong> Bu komutla bir metinden veri \u00e7\u0131karabilirsiniz, ancak dosyada veri de\u011fi\u015ftiremez ve ekleyemezsiniz.<\/li><li> <strong>Eklemek i\u00e7in:<\/strong> Bu komut, metin dosyas\u0131n\u0131n alt\u0131na yeni veriler eklemenize yard\u0131mc\u0131 olur.<\/li><li> <strong>FreeFile:<\/strong> Kullanmak istedi\u011finiz metin dosyas\u0131 i\u00e7in kullan\u0131lmayan bir dosya numaras\u0131 ayarlamak ve b\u00f6ylece ona ba\u015fvurabilmek i\u00e7in bunu kullanabilirsiniz.<\/li><\/ul><p> \u015eimdi bir metin dosyas\u0131na veri girmek i\u00e7in bir kod yazal\u0131m.<\/p><ol><li> \u00d6ncelikle kodda kullan\u0131lacak de\u011fi\u015fkenleri tan\u0131mlaman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-beyan-de\u011fi\u015fkenler\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-declarer-des-variables.png\" sizes=\"auto, \" srcset=\"\" alt=\"declare-variables\" width=\"381\" height=\"337\"><\/li><li> Bundan sonra metin dosyas\u0131na yazman\u0131z gereken aral\u0131\u011f\u0131 tan\u0131mlaman\u0131z gerekir. Ve aral\u0131ktaki h\u00fccre say\u0131s\u0131n\u0131 bir de\u011fi\u015fkene ayarlayarak d\u00f6ng\u00fc i\u00e7in bir saya\u00e7 olarak kullan\u0131n. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-aral\u0131\u011f\u0131-tan\u0131mla\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-definir-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-the-range\" width=\"416\" height=\"114\"><\/li><li> Daha sonra, veri eklemek istedi\u011finiz metin dosyas\u0131n\u0131n adresini ayarlaman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-set-metin-dosya-adresi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-definir-ladresse-du-fichier-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"define-the-address-of-the-text-file\" width=\"575\" height=\"99\"><\/li><li> Buradan, dosya numaras\u0131n\u0131 almak i\u00e7in &#8220;FreeFile&#8221; komutunu bir de\u011fi\u015fkene bildirmeniz gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-\u00fccretsiz dosya komutu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-commande-de-fichier-libre.png\" sizes=\"auto, \" srcset=\"\" alt=\"freefile-command\" width=\"452\" height=\"80\"><\/li><li> Art\u0131k dosyaya veri eklemeniz gerekti\u011fi i\u00e7in \u201cOutput\u201d komutunu kullanarak olu\u015fturman\u0131z gerekiyor. <br><img loading=\"lazy\" decoding=\"async\" title=\"9 \u00e7\u0131k\u0131\u015f kontrol\u00fc\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-sortie-de-commande.png\" sizes=\"auto, \" srcset=\"\" alt=\"output-command\" width=\"580\" height=\"80\"><\/li><li> Son olarak aral\u0131k de\u011ferlerini tek tek al\u0131p dosyaya eklemek i\u00e7in \u201cFor Next\u201d d\u00f6ng\u00fcs\u00fcn\u00fc kullanman\u0131z gerekiyor. <br><img loading=\"lazy\" decoding=\"async\" title=\"De\u011ferleri almak i\u00e7in sonraki d\u00f6ng\u00fcde 10\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-pour-la-prochaine-boucle-pour-obtenir-des-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"for-next-loop-to-get-values\" width=\"436\" height=\"201\"><\/li><li> Ayr\u0131ca metin dosyas\u0131na veri eklendikten sonra kapatmak i\u00e7in kapat komutunu kullanman\u0131z gerekir. <br><img loading=\"lazy\" decoding=\"async\" title=\"11-kapatma komutu\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-commande-de-fermeture.png\" sizes=\"auto, \" srcset=\"\" alt=\"close-command\" width=\"549\" height=\"86\"><\/li><li> Sonu\u00e7ta bu makroyu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda bahsetti\u011finiz yola kaydetti\u011finiz metin dosyas\u0131na A1:A13 aral\u0131\u011f\u0131ndaki verileri ekler. <br><img loading=\"lazy\" decoding=\"async\" title=\"12-makroyu \u00e7al\u0131\u015ft\u0131rma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-executer-la-macro.png\" sizes=\"auto, \" srcset=\"\" alt=\"run-the-macro\" width=\"464\" height=\"404\"><\/li><\/ol><p class=\"qt-tip\"> <strong>Not:<\/strong> Sisteminizde bulunan yola g\u00f6re metin dosyas\u0131n\u0131n yolunu koddan de\u011fi\u015ftirdi\u011finizden emin olun.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Option Explicit Sub data_to_text_file() 'variables that you need to use in the code Dim TextFile As Integer Dim iCol As Integer Dim myRange As Range Dim cVal As Range Dim i As Integer Dim myFile As String 'define the range that you want to write Set myRange = Range(\"A1:A13\") iCol = myRange.Count 'path to the text file <strong>(MAKE SURE TO CHANGE IT)<\/strong> myFile = \"C:UsersDellDesktopNewFoldertextfile.txt\" 'define FreeFile to the variable file number TextFile = FreeFile 'using append command to add text to the end of the file Open myFile For Output As TextFile 'loop to add data to the text file For i = 1 To iCol Print #TextFile, Cells(i, 1), Print #TextFile, Cells(i, 2) Next i 'close command to close the text file after adding data Close #TextFile 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\/tr\/vba\/\">VBA nedir<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> \u0130lgili e\u011fitimler <\/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\/tr\/yinelenen-degerleri-vurgula\/\">VBA&#8217;y\u0131 kullanarak yinelenen de\u011ferleri vurgulay\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kopru-baglantisini-cikar\/\">K\u00f6pr\u00fc adresini (URL) VBA&#8217;dan \u00e7\u0131kar\u0131n<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/giris-alani\/\">VBA&#8217;daki giri\u015f kutusu<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/ekran-guncellemesi\/\">VBA Ekran G\u00fcncellemesi<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/durum-cubugu-1\/\">VBA durum \u00e7ubu\u011fu (gizle, g\u00f6ster ve ilerleme)<\/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-2132","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>\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.\" \/>\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\/tr\/metin-dosyalari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:06:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\",\"name\":\"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png\",\"datePublished\":\"2023-09-30T00:09:48+00:00\",\"dateModified\":\"2023-12-10T06:06:19+00:00\",\"description\":\"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba kullanarak bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?","description":"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.","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\/tr\/metin-dosyalari\/","og_locale":"tr_TR","og_type":"article","og_title":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?","og_description":"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:06:19+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"4 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/","url":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/","name":"\u25b7 VBA arac\u0131l\u0131\u011f\u0131yla bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png","datePublished":"2023-09-30T00:09:48+00:00","dateModified":"2023-12-10T06:06:19+00:00","description":"Bu e\u011fitimde bir metin dosyas\u0131n\u0131n nas\u0131l olu\u015fturulaca\u011f\u0131n\u0131 ve daha sonra bu dosyaya iki farkl\u0131 y\u00f6ntem (yazd\u0131rma ve yazma) kullanarak yazmay\u0131 \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-creer-un-fichier-texte-en-utilisant-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/metin-dosyalari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba kullanarak bir metin dosyas\u0131 nas\u0131l olu\u015fturulur ve yaz\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=2132"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2132\/revisions"}],"predecessor-version":[{"id":2863,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/2132\/revisions\/2863"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=2132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}