{"id":201,"date":"2013-03-09T15:59:27","date_gmt":"2013-03-09T13:59:27","guid":{"rendered":"http:\/\/wintrscada.com\/?p=201"},"modified":"2021-12-18T13:30:53","modified_gmt":"2021-12-18T11:30:53","slug":"excel-makro","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/","title":{"rendered":"Excel Makro"},"content":{"rendered":"

Script ile Excel makrosu \u00e7al\u0131\u015ft\u0131rman\u0131z i\u00e7in haz\u0131rlad\u0131\u011f\u0131m \u00f6rnek script a\u015fa\u011f\u0131dad\u0131r.<\/p>\n

Imports System
\nImports System.IO
\nImports System.Windows.Forms
\nImports Microsoft.VisualBasic
\nNamespace WinTr
\nPublic Class MainClass
\nPublic Sub Load
\nDim Exl As Microsoft.Office.Interop.Excel.Application
\nTry
\nExl = New Microsoft.Office.Interop.Excel.Application
\nExl.Visible = True
\nExl.Workbooks.Open(“C:\\Kitap1.xls”)
\nExl.Worksheets(1).cells(1, 1).value = “Tarih”
\nExl.Worksheets(1).cells(2, 1).value = Now
\nExl.Run(“Sayfa1.SorOku”)
\nCatch ex As Exception
\nMessageBox.Show(Ex.ToString,Ex.Message)
\nMsgBox(“C:\\Kitap1.xls A\u00e7\u0131lamad\u0131!”)
\nEnd Try
\nEnd Sub
\nEnd Class
\nEnd Namespace<\/p>\n

\n\t\t\t\t\t
Kodu kopyalay\u0131p yap\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda \u00e7ift t\u0131rnak i\u015faretlerini yeniden yaz\u0131n\u0131z. Baz\u0131 sat\u0131rlar iki\u2019ye b\u00f6l\u00fcnerek iki sat\u0131r \u015feklinde yap\u0131\u015ft\u0131r\u0131lm\u0131\u015f olabilir, kontrol ediniz.<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

Script ile Excel makrosu \u00e7al\u0131\u015ft\u0131rman\u0131z i\u00e7in haz\u0131rlad\u0131\u011f\u0131m \u00f6rnek script a\u015fa\u011f\u0131dad\u0131r. Imports System Imports System.IO Imports System.Windows.Forms Imports Microsoft.VisualBasic Namespace WinTr Public Class MainClass Public Sub Load Dim Exl As Microsoft.Office.Interop.Excel.Application Try Exl = New Microsoft.Office.Interop.Excel.Application Exl.Visible = True Exl.Workbooks.Open(“C:\\Kitap1.xls”) Exl.Worksheets(1).cells(1, 1).value = “Tarih” Exl.Worksheets(1).cells(2, 1).value = Now Exl.Run(“Sayfa1.SorOku”) Catch ex As Exception MessageBox.Show(Ex.ToString,Ex.Message) MsgBox(“C:\\Kitap1.xls A\u00e7\u0131lamad\u0131!”) […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_swpsp_post_exclude":false,"footnotes":""},"categories":[31],"tags":[129],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-scada-excel","tag-scada-ile-excel-makro-calistirma"],"yoast_head":"\nExcel Makro - SCADA E\u011fitim Sitesi<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salih\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Excel Makro\",\"datePublished\":\"2013-03-09T13:59:27+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/\"},\"wordCount\":144,\"commentCount\":0,\"keywords\":[\"Scada ile Excel Makro \u00c7al\u0131\u015ft\u0131rma\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/\",\"name\":\"Excel Makro - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2013-03-09T13:59:27+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/excel-makro\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Makro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\",\"name\":\"SCADA E\u011fitim Sitesi\",\"description\":\"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\",\"name\":\"Salih\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"caption\":\"Salih\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Makro - SCADA E\u011fitim Sitesi","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:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Excel Makro","datePublished":"2013-03-09T13:59:27+00:00","dateModified":"2021-12-18T11:30:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/"},"wordCount":144,"commentCount":0,"keywords":["Scada ile Excel Makro \u00c7al\u0131\u015ft\u0131rma"],"articleSection":["Excel"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/","name":"Excel Makro - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2013-03-09T13:59:27+00:00","dateModified":"2021-12-18T11:30:53+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/excel-makro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Excel Makro"}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/","name":"SCADA E\u011fitim Sitesi","description":"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/scada-yardim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be","name":"Salih","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","caption":"Salih"},"sameAs":["http:\/\/www.fultek.com.tr"],"url":"https:\/\/www.fultek.com.tr\/scada-yardim\/author\/salih\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":3,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":1067,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/201\/revisions\/1067"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}