{"id":233,"date":"2016-01-13T00:18:03","date_gmt":"2016-01-12T21:18:03","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=233"},"modified":"2025-02-21T00:18:44","modified_gmt":"2025-02-20T21:18:44","slug":"vba-ile-excel-verisi-refresh-etme-2","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=233","title":{"rendered":"VBA ile Excel Verisi Refresh Etme"},"content":{"rendered":"<p>Baz\u0131 verilerimizi bir ba\u015fka Excel sayfas\u0131ndan alm\u0131\u015f olabiliriz. Bu durumda al\u0131nan veriyi refresh (yenileme) etmek i\u00e7in a\u015fa\u011f\u0131da ki kodu kullanmak \u00e7ok pratik \u00e7\u00f6z\u00fcmler sunabilir.<\/p>\n<div class=\"wp-block-codemirror-blocks code-block \">\n<pre class=\"CodeMirror\" data-setting=\"{&quot;mode&quot;:&quot;vb&quot;,&quot;mime&quot;:&quot;text\/x-vb&quot;,&quot;theme&quot;:&quot;material&quot;,&quot;lineNumbers&quot;:true,&quot;lineWrapping&quot;:false,&quot;styleActiveLine&quot;:false,&quot;readOnly&quot;:true,&quot;align&quot;:&quot;&quot;}\">Sub yenile()\r\nActiveWorkbook.Connections(\"Connection Name\").OLEDBConnection.Refresh\r\nEnd Sub<\/pre>\n<\/div>\n<p>Bu kod, hangi sayfa da olursak olal\u0131m d\u0131\u015f ba\u011flant\u0131n\u0131n yap\u0131ld\u0131\u011f\u0131 sayfa select edilmeden arka planda o veriyi yenileyecektir. Burada \u201cConnection Name\u201d, d\u0131\u015f veriyi ald\u0131\u011f\u0131n\u0131z tablonun ba\u011flant\u0131 ad\u0131d\u0131r. Bunu nas\u0131l elde edece\u011finizi a\u015fa\u011f\u0131da ki videoyu izleyerek \u00f6\u011frenebilirsiniz.<\/p>\n<p>Kolay gele&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Baz\u0131 verilerimizi bir ba\u015fka Excel sayfas\u0131ndan alm\u0131\u015f olabiliriz. Bu durumda al\u0131nan veriyi refresh (yenileme) etmek i\u00e7in a\u015fa\u011f\u0131da ki kodu kullanmak \u00e7ok pratik \u00e7\u00f6z\u00fcmler sunabilir. Sub yenile() ActiveWorkbook.Connections(&#8220;Connection Name&#8221;).OLEDBConnection.Refresh End Sub&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"http:\/\/www.cuneytbayrak.com\/?p=233\">Devam\u0131n\u0131 Oku<span class=\"screen-reader-text\">VBA ile Excel Verisi Refresh Etme<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":7,"footnotes":""},"categories":[5],"tags":[76],"class_list":["post-233","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-refreshdata","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=233"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/233\/revisions"}],"predecessor-version":[{"id":236,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/233\/revisions\/236"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=233"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}