{"id":68,"date":"2013-10-20T22:56:00","date_gmt":"2013-10-20T13:56:00","guid":{"rendered":"http:\/\/www.coralnet.co.jp\/wordpress\/?guid=49cd319663708e80d743623a592a5a01"},"modified":"2022-02-12T17:19:50","modified_gmt":"2022-02-12T08:19:50","slug":"vba%e5%bf%98%e5%82%99%e9%8c%b2%e3%80%80%ef%bd%9e%e6%8c%87%e5%ae%9a%e3%81%97%e3%81%9f%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab%e3%81%8c%e5%ad%98%e5%9c%a8%e3%81%97%e3%81%a6%e3%81%84%e3%82%8b%e3%81%8b","status":"publish","type":"post","link":"https:\/\/coralnet.co.jp\/wordpress\/?p=68","title":{"rendered":"VBA\u5fd8\u5099\u9332\u3000\uff5e\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u304b\u3069\u3046\u304b\u306e\u30c1\u30a7\u30c3\u30af\u3000\u3000"},"content":{"rendered":"<p>\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u5b58\u5728\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u5b58\u5728\u3057\u3066\u3044\u305f\u3089\u524a\u9664\u3059\u308b\u5834\u5408\u306e\u51e6\u7406<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<br \/>If (Dir$(PATH &amp; fName &amp; &#8220;.xls&#8221;) &lt;&gt; &#8220;&#8221;) Then<br \/>Kill PATH &amp; fName &amp; &#8220;.xls&#8221;<br \/>End If<br \/>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>PATH\u306b\u306f\u6307\u5b9a\u3059\u308b\u30d1\u30b9\u3092\u30b0\u30ed\u30fc\u30d0\u30eb\u5909\u6570\u3068\u3057\u3066\u7528\u610f\u3057\u3066\u304a\u304f\u3002<\/p>\n<p>\u00a0<\/p>\n\n<div class=\"cat_postlist new_postlist typecard\" style=\"--stk-postlist_column_sp:50%;--stk-postlist_column_pc:25%;--stk-postlist_column_tb:25%;\"><ul class=\"cat_postlist__ul\"><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=6105\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u30c7\u30a4\u30c8\u30e9 WEB\u5236\u4f5c\u30b3\u30fc\u30b9\u6311\u6226\u4e2d|\u5b66\u7fd2\u306e\u307e\u3068\u3081\uff08\u521d\u7d1a\u7de8Day13\uff5eDay25)<\/div><time class=\"time__date gf\">2025.02.16<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=6101\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/02\/f_f_business_14_s512_f_business_14_0bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u30c7\u30a4\u30c8\u30e9 WEB\u5236\u4f5c\u30b3\u30fc\u30b9\u6311\u6226\u4e2d|\u5b66\u7fd2\u306e\u307e\u3068\u3081\uff08\u521d\u7d1a\u7de8Day1\uff5eDay10)<\/div><time class=\"time__date gf\">2025.02.02<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=5756\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u5b85\u914d\u5f01\u5f53\u30fb\u5b85\u914d\u60e3\u83dc\u4f7f\u3063\u3066\u307f\u305f\u3089\u3001\u3068\u3066\u3082\u4fbf\u5229\u3060\u3063\u305f\u4ef6<\/div><time class=\"time__date gf\">2025.01.01<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=5995\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u3010Formie\u3011\u3059\u3050\u306b\u5f79\u306b\u7acb\u3061\u305d\u3046\u306a\u8cc7\u683c\uff14\u9078<\/div><time class=\"time__date gf\">2024.10.18<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=6088\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-144x144.png 144w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">formie(\u30d5\u30a9\u30fc\u30df\u30fc)\u3067\u7247\u3065\u3051\u53ce\u7d0d\u30b9\u30da\u30b7\u30e3\u30ea\u30b9\u30c8\u306e\u8cc7\u683c\u53d6\u5f97\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u3066\u307f\u305f<\/div><time class=\"time__date gf\">2025.01.05<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=5964\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"485\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg-144x144.png 144w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2010\/04\/f_f_object_24_s512_f_object_24_2bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u30b9\u30de\u30db\u3067\u8cc7\u683c\u304c\u5b66\u3079\u308b\uff1f\u30aa\u30f3\u30e9\u30a4\u30f3\u901a\u4fe1\u30dd\u30fc\u30bf\u30eb\u30b5\u30a4\u30c8formie(\u30d5\u30a9\u30fc\u30df\u30fc)\u3067\u8cc7\u683c\u53d6\u5f97\u306b\u30c1\u30e3\u30ec\u30f3\u30b8\u3057\u3066\u307f\u305f<\/div><time class=\"time__date gf\">2024.10.20<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=5717\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"243\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-485x243.jpg\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-485x243.jpg 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-300x150.jpg 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-1024x512.jpg 1024w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-768x384.jpg 768w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2-1536x768.jpg 1536w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2023\/08\/image-2-2.jpg 1890w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u30102024\u5e747\u6708\u3011\u3010U-NEXT\u3011\u5148\u884c\u914d\u4fe1\u30c9\u30e9\u30de\u3084\u72ec\u5360\u6620\u753b\u60c5\u5831\u3082\uff01U-NEXT 7\u6708\u306e\u6ce8\u76ee\u30b3\u30f3\u30c6\u30f3\u30c4\u3092\u7d39\u4ecb<\/div><time class=\"time__date gf\">2024.10.21<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=5630\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"122\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2024\/06\/Believe-485x122.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2024\/06\/Believe-485x122.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2024\/06\/Believe-300x76.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2024\/06\/Believe.png 714w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u300cBELIEVE \u65e5\u672c\u30d0\u30b9\u30b1\u3092\u8ae6\u3081\u306a\u304b\u3063\u305f\u7537\u305f\u3061\u300d<\/div><time class=\"time__date gf\">2024.06.23<\/time><\/div><\/a><\/li><\/ul><\/div>","protected":false},"excerpt":{"rendered":"<p>\u6307\u5b9a\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u5b58\u5728\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3001\u5b58\u5728\u3057\u3066\u3044\u305f\u3089\u524a\u9664\u3059\u308b\u5834\u5408\u306e\u51e6\u7406&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;If (Dir$(PATH &amp; fName &amp; &quot;.xls&quot;)  &quot;&quot;) Then    Kill PATH &amp; fName &amp;  &quot;.xls&quot;End If&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;PATH\u306b\u306f\u6307\u5b9a\u3059\u308b\u30d1\u30b9\u3092\u30b0\u30ed\u30fc\u30d0\u30eb\u5909\u6570\u3068\u3057\u3066\u7528\u610f\u3057\u3066\u304a\u304f\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_lmt_disableupdate":"yes","_lmt_disable":"","footnotes":""},"categories":[134],"tags":[],"class_list":{"0":"post-68","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-pc","7":"article"},"aioseo_notices":[],"modified_by":"\u3089\u304f\u308d\u3050","_links":{"self":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=68"}],"version-history":[{"count":3,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/68\/revisions"}],"predecessor-version":[{"id":5928,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/68\/revisions\/5928"}],"wp:attachment":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}