{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"Excel ve Personal Macro Workbook'ta Otomatik \u0130\u00e7indekiler Olu\u015fturma","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"JOZGPkhi1s\"><a href=\"https:\/\/fatihsoysal.com\/blog\/excel-ve-personal-macro-workbookta-otomatik-icindekiler-olusturma\/\">Excel ve Personal Macro Workbook&#8217;ta Otomatik \u0130\u00e7indekiler Olu\u015fturma<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/excel-ve-personal-macro-workbookta-otomatik-icindekiler-olusturma\/embed\/#?secret=JOZGPkhi1s\" width=\"600\" height=\"338\" title=\"&#8220;Excel ve Personal Macro Workbook&#8217;ta Otomatik \u0130\u00e7indekiler Olu\u015fturma&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"JOZGPkhi1s\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n<\/script>\n","description":"Merhaba, ben Fatih Soysal. Bu makalede, Excel \u00e7al\u0131\u015fma kitaplar\u0131n\u0131zda ve Personal Macro Workbook'unuzda otomatik bir i\u00e7erik olu\u015fturman\u0131n farkl\u0131 yollar\u0131n\u0131 ele alaca\u011f\u0131z. \u00d6ncelikle, manuel y\u00f6ntemlerden ba\u015flayarak, VBA kodlar\u0131yla otomatikle\u015ftirmeye kadar geni\u015f bir yelpazede \u00e7\u00f6z\u00fcmler sunaca\u011f\u0131z. Bu y\u00f6ntemler, uzun ve karma\u015f\u0131k Excel dosyalar\u0131n\u0131z\u0131n gezinmesini kolayla\u015ft\u0131r\u0131p, zamandan tasarruf etmenizi sa\u011flayacakt\u0131r."}