{"id":132,"date":"2025-06-02T06:23:38","date_gmt":"2025-06-01T21:23:38","guid":{"rendered":"https:\/\/aisleblog.com\/?p=132"},"modified":"2025-06-07T19:31:57","modified_gmt":"2025-06-07T10:31:57","slug":"vba-%e3%80%8c%e3%83%96%e3%83%83%e3%82%af%e3%80%81%e3%82%b7%e3%83%bc%e3%83%88%e3%80%81%e3%82%bb%e3%83%ab%e3%81%ae%e6%89%b1%e3%81%84%e6%96%b9%e3%80%8d","status":"publish","type":"post","link":"https:\/\/aisleblog.com\/?p=132","title":{"rendered":"\u7b2c2\u56de\u300c\u30d6\u30c3\u30af\u3001\u30b7\u30fc\u30c8\u3001\u30bb\u30eb\u306e\u6271\u3044\u300d"},"content":{"rendered":"\n

\u30d6\u30c3\u30af<\/h3>\n\n\n\n
\u66f8\u304d\u65b9<\/th>\u8aac\u660e<\/th>\u4f8b<\/th><\/tr><\/thead>
Workbooks(“Book1.xlsx”)<\/td>\u958b\u3044\u3066\u3044\u308b\u30d6\u30c3\u30af\u3092\u540d\u524d\u3067\u6307\u5b9a<\/td>Workbooks(“Book1.xlsx”).Activate<\/td><\/tr>
ThisWorkbook<\/td>\u73fe\u5728\u306eVAB\u304c\u66f8\u304b\u308c\u3066\u3044\u308b\u30d6\u30c3\u30af<\/td>ThisWorkbook.Sheets(1).Activate<\/td><\/tr>
ActiveWorkbook<\/td>\u73fe\u5728\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30d6\u30c3\u30af<\/td>ActiveWorkbook.Save<\/td><\/tr>
Set wb = Workbooks.Open(…)<\/td>\u30d6\u30c3\u30af\u3092\u958b\u3044\u3066\u5909\u6570\u3067\u6307\u5b9a<\/td>Set wb = Workbooks.Open(“C:\\…”)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u30ef\u30fc\u30af\u30b7\u30fc\u30c8<\/h3>\n\n\n\n
\u66f8\u304d\u65b9<\/th>\u8aac\u660e<\/th>\u4f8b<\/th><\/tr><\/thead>
Worksheets(“Sheet1”)<\/td>\u540d\u524d\u3067\u30b7\u30fc\u30c8\u3092\u6307\u5b9a<\/td>Worksheets(“Sheets1”).Activate<\/td><\/tr>
Sheets(1)<\/td>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u756a\u53f7\u3067\u6307\u5b9a<\/td>Sheet(1).Activate<\/td><\/tr>
ThisWorkbook.Sheets(“Sheet1”)<\/td>ThisWorkbook\u5185\u306e\u30b7\u30fc\u30c8\u6307\u5b9a<\/td>ThisWorkbook.Sheets(“Sheet1”).Name<\/td><\/tr>
Set ws = Worksheets(“Sheet1”)<\/td>\u5909\u6570\u306b\u683c\u7d0d\u3057\u3066\u4f7f\u3046<\/td>ws.Range(“A1”).Value = “Hello”<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u30bb\u30eb<\/h3>\n\n\n\n
\u66f8\u304d\u65b9<\/th>\u8aac\u660e<\/th>\u4f8b<\/th><\/tr><\/thead>
Range(“A1”)<\/td>\u5358\u4e00\u30bb\u30eb\u3092\u76f4\u63a5\u6307\u5b9a<\/td>Range(“A1”).Value = “\u30c6\u30b9\u30c8”<\/td><\/tr>
Cells(1,1)<\/td>\u884c\u5217\u756a\u53f7\u3067\u6307\u5b9a<\/td>Cells(1,1).Value = “Hello”<\/td><\/tr>
Range(“A1:B2”)<\/td>\u8907\u6570\u30bb\u30eb\u3092\u7bc4\u56f2\u3067\u6307\u5b9a<\/td>Range(“A1:B2”).ClearContents<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u30d6\u30c3\u30af \u66f8\u304d\u65b9 \u8aac\u660e \u4f8b Workbooks(“Book1.xlsx”) \u958b\u3044\u3066\u3044\u308b\u30d6\u30c3\u30af\u3092\u540d\u524d\u3067\u6307\u5b9a Workbooks(“Book1.xlsx”).Activate T […]<\/p>\n","protected":false},"author":1,"featured_media":147,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jinr_url_youtube":"","_jinr_pip_youtube":false,"_jinr_time_youtube":"","_jinr_thumb_youtube":"","_jinr_media_youtube":"","_jinr_category_edit":false,"_jinr_category":"","_jinr_title_display":false,"_jinr_snsbutton_display":false,"_jinr_ads_display":false,"_jinr_thumbnail_display":false,"_jinr_profile_display":false,"_jinr_representations_display":false,"_jinr_relatedpost_display":false,"_jinr_sidebar1col_display":false,"_jinr_sidebar2col_display":false,"_jinr_seotitle_display":"","_jinr_description_display":"","_jinr_keyword_display":"","_jinr_hastag_display":"","_jinr_canonical_display":"","_jinr_noindex_display":false,"_jinr_paidpost":false,"_jinr_paidpost_product_id":"","_jinr_headtag_article":"","_jinr_ogp_image_url":"","_jinr_last_featured_id":0,"footnotes":""},"categories":[7],"tags":[],"class_list":["post-132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"views":"23","_links":{"self":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=132"}],"version-history":[{"count":3,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions"}],"predecessor-version":[{"id":150,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/posts\/132\/revisions\/150"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=\/wp\/v2\/media\/147"}],"wp:attachment":[{"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aisleblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}