{"id":4470,"date":"2023-07-10T21:08:23","date_gmt":"2023-07-10T21:08:23","guid":{"rendered":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/"},"modified":"2023-07-10T21:08:23","modified_gmt":"2023-07-10T21:08:23","slug":"vba-calisma-kitabini-kaydet-ve-kapat","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/","title":{"rendered":"Vba: \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydetmek ve kapatmak i\u00e7in VBA&#8217;da a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubSaveClose<\/span> ()\n\nActiveWorkbook.Close_\nSaveChanges:=True, _\nFilename:=\" <span style=\"color: #ff0000;\">C:\\Users\\bob\\Desktop\\MyExcelFile.xlsx<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Bu \u00f6zel makro, \u015fu anda etkin olan \u00e7al\u0131\u015fma kitab\u0131ndaki en son de\u011fi\u015fiklikleri kaydedecek ve ard\u0131ndan onu kapatacakt\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Dosya ad\u0131<\/strong> deyimi \u00e7al\u0131\u015fma kitab\u0131n\u0131n nereye kaydedilece\u011fini belirtir.<\/span><\/p>\n<p> <span style=\"color: #000000;\">\u00c7al\u0131\u015fma kitab\u0131n\u0131 kapatmadan \u00f6nce de\u011fi\u015fiklikleri kaydetmek <em>istemiyorsan\u0131z<\/em> bunun yerine <strong>SaveChanges:=False<\/strong> ifadesini kullanabilece\u011finizi unutmay\u0131n.<\/span><\/p>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki \u00f6rnek, bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>\u00d6rnek: VBA Kullanarak \u00c7al\u0131\u015fma Kitab\u0131n\u0131 Kaydetme ve Kapatma<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Diyelim ki a\u015fa\u011f\u0131daki Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7t\u0131k ve onu g\u00f6r\u00fcnt\u00fcl\u00fcyoruz:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34574 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poste1.jpg\" alt=\"\" width=\"492\" height=\"387\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Diyelim ki bu \u00e7al\u0131\u015fma kitab\u0131nda yapt\u0131\u011f\u0131m\u0131z en son de\u011fi\u015fiklikleri kaydetmek ve ard\u0131ndan bunlar\u0131 masa\u00fcst\u00fcm\u00fcze kaydetmek istiyoruz.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Bunun i\u00e7in a\u015fa\u011f\u0131daki makroyu olu\u015fturabiliriz:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubSaveClose<\/span> ()\n\nActiveWorkbook.Close_\nSaveChanges:=True, _\nFilename:=\" <span style=\"color: #ff0000;\">C:\\Users\\bob\\Desktop\\MyExcelFile.xlsx<\/span> \"\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Bu makro \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131ktan sonra en son de\u011fi\u015fiklikler kaydedilir ve \u00e7al\u0131\u015fma kitab\u0131 otomatik olarak kapat\u0131l\u0131r.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Daha sonra bilgisayar\u0131m\u0131n masa\u00fcst\u00fcne gidebilir ve kay\u0131tl\u0131 Excel \u00e7al\u0131\u015fma kitab\u0131n\u0131 bulabilirim:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34976 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fermer1.png\" alt=\"\" width=\"566\" height=\"473\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">\u00c7al\u0131\u015fma kitab\u0131, <strong>Filename<\/strong> deyimini kullanarak belirtti\u011fimiz gibi <strong>MyExcelFile.xlsx<\/strong> olarak kaydedildi.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Not<\/strong> : VBA&#8217;da <strong>Workbook.Close<\/strong> y\u00f6nteminin t\u00fcm belgelerini <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.workbook.close\" target=\"_blank\" rel=\"noopener\">burada<\/a> bulabilirsiniz.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Ek kaynaklar<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">A\u015fa\u011f\u0131daki e\u011fitimlerde VBA&#8217;da di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/tr\/vba-sayfa-sayisi\/\" target=\"_blank\" rel=\"noopener\">VBA: Bir \u00e7al\u0131\u015fma kitab\u0131ndaki sayfalar\u0131n say\u0131s\u0131 nas\u0131l say\u0131l\u0131r?<\/a><br \/> VBA: Ba\u015fka bir \u00e7al\u0131\u015fma kitab\u0131ndan veri nas\u0131l \u00e7\u0131kar\u0131l\u0131r<br \/> <a href=\"https:\/\/statorials.org\/tr\/vba-ekleme-sayfasi\/\" target=\"_blank\" rel=\"noopener\">VBA: Yeni sayfalar nas\u0131l eklenir<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydetmek ve kapatmak i\u00e7in VBA&#8217;da a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabilirsiniz: SubSaveClose () ActiveWorkbook.Close_ SaveChanges:=True, _ Filename:=&#8221; C:\\Users\\bob\\Desktop\\MyExcelFile.xlsx &#8221; End Sub Bu \u00f6zel makro, \u015fu anda etkin olan \u00e7al\u0131\u015fma kitab\u0131ndaki en son de\u011fi\u015fiklikleri kaydedecek ve ard\u0131ndan onu kapatacakt\u0131r. Dosya ad\u0131 deyimi \u00e7al\u0131\u015fma kitab\u0131n\u0131n nereye kaydedilece\u011fini belirtir. \u00c7al\u0131\u015fma kitab\u0131n\u0131 kapatmadan \u00f6nce de\u011fi\u015fiklikleri kaydetmek istemiyorsan\u0131z bunun yerine [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4470","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T21:08:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poste1.jpg\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/\",\"url\":\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/\",\"name\":\"VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/tr\/#website\"},\"datePublished\":\"2023-07-10T21:08:23+00:00\",\"dateModified\":\"2023-07-10T21:08:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\"},\"description\":\"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/statorials.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/tr\/#website\",\"url\":\"https:\/\/statorials.org\/tr\/\",\"name\":\"Statorials\",\"description\":\"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/tr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil\",\"sameAs\":[\"https:\/\/statorials.org\/tr\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials","description":"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","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:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials","og_description":"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","og_url":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/","og_site_name":"Statorials","article_published_time":"2023-07-10T21:08:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/poste1.jpg"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Dr.benjamin anderson","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/","url":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/","name":"VBA: Bir \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/tr\/#website"},"datePublished":"2023-07-10T21:08:23+00:00","dateModified":"2023-07-10T21:08:23+00:00","author":{"@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48"},"description":"Bu e\u011fitimde VBA kullanarak bir \u00e7al\u0131\u015fma kitab\u0131n\u0131n nas\u0131l kaydedilip kapat\u0131laca\u011f\u0131 bir \u00f6rnekle a\u00e7\u0131klanmaktad\u0131r.","breadcrumb":{"@id":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/tr\/vba-calisma-kitabini-kaydet-ve-kapat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/statorials.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba: \u00e7al\u0131\u015fma kitab\u0131 nas\u0131l kaydedilir ve kapat\u0131l\u0131r (\u00f6rnekle)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/tr\/#website","url":"https:\/\/statorials.org\/tr\/","name":"Statorials","description":"\u0130statistik okuryazarl\u0131\u011f\u0131 rehberiniz!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/tr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/365dc158a39a7c8ae256355451e3de48","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/statorials.org\/tr\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/tr\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Merhaba, ben Benjamin, emekli bir istatistik profes\u00f6r\u00fc ve Statorials \u00f6\u011fretmenine d\u00f6n\u00fc\u015ft\u00fcm. \u0130statistik alan\u0131ndaki kapsaml\u0131 deneyimim ve uzmanl\u0131\u011f\u0131mla, \u00f6\u011frencilerimi Statorials arac\u0131l\u0131\u011f\u0131yla g\u00fc\u00e7lendirmek i\u00e7in bilgilerimi payla\u015fmaya can at\u0131yorum. Daha fazlas\u0131n\u0131 bil","sameAs":["https:\/\/statorials.org\/tr"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4470","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/comments?post=4470"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/posts\/4470\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/media?parent=4470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/categories?post=4470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/tr\/wp-json\/wp\/v2\/tags?post=4470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}