{"id":69,"date":"2013-10-19T22:33:00","date_gmt":"2013-10-19T13:33:00","guid":{"rendered":"http:\/\/www.coralnet.co.jp\/wordpress\/?guid=144ae25b2d860cee76f8fdead843c06f"},"modified":"2023-06-21T09:09:08","modified_gmt":"2023-06-21T00:09:08","slug":"excel-externalbook","status":"publish","type":"post","link":"https:\/\/coralnet.co.jp\/wordpress\/?p=69","title":{"rendered":"\u25a0\u30a8\u30af\u30bb\u30eb\u3067\u5225\u306e\u30d6\u30c3\u30af\u3092\u5916\u90e8\u53c2\u7167\u3059\u308b\u3068\u304d\u306e\u8a18\u8ff0\u65b9\u6cd5"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">MyWorkbook.xls\u306e\u30d5\u30a1\u30a4\u30eb\u304b\u3089<br>WorkbookA.xls,\u3000Sheet1,\u3000D1\u3000<br>\u3092\u53c2\u7167\u3057\u305f\u3044\u5834\u5408\u306e\u30bb\u30eb\u3067\u306e\u8a18\u8ff0\u65b9\u6cd5\u306f<br><strong>\u53c2\u7167(\u8868\u793a)\u3055\u305b\u305f\u3044\u30bb\u30eb\u306b\u4ee5\u4e0b\u306e\u5f0f\u3092\u8a18\u8ff0<br>\u3000=[workbookA.xls]Sheet1&#8242;!$D$1<\/strong><br>\u3010$\u306f\u7d76\u5bfe\u53c2\u7167\u3011<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u30e1\u30e2\uff1a\u53c2\u7167\u5148\u306e\u30ef\u30fc\u30af\u30d6\u30c3\u30af\u306f\u30ab\u30ec\u30f3\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u304b\u3089\u3057\u305f\u306f\u30d1\u30b9\u3092\u304d\u3063\u3066\u53c2\u7167\u3067\u304d\u308b\u6a21\u69d8\u3002<br>\u3055\u3089\u306b\u30d5\u30a9\u30eb\u30c0\u3054\u3068\u30b3\u30d4\u30fc\u3059\u308c\u3070\u3001\u53c2\u7167\u8a18\u8ff0\u3057\u3066\u3044\u308b\u30bb\u30eb\u306e\u30d1\u30b9\u3082\u305d\u306e\u307e\u307e\u30b3\u30d4\u30fc\u3055\u308c\u3066\u8a2d\u5b9a\u3055\u308c\u308b\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<div class=\"cat_postlist tag_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=2233\" 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-1-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-1-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-1-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-1-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/03\/f_f_business_14_s512_f_business_14_0bg-1.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u3010ChatGPTforExcel\u3011\u3010\u30a8\u30af\u30bb\u30eb\u3011excel\u306bchatgpt\u306eAPI\u95a2\u6570\u3092\u767b\u9332\u3057\u305f\u3089\u7c21\u5358\u3067\u9762\u767d\u304b\u3063\u305f\u4ef6<\/div><time class=\"time__date gf\">2024.09.01<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=1438\" 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\">\u3010VScode\u3011excel\u304b\u3089vccode\u306b\u30b3\u30d4\u30fc\u3057\u3066\u975e\u6587\u5b57\u5316\u3051\uff08\u975e\u8868\u793a\u6587\u5b57\uff09\u3057\u305f\u3068\u304d\u306e\u89e3\u6d88\u6cd5<\/div><time class=\"time__date gf\">2024.06.25<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=1363\" 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\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-144x144.png 144w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u3010Excel\u3011\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u3092\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051\u308b\u65b9\u6cd5\uff08\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u30cf\u30a4\u30e9\u30a4\u30c8\u3042\u308a\u3001\u306a\u3057\uff09<\/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=1275\" 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\">\u3010\u4e2d\u5b66\u53d7\u9a13\u3011\u793e\u4f1a\u30fb\u5730\u7406\u306e\u30c7\u30fc\u30bf\u30b0\u30e9\u30d5\u30a2\u30d7\u30ea\u4f5c\u3063\u3066\u307f\u305f<\/div><time class=\"time__date gf\">2024.05.29<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=1180\" class=\"cat_postlist__link no-icon\"><figure class=\"eyecatch of-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"445\" src=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-485x445.jpg\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-485x445.jpg 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-300x275.jpg 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-1024x939.jpg 1024w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-768x704.jpg 768w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-1536x1408.jpg 1536w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/37599-2048x1877.jpg 2048w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">Excel\u3067\u30de\u30a4\u30f3\u30c9\u30de\u30c3\u30d7(\u30ed\u30b8\u30c3\u30af\u30c4\u30ea\u30fc)\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5<\/div><time class=\"time__date gf\">2024.06.25<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=384\" 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\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-144x144.png 144w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">\u3010Excel\u30fb\u30a8\u30af\u30bb\u30eb\u3011Excel book\u306e\u5916\u90e8\u30ea\u30f3\u30af\uff08\u30cf\u30a4\u30d1\u30fc\u30ea\u30f3\u30af\uff09\u30a8\u30e9\u30fc\u767a\u751f\u6642\u306e\u5bfe\u51e6\u65b9\u6cd5\u3068\u6839\u672c\u5bfe\u7b56<\/div><time class=\"time__date gf\">2024.09.01<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=305\" 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\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png\" class=\"archives-eyecatch-image attachment-oc-post-thum wp-post-image\" alt=\"\" srcset=\"https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-485x485.png 485w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-300x300.png 300w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-150x150.png 150w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg-144x144.png 144w, https:\/\/coralnet.co.jp\/wordpress\/wp-content\/uploads\/2022\/01\/f_f_business_30_s512_f_business_30_2bg.png 512w\" sizes=\"auto, (max-width: 485px) 45vw, 485px\" \/><\/figure><div class=\"postbody archives_post__meta\"><div class=\"ttl\">[excel vba] \u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u3092\u8907\u6570\u30b3\u30d4\u30fc\u3059\u308b\u5834\u5408<\/div><time class=\"time__date gf\">2023.06.21<\/time><\/div><\/a><\/li><li class=\"cat_postlist__li\"><a href=\"https:\/\/coralnet.co.jp\/wordpress\/?p=302\" 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\">\u3010Excel VBA\u3011IsBlank\u3092VBA\u3067\u66f8\u304f\u5834\u5408\u306e\u65b9\u6cd5\u3092\u307e\u3068\u3081\u3066\u307f\u305f\uff08\u7a7a\u767d\u304b\u3069\u3046\u304b\u306e\u30c1\u30a7\u30c3\u30af\u3092\u884c\u3046\uff09<\/div><time class=\"time__date gf\">2024.10.21<\/time><\/div><\/a><\/li><\/ul><\/div>","protected":false},"excerpt":{"rendered":"<p>MyWorkbook.xls\u306e\u30d5\u30a1\u30a4\u30eb\u304b\u3089WorkbookA.xls,\u3000Sheet1,\u3000D1\u3000\u3092\u53c2\u7167\u3057\u305f\u3044\u5834\u5408\u306e\u30bb\u30eb\u3067\u306e\u8a18\u8ff0\u65b9\u6cd5\u306f\u53c2\u7167(\u8868\u793a)\u3055\u305b\u305f\u3044\u30bb\u30eb\u306b\u4ee5\u4e0b\u306e\u5f0f\u3092\u8a18\u8ff0\u3000=[workbookA.xls]Sheet1&#8242;!$D$1\u3010$\u306f\u7d76\u5bfe\u53c2\u7167\u3011\u30e1\u30e2\uff1a\u53c2\u7167\u5148\u306e<\/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":"no","_lmt_disable":"","footnotes":""},"categories":[134],"tags":[46,148],"class_list":{"0":"post-69","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-pc","7":"tag-excel","8":"tag-148","9":"article"},"aioseo_notices":[],"modified_by":"\u3089\u304f\u308d\u3050","_links":{"self":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/69","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=69"}],"version-history":[{"count":5,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":3683,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions\/3683"}],"wp:attachment":[{"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/coralnet.co.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}