{"id":57,"date":"2008-03-14T16:27:06","date_gmt":"2008-03-14T07:27:06","guid":{"rendered":"http:\/\/knowhow.hirohiro716.com\/?p=57"},"modified":"2008-03-14T16:27:06","modified_gmt":"2008-03-14T07:27:06","slug":"vb%e3%81%8b%e3%82%89excel%e3%82%92%e6%93%8d%e4%bd%9c%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/weblog.hirohiro716.com\/?p=57","title":{"rendered":"VB\u304b\u3089Excel\u3092\u64cd\u4f5c\u3059\u308b"},"content":{"rendered":"<pre class=\"brush: vb; title: \u30b5\u30f3\u30d7\u30eb; notranslate\" title=\"\u30b5\u30f3\u30d7\u30eb\">\nDim excel As Object\nSet excel = CreateObject(&quot;Excel.Application&quot;)\n\nexcel.Application.Visible = True\nexcel.Application.UserControl = False\n\nexcel.Workbooks.Open &quot;C:\\test.xls&quot;\n\nDim i As Integer\nFor i = 1 To excel.Sheets.Count\n\n    excel.Sheets(i).Cells(1, 1).Value = &quot;Test&quot;\n\nNext i\n\n&#039;excel.Run &quot;Macro&quot;\n\nexcel.ActiveWorkBook.Close False\nexcel.Quit\n\nSet excel = Nothing\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Dim excel As Object Set excel = CreateObject(&quot;Excel.Application&quot;) excel.Application.Visible = True e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-57","post","type-post","status-publish","format-standard","hentry","category-vb-vba"],"views":1242,"_links":{"self":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/57","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":1,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":570,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions\/570"}],"wp:attachment":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}