{"id":4125,"date":"2016-12-28T01:56:28","date_gmt":"2016-12-27T16:56:28","guid":{"rendered":"https:\/\/bono-ism.com\/blog\/?p=4125"},"modified":"2016-12-28T01:56:28","modified_gmt":"2016-12-27T16:56:28","slug":"excel-vba%e3%81%a7%e6%96%87%e5%ad%97%e5%88%97%e5%88%86%e5%89%b2%e3%83%84%e3%83%bc%e3%83%ab%e4%bd%9c%e3%81%a3%e3%81%9f%e3%80%82","status":"publish","type":"post","link":"https:\/\/bono-ism.com\/blog\/archives\/4125","title":{"rendered":"Excel VBA\u3067\u6587\u5b57\u5217\u5206\u5272\u30c4\u30fc\u30eb\u4f5c\u3063\u305f\u3002"},"content":{"rendered":"<div id=\"advads-2283759550\" class=\"advads- advads-entity-placement\" style=\"margin-bottom: 30px;clear: both;\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-4535387451297385\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-client=\"ca-pub-4535387451297385\" \ndata-ad-slot=\"1658778714\" \ndata-ad-layout=\"in-article\"\ndata-ad-format=\"fluid\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><br style=\"clear: both; display: block; float: none;\"\/><p>\u3000<br \/>\n\u4ed5\u4e8b\u3067\u5fc5\u8981\u306b\u99c6\u3089\u308c\u3066Excel\u306e\u30de\u30af\u30ed(VBA)\u3092\u4f5c\u3063\u3066\u3044\u308b\u3002\u7279\u306b\u5fc5\u8981\u3060\u3063\u305f\u306e\u304c\u30011\u30bb\u30eb\u306b\u5168\u3066\u306e\u4f4f\u6240\u304c\u53ce\u307e\u3063\u3066\u3044\u308b\u3082\u306e\u3092\u8907\u6570\u5217\u306b\u5206\u5272\u3059\u308b\u3001\u3068\u3044\u3046\u3082\u306e(\u203b\u3061\u306a\u307f\u306b\u82f1\u8a9e\u3067\u66f8\u304b\u308c\u305f\u4f4f\u6240\u306e\u307f\u3092\u5bfe\u8c61\u3068\u3057\u3066\u3044\u308b)\u3002\u3068\u8a00\u3046\u308f\u3051\u3067\u3001\u306a\u308b\u3079\u304f\u6c4e\u7528\u6027\u306e\u9ad8\u3044\u3082\u306e\u3092\u3001\u3068\u3044\u3046\u3053\u3068\u3067\u30c4\u30fc\u30eb\u3092\u4f5c\u3063\u3066\u307f\u305f\u3002<br \/>\n<!--more--><br \/>\n\u5f53\u8a72\u30c4\u30fc\u30eb\u3060\u304c\u3001\u5404\u5217\u306b\u306f\u5236\u9650byte\u6570\u304c\u3042\u3063\u3066\u3001\u3057\u304b\u3082\u5358\u8a9e\u306e\u9014\u4e2d\u3067\u306f\u533a\u5207\u3089\u306a\u3044\u3068\u3044\u3046\u7d04\u675f\u3092\u8a2d\u3051\u3066\u3044\u308b\u3002\u6587\u5b57\u5217\u3092\u5206\u5272\u3059\u308b\u306b\u5f53\u305f\u3063\u3066\u76ee\u5b89\u306b\u3057\u3066\u3044\u308b\u306e\u306f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3002\u305f\u3060\u3057\u3001\u300c,\u300d(\u30b3\u30f3\u30de)\u306e\u5f8c\u3082\u6587\u5b57\u5217\u306e\u304f\u304e\u308a\u3068\u3057\u305f\u304b\u3063\u305f\u306e\u3067\u3001\u4eca\u56de\u306f\u6025\u5834\u3057\u306e\u304e\u3067\u3001\u30b3\u30f3\u30de\u306e\u5f8c\u306b\u306f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u3092\u7121\u7406\u77e2\u7406\u8ffd\u52a0\u3057\u3066\u3001\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u306e\u307f\u3092\u5206\u5272\u306e\u76ee\u5b89\u3068\u3057\u305f\u3002\u305d\u306e\u4ed6\u306b\u306f\u30fb\u30fb\u30fb\u30fb\u5236\u9650\u6587\u5b57\u6570\u3092\u77ed\u304f\u3059\u308b\u3068\u3001\u5236\u9650\u6587\u5b57\u6570\u4ee5\u4e0a\u306e\u5358\u8a9e\u306a\u3069\u304c\u51fa\u3066\u6765\u3066\u30011\u30bb\u30eb\u306e\u6587\u5b57\u6570\u304c\u5236\u9650\u6587\u5b57\u6570\u3092\u8d85\u3048\u308b\u5834\u5408\u306f\u30bb\u30eb\u306b\u8272\u3065\u3051\u3092\u3059\u308b\u3088\u3046\u306b\u3057\u305f\u3002<\/p>\n<p>\u5f8c\u3001\u5206\u5272\u5217\u306e\u6700\u5f8c\u306e\u5217\u3067\u3082\u6587\u5b57\u5217\u304c\u53ce\u307e\u308a\u304d\u3089\u306a\u3044\u5834\u5408\u306f\u3001\u5236\u9650\u6587\u5b57\u6570\u3067\u52dd\u624b\u306b\u30ab\u30c3\u30c8\u305b\u305a\u3001\u5168\u3066\u306e\u6587\u5b57\u5217\u3092\u6700\u7d42\u5217\u306b\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u305f\u3002<\/p>\n<p>\u307e\u3042\u3001\u767e\u805e\u306f\u4e00\u898b\u306b\u3057\u304b\u305a\u3001\u306a\u306e\u3067\u3001Windows\u306eExcel\u30e6\u30fc\u30b6\u30fc\u306e\u4eba\u306f\u4e0b\u8a18\u306e\u30ea\u30f3\u30af\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u3001\u3061\u3087\u3063\u3068\u8a66\u3057\u3066\u307f\u3066\u6b32\u3057\u3044\u3002\u4f55\u304b\u3001\u82f1\u6587\u306e\u6587\u7ae0\u306a\u308a\u3001\u4f4f\u6240\u306a\u308a\u304c\u767b\u9332\u3055\u308c\u305f\u5225\u306eExcel\u30d5\u30a1\u30a4\u30eb\u304c\u5fc5\u8981\u3060\u3051\u308c\u3069\u3082\u3002(\u203b\u6b8b\u5ff5\u306a\u304c\u3089Mac\u3067\u306f\u52d5\u304d\u307e\u305b\u3093\u3002\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u52d5\u4f5c\u306a\u3069\u3092Windows\u306e\u30b7\u30b9\u30c6\u30e0\u306b\u983c\u3063\u3066\u3044\u308b\u306e\u3067\u3002)<\/p>\n<p><a href=\"https:\/\/bono-ism.com\/blog\/wp-content\/uploads\/2016\/12\/\u6587\u5b57\u5217\u5206\u5272\u30c4\u30fc\u30eb.xls\">\u6587\u5b57\u5217\u5206\u5272\u30c4\u30fc\u30eb<\/a><\/p>\n<div id=\"advads-2612799312\" class=\"advads- advads-entity-placement\" style=\"margin-top: 10px;margin-bottom: 25px;\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-4535387451297385\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block;\" data-ad-client=\"ca-pub-4535387451297385\" \ndata-ad-slot=\"4656971981\" \ndata-ad-format=\"auto\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>\u3000 \u4ed5\u4e8b\u3067\u5fc5\u8981\u306b\u99c6\u3089\u308c\u3066Excel\u306e\u30de\u30af\u30ed(VBA)\u3092\u4f5c\u3063\u3066\u3044\u308b\u3002\u7279\u306b\u5fc5\u8981\u3060\u3063\u305f &hellip; <a href=\"https:\/\/bono-ism.com\/blog\/archives\/4125\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[148],"tags":[],"class_list":["post-4125","post","type-post","status-publish","format-standard","hentry","category-vba"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pir8D-14x","jetpack-related-posts":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/posts\/4125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/comments?post=4125"}],"version-history":[{"count":2,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/posts\/4125\/revisions"}],"predecessor-version":[{"id":4128,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/posts\/4125\/revisions\/4128"}],"wp:attachment":[{"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/media?parent=4125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/categories?post=4125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bono-ism.com\/blog\/wp-json\/wp\/v2\/tags?post=4125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}