{"id":239,"date":"2015-12-10T00:23:04","date_gmt":"2015-12-09T21:23:04","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=239"},"modified":"2025-02-21T00:23:37","modified_gmt":"2025-02-20T21:23:37","slug":"vba-ile-sql-verisi-yenileme","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=239","title":{"rendered":"VBA ile SQL Verisi Yenileme"},"content":{"rendered":"

Bir \u00e7o\u011funuz excele d\u0131\u015far\u0131dan ald\u0131\u011f\u0131 verileri refresh (yenileme) etmede sorunlar ya\u015fam\u0131\u015ft\u0131r. Bende bu anlamda \u00e7ok sorunlar ya\u015fad\u0131m. Burada bahsi ge\u00e7en sorun d\u0131\u015f verinin oldu\u011fu sayfa select olmadan veriyi yenilemek.<\/p>\n

\n
Sub yenile()\r\nSheets(\"Sayfa2\").Select\r\nRange(\"A1\").Select\r\nSelection.ListObject.QueryTable.Refresh BackgroundQuery:=False\r\nEnd Sub<\/pre>\n<\/div>\n
Yukar\u0131da ki kod d\u0131\u015f verinin oldu\u011fu sayfay\u0131 select ederek veriyi yeniler. O an \u00fczerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131z sayfadan ayr\u0131lmak istemeyebilirsiniz. Akla ilk gelen \u00e7\u00f6z\u00fcm veri yenilendikten sonra \u00e7al\u0131\u015fmak istenilen sayfan\u0131n tekrar select edilmesi olsa da, bu durum baz\u0131 zamanlar ba\u015f\u0131n\u0131z\u0131 a\u011fr\u0131tabilir.<\/p>\n
\n
Sub yenile()\r\nSheets(\"Sayfa2\").Select\r\nRange(\"A1\").Select\r\nSelection.ListObject.QueryTable.Refresh BackgroundQuery:=False\r\nSheets(\"Sayfa1\").Select\r\nEnd Sub<\/pre>\n<\/div>\n
\u00d6rne\u011fin yukar\u0131da ki gibi bir kod yazmak Sayfa1\u2019in Activate Event\u2019\u0131na olas\u0131 yaz\u0131lan kodlar y\u00fcz\u00fcnden sonsuz d\u00f6ng\u00fc olu\u015fturacakt\u0131r. \u0130\u015fte tam bu noktada problem ortaya \u00e7\u0131kmaktad\u0131r. Bunun \u00e7\u00f6z\u00fcm\u00fc ise a\u015fa\u011f\u0131da ki gibi bir kod yazmak olacakt\u0131r.<\/p>\n
\n
Sub yenile()\r\nActiveWorkbook.Connections(\"CONNECTION_NAME\").Refresh\r\nEnd Sub<\/pre>\n<\/div>\n
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
Kolay gele\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"
Bir \u00e7o\u011funuz excele d\u0131\u015far\u0131dan ald\u0131\u011f\u0131 verileri refresh (yenileme) etmede sorunlar ya\u015fam\u0131\u015ft\u0131r. Bende bu anlamda \u00e7ok sorunlar ya\u015fad\u0131m. Burada bahsi ge\u00e7en sorun d\u0131\u015f verinin oldu\u011fu sayfa select olmadan veriyi yenilemek. Sub…<\/p>\n
Devam\u0131n\u0131 OkuVBA ile SQL Verisi Yenileme<\/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":1,"footnotes":""},"categories":[5],"tags":[79],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-excel-vba","tag-sqlrefresh","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/239","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=239"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"predecessor-version":[{"id":241,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions\/241"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}