{"id":1660,"date":"2023-11-12T18:40:04","date_gmt":"2023-11-12T18:40:04","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/baglayici\/"},"modified":"2023-12-10T06:07:35","modified_gmt":"2023-12-10T06:07:35","slug":"baglayici","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/baglayici\/","title":{"rendered":"Vba&#39;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015fma k\u0131lavuzu"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-741352416\"><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>Excel&#8217;de \u00e7al\u0131\u015fma kitab\u0131, t\u00fcm Excel nesneleri aras\u0131nda en \u00f6nemlilerinden biridir ve VBA kodlar\u0131 yazarken \u00e7al\u0131\u015fma kitaplar\u0131n\u0131n nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 ve \u00e7al\u0131\u015fma kitaplar\u0131na nas\u0131l ba\u015fvurulaca\u011f\u0131n\u0131 anlamak da \u00f6nemlidir.<\/p><p> Bu e\u011fitimde bilmeniz gereken her \u015feyi ke\u015ffedece\u011fiz. Ancak anlaman\u0131z gereken ilk \u015fey, VBA&#8217;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015f\u0131rken yer alan nesnelerdir.<\/p><p> Bilinecek \u015feyler:<\/p><ul><li> Ba\u011flay\u0131c\u0131 nesne<\/li><li> Ba\u011flay\u0131c\u0131 nesne<\/li><\/ul><p> Bu iki nesne kula\u011fa ayn\u0131 geliyor ancak ikisi aras\u0131nda temel bir fark var.<\/p><h2 id=\"t-1596274639137\" class=\"wp-block-heading\"> Ba\u011flay\u0131c\u0131 nesne<\/h2><p> VBA&#8217;da \u00c7al\u0131\u015fma Kitaplar\u0131 nesnesi, Microsoft Excel&#8217;de a\u00e7\u0131lan <strong><span style=\"font-family: inherit; background-color: #fff44f;\">\u00e7al\u0131\u015fma kitaplar\u0131n\u0131n koleksiyonunu<\/span><\/strong> temsil eder. Ayn\u0131 anda on dosya dolab\u0131n\u0131z\u0131n a\u00e7\u0131k oldu\u011funu hayal edin. Ve aralar\u0131ndaki tek \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurmak istiyorsunuz. Bu durumda, bu \u00e7al\u0131\u015fma kitab\u0131na ad\u0131n\u0131 kullanarak ba\u015fvurmak i\u00e7in \u00e7al\u0131\u015fma kitab\u0131 nesnesini kullanman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"1-vba-\u00e7al\u0131\u015fma kitaplar\u0131-nesnesi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba workbooks object\" width=\"387\" height=\"174\"><\/figure><\/div><h2 id=\"t-1596274639138\" class=\"wp-block-heading\"> Ba\u011flay\u0131c\u0131 nesne<\/h2><p> <span data-preserver-spaces=\"true\">VBA&#8217;da \u00e7al\u0131\u015fma kitab\u0131 nesnesi,<\/span> <span data-preserver-spaces=\"true\">\u015fu anda Microsoft Excel&#8217;de a\u00e7\u0131k olan<\/span> <strong><span style=\"background-color: #fff44f;\" data-preserver-spaces=\"true\">t\u00fcm \u00e7al\u0131\u015fma kitaplar\u0131 aras\u0131nda tek bir \u00e7al\u0131\u015fma kitab\u0131n\u0131<\/span><\/strong> temsil eder. <span data-preserver-spaces=\"true\">Bunu anlaman\u0131n en iyi yolu, koddaki belirli bir ba\u011flay\u0131c\u0131ya at\u0131fta bulunmak i\u00e7in kullanmak istedi\u011finiz bir de\u011fi\u015fkeni ba\u011flay\u0131c\u0131 olarak bildirmeyi d\u00fc\u015f\u00fcnmektir.<\/span> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"2-tek-bir-\u00e7al\u0131\u015fma kitab\u0131n\u0131 temsil eder\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-represente-un-seul-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"represents one single workbook\" width=\"337\" height=\"201\"><\/figure><\/div><p class=\"content-box-green\"> <strong>Yararl\u0131 ba\u011flant\u0131lar<\/strong> : <a href=\"https:\/\/exceladvisor.org\/tr\/gelistirici-sekmesi-ekle\/\">Geli\u015ftirici sekmesi ekleyin<\/a> | <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/temel-gorsel-duzenleyici\/\">Visual Basic D\u00fczenleyicisi<\/a> | <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/makro-2yi-calistir\/\">Makro \u00e7al\u0131\u015ft\u0131rma<\/a> | <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/kisisel-makro-not-defteri\/\">Ki\u015fisel Makrolar \u00c7al\u0131\u015fma Kitab\u0131<\/a><\/p><h2 id=\"t-1596274639139\" class=\"wp-block-heading\"> VBA&#8217;daki bir \u00e7al\u0131\u015fma kitab\u0131na bak\u0131n<\/h2><p> VBA&#8217;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015fmak i\u00e7in bilmeniz gereken ilk \u015fey, bir makrodaki \u00e7al\u0131\u015fma kitab\u0131na nas\u0131l ba\u015fvurulaca\u011f\u0131d\u0131r. \u0130\u015fte mutlu olan \u015fey: Bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurman\u0131n birden fazla yolu var. Ve gelecekte her birini ke\u015ffedece\u011fiz.<\/p><h3 id=\"t-1596274639140\" class=\"wp-block-heading\"> 1. \u0130sme g\u00f6re<\/h3><p> Bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurman\u0131n en kolay yolu, ad\u0131n\u0131 kullanmakt\u0131r. Diyelim ki Book1.xlsx \u00e7al\u0131\u015fma kitab\u0131n\u0131 aktifle\u015ftirmek istiyorsunuz, bu durumda kullanman\u0131z gereken kod \u015fu \u015fekilde olmal\u0131: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"3-vba'da-bir-\u00e7al\u0131\u015fma kitab\u0131na-ad\u0131na-bak\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-faire-reference-a-un-classeur-dans-vba-par-son-nom.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer to a workbook in vba by name\" width=\"426\" height=\"192\"><\/figure><\/div><p> Bir \u00e7al\u0131\u015fma kitab\u0131na ad\u0131yla ba\u015fvurmak olduk\u00e7a basittir, ad\u0131 belirtmeniz gerekir, hepsi bu. Ancak <strong>dikkat etmeniz gereken bir \u015fey<\/strong> var: \u00c7al\u0131\u015fma kitab\u0131 kaydedilmemi\u015fse yaln\u0131zca ad\u0131n\u0131 kullanman\u0131z gerekir. Kay\u0131tl\u0131ysa, ad\u0131 uzant\u0131yla birlikte kullanman\u0131z gerekir.<\/p><h3 id=\"t-1596274639141\" class=\"wp-block-heading\"> 2. Numaraya g\u00f6re<\/h3><p> Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 a\u00e7t\u0131\u011f\u0131n\u0131zda, Excel bu \u00e7al\u0131\u015fma kitab\u0131na bir dizin numaras\u0131 atar ve bu numaray\u0131 bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurmak i\u00e7in kullanabilirsiniz. \u0130lk a\u00e7t\u0131\u011f\u0131n\u0131z \u00e7al\u0131\u015fma kitab\u0131nda dizin numaras\u0131 \u201c1\u201d, ikincisinde \u201c2\u201d vb. olacakt\u0131r. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"4-vba-numaras\u0131-bir-\u00e7al\u0131\u015fma kitab\u0131na-bak\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-faire-reference-a-un-classeur-dans-vba-par-numero.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer to a workbook in vba b number\" width=\"340\" height=\"193\"><\/figure><\/div><p> Bu y\u00f6ntem size daha az ger\u00e7ek\u00e7i gelebilir \u00e7\u00fcnk\u00fc hangi \u00e7al\u0131\u015fma kitab\u0131n\u0131n hangi dizin numaras\u0131nda oldu\u011funu bilmek zordur. Ancak bu y\u00f6ntemin kullan\u0131m\u0131n\u0131n \u00e7ok yararl\u0131 oldu\u011fu bir durum vard\u0131r ve bu, t\u00fcm a\u00e7\u0131k \u00e7al\u0131\u015fma kitaplar\u0131nda bir d\u00f6ng\u00fcd\u00fcr.<\/p><h3 id=\"t-1596274639142\" class=\"wp-block-heading\"> 3. ThisWorkbook&#8217;a g\u00f6re<\/h3><p> Bu \u00e7al\u0131\u015fma kitab\u0131, kod yazd\u0131\u011f\u0131n\u0131z \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurman\u0131za yard\u0131mc\u0131 olan bir \u00f6zelliktir. Diyelim ki &#8220;Kitap1&#8221; i\u00e7erisine kodu yazd\u0131n\u0131z ve \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydetmek i\u00e7in ThisWorkbook&#8217;u kulland\u0131n\u0131z. Art\u0131k \u00e7al\u0131\u015fma kitab\u0131n\u0131n ad\u0131n\u0131 de\u011fi\u015ftirseniz bile kodu de\u011fi\u015ftirmenize gerek kalmayacak. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"5-bu-\u00e7al\u0131\u015fma kitab\u0131yla vba'daki bir \u00e7al\u0131\u015fma kitab\u0131na bak\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-faire-reference-a-un-classeur-dans-vba-par-thisworkbook.png\" sizes=\"auto, \" srcset=\"\" alt=\"refer to a workbook in vba by this workbook\" width=\"417\" height=\"196\"><\/figure><\/div><p> Yukar\u0131daki kod, \u00e7al\u0131\u015fma kitab\u0131nda bu kodun yaz\u0131ld\u0131\u011f\u0131 <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/yapraklari-say\/\">sayfa say\u0131s\u0131n\u0131 sayar<\/a> ve sonucu i\u00e7eren <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/vba-mesaj-kutusu\/\">bir mesaj kutusu g\u00f6r\u00fcnt\u00fcler<\/a> .<\/p><h3 id=\"t-1596274639143\" class=\"wp-block-heading\"> 4. ActiveWorkbook&#8217;a g\u00f6re<\/h3><p> Etkin bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvuruda bulunmak istiyorsan\u0131z &#8220;ActiveWorkbook&#8221; \u00f6zelli\u011fini kullanman\u0131z gerekir. Bu \u00f6zelli\u011fin en iyi kullan\u0131m\u0131, \u015fu anda hangi \u00e7al\u0131\u015fma kitab\u0131n\u0131n etkinle\u015ftirildi\u011finden emin oldu\u011funuz zamand\u0131r. Veya \u00fczerinde \u00e7al\u0131\u015fmak istedi\u011finiz \u00e7al\u0131\u015fma kitab\u0131n\u0131 zaten etkinle\u015ftirmi\u015fsinizdir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"Aktif ba\u011flay\u0131c\u0131 ba\u015f\u0131na 6\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-par-classeur-actif.png\" sizes=\"auto, \" srcset=\"\" alt=\"by active workbook\" width=\"359\" height=\"218\"><\/figure><\/div><p> Yukar\u0131daki kod \u00f6nce &#8220;Kitap1&#8221; \u00e7al\u0131\u015fma kitab\u0131n\u0131 etkinle\u015ftirir, ard\u0131ndan etkin \u00e7al\u0131\u015fma kitab\u0131n\u0131 kaydedip kapatmak i\u00e7in etkin \u00e7al\u0131\u015fma kitab\u0131 \u00f6zelli\u011fini kullan\u0131r.<\/p><h2 id=\"t-1596274639145\" class=\"wp-block-heading\"> T\u00fcm y\u00f6ntemlere ve \u00f6zelliklere eri\u015fin<\/h2><p> VBA&#8217;da bir nesneye ba\u015fvurdu\u011funuzda, VBA o nesneyle sa\u011flanan \u00f6zelliklere ve y\u00f6ntemlere eri\u015fmenizi sa\u011flar. Benzer \u015fekilde, \u00e7al\u0131\u015fma kitab\u0131 nesnesi de \u00f6zellikler ve y\u00f6ntemlerle birlikte gelir. Eri\u015fmek i\u00e7in \u00f6nce \u00e7al\u0131\u015fma kitab\u0131n\u0131 tan\u0131mlaman\u0131z, ard\u0131ndan <strong><span style=\"background-color: #fff44f;\">bir nokta girmeniz<\/span><\/strong> gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"7-\u00e7al\u0131\u015fma kitab\u0131n\u0131-\u00f6ncelikle-ve-bir-noktay\u0131-girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-definissez-dabord-le-classeur-et-entrez-un-point.png\" sizes=\"auto, \" srcset=\"\" alt=\"define the workbook first and enter a dot\" width=\"487\" height=\"241\"><\/figure><\/div><p> Nokta (.) yazd\u0131\u011f\u0131n\u0131z anda, \u00f6zelliklerin ve y\u00f6ntemlerin listesi g\u00f6r\u00fcnt\u00fclenir. \u015eimdi hangisinin \u00f6zellik, hangisinin y\u00f6ntem oldu\u011funu nas\u0131l belirleyece\u011finiz konusunda bir sorunuz olmal\u0131.<\/p><p> <strong>\u0130\u015fin p\u00fcf noktas\u0131 burada.<\/strong> Yak\u0131ndan bakarsan\u0131z, listedeki her ismin \u00f6n\u00fcnde hareket eden ye\u015fil bir tu\u011fla ve gri bir el g\u00f6rebilirsiniz. Yani t\u00fcm \u00f6zelliklerin ad\u0131ndan \u00f6nce bu gri el bulunur ve y\u00f6ntemlerin hareketli ye\u015fil bir tu\u011flas\u0131 vard\u0131r.<\/p><h3 id=\"t-1596274639146\" class=\"wp-block-heading\"> \u00d6rne\u011fin, bir y\u00f6ntemi \u00e7al\u0131\u015fma kitab\u0131yla kullanmak i\u00e7in<\/h3><p> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-kapat\/\">Bir \u00e7al\u0131\u015fma kitab\u0131n\u0131 kapatmak<\/a> istedi\u011finizi d\u00fc\u015f\u00fcn\u00fcn (bu bir y\u00f6ntemdir), listeden &#8220;Kapat&#8221; yazman\u0131z veya se\u00e7meniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"8-listede-yak\u0131n-se\u00e7im\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-selectionner-fermer-dans-une-liste.png\" sizes=\"auto, \" srcset=\"\" alt=\"select close from a list\" width=\"385\" height=\"269\"><\/figure><\/div><p> Bundan sonra, IntelliSense&#8217;in hangi ba\u011f\u0131ms\u0131z de\u011fi\u015fkenleri ayarlaman\u0131z gerekti\u011fini bilmesi i\u00e7in ba\u015flang\u0131\u00e7 parantezlerini girmeniz gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"9-ba\u015flang\u0131\u00e7-parantezlerini girin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-entrez-les-parentheses-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter starting parentheses\" width=\"622\" height=\"267\"><\/figure><\/div><p> Close y\u00f6ntemiyle \u00fc\u00e7 arg\u00fcman tan\u0131mlaman\u0131z gerekir ve g\u00f6rebilece\u011finiz gibi t\u00fcm bu arg\u00fcmanlar iste\u011fe ba\u011fl\u0131d\u0131r ve isterseniz bunlar\u0131 yok sayabilirsiniz. Ancak baz\u0131 y\u00f6ntemlerin hi\u00e7bir arg\u00fcman\u0131 yoktur (\u00f6rne\u011fin: active)<\/p><h3 id=\"t-1596274639147\" class=\"wp-block-heading\"> \u00d6rne\u011fin, bir \u00f6zelli\u011fi \u00e7al\u0131\u015fma kitab\u0131yla birlikte kullanmak i\u00e7in<\/h3><p> \u201cKitap1\u201d \u00e7al\u0131\u015fma kitab\u0131n\u0131n sayfalar\u0131n\u0131 saymak istedi\u011finizi d\u00fc\u015f\u00fcn\u00fcn. Bu durumda &#8220;E-Tablolar&#8221; \u00f6zelli\u011fini ve ard\u0131ndan bunun ek count \u00f6zelli\u011fini kullanman\u0131z gerekir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"10-yaprak \u00f6zelli\u011fini kullan\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-utiliser-la-propriete-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"use the sheets property\" width=\"501\" height=\"307\"><\/figure><\/div><p> Yukar\u0131daki kodda, s\u00f6yledi\u011fim gibi, kitap1&#8217;i ayarlars\u0131n\u0131z, ard\u0131ndan sayfa \u00f6zelli\u011fi t\u00fcm sayfalar\u0131 ifade eder, sonra da bunlar\u0131 saymak i\u00e7in count \u00f6zelli\u011fi. Ve bu kodu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda size sonucu i\u00e7eren bir mesaj kutusu g\u00f6sterir.<\/p><h2 id=\"t-1596274639148\" class=\"wp-block-heading\"> \u00c7al\u0131\u015fma kitab\u0131nda \u201cWITH\u201d ifadesini kullanma<\/h2><p> VBA&#8217;da, verimli bir \u015fekilde makro yazarken \u00e7al\u0131\u015fma kitab\u0131yla \u00e7al\u0131\u015fman\u0131za yard\u0131mc\u0131 olabilecek bir &#8220;With&#8221; ifadesi vard\u0131r. Ayn\u0131 \u00e7al\u0131\u015fma kitab\u0131na, yani ActiveWorkbook&#8217;a sahip \u00fc\u00e7 farkl\u0131 kod sat\u0131r\u0131n\u0131z\u0131n oldu\u011fu a\u015fa\u011f\u0131daki \u00f6rne\u011fi g\u00f6relim. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"11-talimatla-ba\u011flay\u0131c\u0131yla-kullan\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-utilisation-avec-instruction-avec-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"using with statement with workbook\" width=\"700\" height=\"250\"><\/figure><\/div><p> &#8220;WITH&#8221; ifadesi ile aktif \u00e7al\u0131\u015fma kitab\u0131na yaln\u0131zca bir kez ba\u015fvurabilir ve kodda bulunan t\u00fcm \u00f6zellik ve y\u00f6ntemleri kullanabilirsiniz.<\/p><ul><li> \u00d6ncelikle \u201cWith ActiveWorkbook\u201d ba\u015flang\u0131\u00e7 ifadesiyle ba\u015flaman\u0131z ve ifadeyi \u201cEnd With\u201d ile bitirmeniz gerekiyor. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"12-ba\u015flang\u0131\u00e7-ifadesiyle-ba\u015flay\u0131n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-commencer-par-la-declaration-de-depart.png\" sizes=\"auto, \" srcset=\"\" alt=\"start with the starting statement\" width=\"397\" height=\"370\"><\/figure><\/div><ul><li> Daha sonra yukar\u0131daki \u00f6rnekte yer alan kodu bu ifadenin aras\u0131na yazman\u0131z gerekmektedir. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"13-talimatlar aras\u0131nda-kod yazma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-ecrire-le-code-entre-la-declaration.png\" sizes=\"auto, \" srcset=\"\" alt=\"write the code between the statement\" width=\"731\" height=\"364\"><\/figure><\/div><p> Yukar\u0131daki kodda g\u00f6rebilece\u011finiz gibi, With ifadesini kullanarak ActiveWorkbook&#8217;unkine de\u011findik ve ard\u0131ndan t\u00fcm \u00f6zellik ve y\u00f6ntemlerin kullan\u0131lmas\u0131 gerekiyor.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_activeworkbook_with_statement() With ActiveWorkbook .Sheets.Add Count:=5 .Charts.Visible = False .SaveAs (\"C:UsersDellDesktopmyFolderbook2.xlsx\") End With End Sub<\/code><\/pre><p style=\"font-size: 26px;\"> <em>Her \u015feyi anlaman\u0131z i\u00e7in size <strong><span class=\"has-inline-color\" style=\"color: #ff5757;\">basit ve somut bir \u00f6rnek<\/span><\/strong> vereyim. Benden su \u015fi\u015fesini almak i\u00e7in 215 numaral\u0131 odaya gitmemi istedi\u011finizi ve geri d\u00f6nd\u00fc\u011f\u00fcmde beni kalem almak i\u00e7in tekrar 215 numaral\u0131 odaya g\u00f6nderdi\u011finizi, sonra da diz\u00fcst\u00fc bilgisayar almam i\u00e7in tekrar g\u00f6nderdi\u011finizi hayal edin. \u015eimdi olay \u015fu: bana almam\u0131 s\u00f6yledi\u011fin her \u015fey 215 numaral\u0131 odada. Beni 215 numaral\u0131 odaya g\u00f6nderip \u00fc\u00e7 \u015feyi ayn\u0131 anda almam\u0131 s\u00f6ylesen daha iyi olur.<\/em><\/p><p class=\"content-box-green\"> <strong>Okuyun:<\/strong> <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/tr\/ile\/\">\u0130le \u2013 \u015eununla bitirin<\/a><\/p><h2 id=\"t-1596274639149\" class=\"wp-block-heading\"> Bir de\u011fi\u015fkeni \u00e7al\u0131\u015fma kitab\u0131 olarak bildirme<\/h2><p> Bazen bir de\u011fi\u015fkeni kodda daha fazla kullanmak i\u00e7in ba\u011flay\u0131c\u0131 olarak bildirmeniz gerekir. Senden \u00f6zel bir \u015fey gerektirmiyor. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"14-ba\u011flay\u0131c\u0131 olarak-de\u011fi\u015fken beyan\u0131\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-declarer-la-variable-comme-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"declare variable as workbook\" width=\"381\" height=\"319\"><\/figure><\/div><ol><li> DIM (beyan) ifadesini kullan\u0131n.<\/li><li> De\u011fi\u015fken ad\u0131n\u0131 yaz\u0131n.<\/li><li> De\u011fi\u015fken t\u00fcr\u00fcn\u00fc \u00c7al\u0131\u015fma Kitab\u0131 olarak ayarlay\u0131n.<\/li><\/ol><h2 id=\"t-1596274639150\" class=\"wp-block-heading\"> Hatalarla ba\u015f etmek<\/h2><p> VBA&#8217;da bir veya daha fazla \u00e7al\u0131\u015fma kitab\u0131 nesnesiyle \u00e7al\u0131\u015f\u0131rken hatalar\u0131 da i\u015flemeniz gerekebilir. <strong><span style=\"color: #ff5757;\">\u201c\u00c7al\u0131\u015fma zaman\u0131 hatas\u0131 9: Dizin aral\u0131k d\u0131\u015f\u0131\u201d hatas\u0131na<\/span><\/strong> bir \u00f6rnek verelim. Bu hata \u00e7e\u015fitli nedenlerle ortaya \u00e7\u0131kabilir.<\/p><ul><li> Ba\u015fvurmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z \u00e7al\u0131\u015fma kitab\u0131 a\u00e7\u0131k de\u011fil.<\/li><li> Belki ad\u0131n\u0131 yanl\u0131\u015f yazd\u0131n\u0131z.<\/li><li> Bahsetti\u011finiz \u00e7al\u0131\u015fma kitab\u0131 hen\u00fcz kaydedilmedi ve ad\u0131 ta\u015f\u0131yan uzant\u0131y\u0131 kullan\u0131yorsunuz.<\/li><li> Bir \u00e7al\u0131\u015fma kitab\u0131na ba\u015fvurmak i\u00e7in dizin numaras\u0131n\u0131 kullan\u0131yorsan\u0131z ve kulland\u0131\u011f\u0131n\u0131z say\u0131, a\u00e7\u0131k \u00e7al\u0131\u015fma kitaplar\u0131n\u0131n toplam say\u0131s\u0131ndan b\u00fcy\u00fckse.<\/li><\/ul><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\/excel-dosyasini-kopyala\/\">VBA kullanarak bir Excel dosyas\u0131n\u0131 (\u00e7al\u0131\u015fma kitab\u0131n\u0131) kopyalama<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-etkinlestir\/\">VBA \u00c7al\u0131\u015fma Kitab\u0131n\u0131 Etkinle\u015ftir (Excel Dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabini-kapat\/\">VBA \u00c7al\u0131\u015fma kitab\u0131n\u0131 kapat (Excel dosyas\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitaplarini-birlestir\/\">VBA \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Birle\u015ftir (Excel Dosyalar\u0131)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/calisma-kitabi-olustur\/\">VBA Yeni bir \u00e7al\u0131\u015fma kitab\u0131 olu\u015fturun (Excel dosyas\u0131)<\/a><\/li><\/ul><\/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-1660","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>VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#039;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \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\/baglayici\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#039;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/baglayici\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:07:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-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=\"7 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/\",\"name\":\"VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#39;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png\",\"datePublished\":\"2023-11-12T18:40:04+00:00\",\"dateModified\":\"2023-12-10T06:07:35+00:00\",\"description\":\"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/baglayici\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/baglayici\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba&#39;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015fma k\u0131lavuzu\"}]},{\"@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":"VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#39;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu","description":"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \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\/baglayici\/","og_locale":"tr_TR","og_type":"article","og_title":"VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#39;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu","og_description":"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/baglayici\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:07:35+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tahmini okuma s\u00fcresi":"7 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/","url":"https:\/\/exceladvisor.org\/tr\/baglayici\/","name":"VBA \u00c7al\u0131\u015fma Kitab\u0131 \u2013 VBA&#39;da \u00c7al\u0131\u015fma Kitaplar\u0131n\u0131 Kullanma K\u0131lavuzu","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png","datePublished":"2023-11-12T18:40:04+00:00","dateModified":"2023-12-10T06:07:35+00:00","description":"Bu e\u011fitim, VBA kullanarak \u00e7al\u0131\u015fma kitaplar\u0131yla nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131z\u0131 anlaman\u0131za yard\u0131mc\u0131 olur. \u00c7al\u0131\u015fma kitaplar\u0131n\u0131n amac\u0131n\u0131 ve en \u00f6nemli \u00f6zelliklerini ve y\u00f6ntemlerini \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/baglayici\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-objet-de-classeurs-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/tr\/baglayici\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Vba&#39;da \u00e7al\u0131\u015fma kitaplar\u0131yla \u00e7al\u0131\u015fma k\u0131lavuzu"}]},{"@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\/1660","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=1660"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1660\/revisions"}],"predecessor-version":[{"id":2939,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1660\/revisions\/2939"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}