{"id":4199,"date":"2021-02-18T01:17:17","date_gmt":"2021-02-17T16:17:17","guid":{"rendered":"https:\/\/okamurax.com\/?p=4199"},"modified":"2026-03-22T06:25:15","modified_gmt":"2026-03-21T21:25:15","slug":"excel%e3%81%8c%e9%87%8d%e3%81%84%e5%a0%b4%e5%90%88","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=4199","title":{"rendered":"Excel \u4e0d\u5177\u5408\u95a2\u9023"},"content":{"rendered":"<p>\u6bce\u56de\u691c\u7d22\u3057\u3066\u3044\u308b\u306e\u3067\u30e1\u30e2\u3002<\/p>\n<h2>Excel\u306e\u66f4\u65b0\u3092\u5b9f\u884c<\/h2>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30a2\u30ab\u30a6\u30f3\u30c8\uff1eOffice\u66f4\u65b0\u30d7\u30ed\u30b0\u30e9\u30e0<\/p>\n<h2>\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u3001\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30a2\u30af\u30bb\u30e9\u30ec\u30fc\u30bf<\/h2>\n<p>\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u3001\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30a2\u30af\u30bb\u30e9\u30ec\u30fc\u30bf\u3092\u6b62\u3081\u308b\u3068\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u5b89\u5b9a\u3059\u308b\u5834\u5408\u304c\u3042\u308b\u3002\u901a\u5e38\u306f\u6b62\u3081\u306a\u3044\u3002<\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u8a73\u7d30\u8a2d\u5b9a\uff1e\u8868\u793a<br \/>\n\u30cf\u30fc\u30c9\u30a6\u30a7\u30a2\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30a2\u30af\u30bb\u30e9\u30ec\u30fc\u30bf\u3092\u7121\u52b9\u306b\u3059\u308b(\u74b0\u5883\u4fdd\u5b58)<\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u8a73\u7d30\u8a2d\u5b9a\uff1e\u5168\u822c<br \/>\n\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u51e6\u7406\u3092\u6709\u52b9\u306b\u3059\u308b(\u74b0\u5883\u4fdd\u5b58)<\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u8a73\u7d30\u8a2d\u5b9a\uff1e\u6570\u5f0f<br \/>\n\u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u8a08\u7b97\u3092\u884c\u3046<br \/>\n(\u30d6\u30c3\u30af\u4f9d\u5b58\u306a\u306e\u3067\u30d6\u30c3\u30af\u4fdd\u5b58\u304c\u5fc5\u8981)<\/p>\n<h2>\u30d5\u30a1\u30a4\u30eb(\u30d6\u30c3\u30af)\u304c\u958b\u304b\u306a\u3044\u5834\u5408<\/h2>\n<p>\u30bf\u30b9\u30af\u30de\u30cd\u30fc\u30b8\u30e3\u30fc\u304b\u3089Excel\u3092\u7d42\u4e86\u3059\u308b\u3068\u76f4\u308b\u3053\u3068\u304c\u591a\u3044\u3002<\/p>\n<h2>VBA\u304c\u5b9f\u884c\u3067\u304d\u306a\u3044(\u4fdd\u8b77\u30d3\u30e5\u30fc)<\/h2>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\u306e\u8a2d\u5b9a<br \/>\n\u4fdd\u8b77\u30d3\u30e5\u30fc<br \/>\n\u4fdd\u8b77\u30d3\u30e5\u30fc\u306e\u9805\u76ee\u3092\u3059\u3079\u3066\u5916\u3059\u3002<\/p>\n<h2>VBA\u304c\u5b9f\u884c\u3067\u304d\u306a\u3044(\u30de\u30af\u30ed\u30d6\u30ed\u30c3\u30af)<\/h2>\n<p>\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\u306e\u8a2d\u5b9a\uff1e\u30de\u30af\u30ed\u306e\u8a2d\u5b9a<br \/>\nVBA\u30de\u30af\u30ed\u3092\u6709\u52b9\u306b\u3059\u308b<\/p>\n<h3>\u30bd\u30fc\u30b9\u304c\u4fe1\u983c\u3067\u304d\u306a\u3044\u305f\u3081<\/h3>\n<p>\u3053\u306e\u30d5\u30a1\u30a4\u30eb\u306e\u30bd\u30fc\u30b9\u304c\u4fe1\u983c\u3067\u304d\u306a\u3044\u305f\u3081\u3001Microsoft\u306b\u3088\u308a\u30de\u30af\u30ed\u306e\u5b9f\u884c\u304c\u30d6\u30ed\u30c3\u30af\u3055\u308c\u307e\u3057\u305f\u3068\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3002<\/p>\n<p>\u30fb\u30ed\u30fc\u30ab\u30eb\u306b\u3042\u308b\u30d5\u30a1\u30a4\u30eb<br \/>\n\u30d5\u30a1\u30a4\u30eb\u53f3\u30af\u30ea\u30c3\u30af\uff1e\u30d7\u30ed\u30d1\u30c6\u30a3\uff1e\u8a31\u53ef\u3059\u308b\u306b\u30c1\u30a7\u30c3\u30af\u3057\u3066OK<\/p>\n<p>\u30fb\u30aa\u30f3\u30e9\u30a4\u30f3(\u5171\u6709)\u306b\u3042\u308b\u30d5\u30a1\u30a4\u30eb\u306a\u3089\u3001<br \/>\nExcel\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\u306e\u8a2d\u5b9a\uff1e\u4fe1\u983c\u3067\u304d\u308b\u5834\u6240\uff1e\u65b0\u3057\u3044\u5834\u6240\u306e\u8ffd\u52a0<br \/>\n\u304b\u3089\u30d6\u30c3\u30af\u306e\u4fdd\u5b58\u3057\u3066\u3042\u308b\u5834\u6240\u3092\u8ffd\u52a0\u3059\u308b\u3002<br \/>\n\u203b\u3053\u3053\u3067\u767b\u9332\u3067\u304d\u308b\u306e\u306f\u30db\u30b9\u30c8\u540d\u306e\u307f\u3002IP\u30a2\u30c9\u30ec\u30b9\u306f\u8ffd\u52a0\u3067\u304d\u306a\u3044\u3002\u3053\u3053\u3092\u30db\u30b9\u30c8\u540d\u3067\u767b\u9332\u3057\u305f\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u306b\u5bfe\u3057\u3066IP\u30a2\u30c9\u30ec\u30b9\u3067\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3068\u30d6\u30ed\u30c3\u30af\u3055\u308c\u308b\u3002<\/p>\n<h4>IP\u30a2\u30c9\u30ec\u30b9\u3057\u304b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u5834\u6240\u306e\u5834\u5408<\/h4>\n<p>control\uff1e\u30a4\u30f3\u30bf\u30fc\u30cd\u30c3\u30c8\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\uff1e\u4fe1\u983c\u6e08\u307f\u30b5\u30a4\u30c8\uff1e\u30b5\u30a4\u30c8<br \/>\n\u306b\u767b\u9332\u3059\u308b\u3002<\/p>\n<p>\u203b2023\u5e745\u6708\u73fe\u5728\u3002inetcpl.cpl\u304b\u3089\u4fe1\u983c\u6e08\u307f\u30b5\u30a4\u30c8\u306b\u767b\u9332\u3057\u3066\u3082ip\u30a2\u30c9\u30ec\u30b9\u3060\u3068\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308b\u3002\u305d\u306e\u5834\u5408\uff5e<\/p>\n<p>C:\\Windows\\System32\\drivers\\etc\\hosts<br \/>\n\u3092\u7ba1\u7406\u8005\u3067\u958b\u304f\u3002<\/p>\n<p>IP\u30a2\u30c9\u30ec\u30b9 server\u540d<br \/>\n\u9069\u5f53\u306a\u30b5\u30fc\u30d0\u30fc\u540d\u3067\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\uff1e\u30c8\u30e9\u30b9\u30c8\u30bb\u30f3\u30bf\u30fc\u306e\u8a2d\u5b9a\uff1e\u4fe1\u983c\u3067\u304d\u308b\u5834\u6240\uff1e\u65b0\u3057\u3044\u5834\u6240\u306e\u8ffd\u52a0<br \/>\n\u304b\u3089\u8ffd\u52a0\u3057\u305f\u30b5\u30fc\u30d0\u30fc\u540d\u3092\u8ffd\u52a0\u3059\u308b\u3002(\u30b5\u30d6\u30d5\u30a9\u30eb\u30c0\u3082\u8a31\u53ef\u3059\u308b)<\/p>\n<p>&nbsp;<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"7okJJMxEeg\"><p><a href=\"https:\/\/appbay.org\/?p=5352\">Excel \u4fe1\u983c\u6e08\u307f\u30b5\u30a4\u30c8\u767b\u9332(\u30ec\u30b8\u30b9\u30c8\u30ea)<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Excel \u4fe1\u983c\u6e08\u307f\u30b5\u30a4\u30c8\u767b\u9332(\u30ec\u30b8\u30b9\u30c8\u30ea)&#8221; &#8212; \u30c6\u30c3\u30af\u30e1\u30e2\" src=\"https:\/\/appbay.org\/?p=5352&#038;embed=true#?secret=j0YASjbsBO#?secret=7okJJMxEeg\" data-secret=\"7okJJMxEeg\" width=\"525\" height=\"296\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u30d5\u30a1\u30a4\u30eb\u307e\u3067\u306e\u30d1\u30b9\u306b\u3231\u3068\u3044\u3046\u6587\u5b57\u304c\u3042\u3063\u305f\u3089\u958b\u3051\u306a\u304b\u3063\u305f\u306e\u3067\u3001\u30d1\u30b9\u306e\u4e2d\u306e\u6587\u5b57\u5217\u304c\u539f\u56e0\u306e\u5834\u5408\u3082\u3042\u308b\u3002<\/p>\n<h2>~$(\u30c1\u30eb\u30c0\u30c9\u30eb\u30d5\u30a1\u30a4\u30eb)<\/h2>\n<p>\u8ab0\u304c\u958b\u3044\u3066\u3044\u308b\u304b\u901a\u77e5\u3059\u308b\u6a5f\u80fd\u304c\u304a\u304b\u3057\u304f\u306a\u3063\u305f\u5834\u5408\u3001~$(\u30c1\u30eb\u30c0\u30c9\u30eb\u30d5\u30a1\u30a4\u30eb)\u306e\u554f\u984c\u304c\u8003\u3048\u3089\u308c\u308b\u306e\u3067\u3001<br \/>\n\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\uff1e\u8868\u793a\uff1e\u30aa\u30d7\u30b7\u30e7\u30f3\uff1e\u30d5\u30a9\u30eb\u30c0\u30fc\u3068\u691c\u7d22\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u5909\u66f4\uff1e\u8868\u793a\uff1e\u4fdd\u8b77\u3055\u308c\u305f\u30aa\u30da\u30ec\u30fc\u30c6\u30a3\u30f3\u30b0\u30b7\u30b9\u30c6\u30e0\u30d5\u30a1\u30a4\u30eb\u3092\u8868\u793a\u3057\u306a\u3044<br \/>\n\u306e\u30c1\u30a7\u30c3\u30af\u3092\u5916\u3057\u3001Excel\u306e\u7d42\u4e86\u3068\u540c\u6642\u306b\u524a\u9664\u3055\u308c\u308b\u304b\u78ba\u8a8d\u3059\u308b\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001HS\u5c5e\u6027\u304c\u5916\u308c\u3066\u3057\u307e\u3063\u305f~$(\u30c1\u30eb\u30c0\u30c9\u30eb\u30d5\u30a1\u30a4\u30eb)\u304c\u81ea\u52d5\u3067\u524a\u9664\u3055\u308c\u305a\u305d\u306e\u307e\u307e\u4ed6\u306e\u4eba\u304c\u518d\u5229\u7528\u3057\u3066\u3057\u307e\u3046(\u5b9f\u969b\u958b\u3044\u3066\u3044\u308b\u4eba\u3068\u306f\u9055\u3046\u540d\u524d\u304c\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3046)\u3068\u3044\u3046\u72b6\u614b\u3002<br \/>\nNAS\u4e0a\u306b\u3042\u308bExcel\u30d5\u30a1\u30a4\u30eb\u3060\u3063\u305f\u306e\u3067\u3001VPN\u304c\u5207\u308c\u305f\u304bExcel\u304c\u843d\u3061\u305f\u304b\u3057\u305f\u3053\u3068\u304c\u767a\u75c7\u306e\u304d\u3063\u304b\u3051\u3060\u3063\u305f\u306e\u3060\u3051\u3069\u3001\u624b\u52d5\u3067~$(\u30c1\u30eb\u30c0\u30c9\u30eb\u30d5\u30a1\u30a4\u30eb)\u3092\u524a\u9664\u3057\u3066\u3082\u75c7\u72b6\u304c\u76f4\u3089\u305a\u3001\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u30ad\u30e3\u30c3\u30b7\u30e5(SMB\u30ad\u30e3\u30c3\u30b7\u30e5)\u3092\u7121\u52b9\u5316\u3057\u305f\u3089\u76f4\u3063\u305f\u3002<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"d0TcdMevxZ\"><p><a href=\"https:\/\/appbay.org\/?p=157\">Windows \u4e0d\u5177\u5408\u95a2\u9023<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Windows \u4e0d\u5177\u5408\u95a2\u9023&#8221; &#8212; \u30c6\u30c3\u30af\u30e1\u30e2\" src=\"https:\/\/appbay.org\/?p=157&#038;embed=true#?secret=UBovdYJIbk#?secret=d0TcdMevxZ\" data-secret=\"d0TcdMevxZ\" width=\"525\" height=\"296\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"sOu7VYxqeP\"><p><a href=\"https:\/\/appbay.org\/?p=5467\">PowerShell ~$\u30d5\u30a1\u30a4\u30eb(Excel)\u79fb\u52d5<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;PowerShell ~$\u30d5\u30a1\u30a4\u30eb(Excel)\u79fb\u52d5&#8221; &#8212; \u30c6\u30c3\u30af\u30e1\u30e2\" src=\"https:\/\/appbay.org\/?p=5467&#038;embed=true#?secret=ivCB76NDD1#?secret=sOu7VYxqeP\" data-secret=\"sOu7VYxqeP\" width=\"525\" height=\"296\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u3067\u691c\u7d22\u3059\u308b\u3068\u304d<\/p>\n<pre class=\"lang:default decode:true \">~=\"~$\".<\/pre>\n<h2>\u4fdd\u5b58\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u306a\u3044(\u5909\u66f4\u5185\u5bb9\u3092\u4fdd\u5b58\u3057\u307e\u3059\u304b\uff1f)<\/h2>\n<p>\u30a2\u30c9\u30a4\u30f3\u304c\u60aa\u3055\u3092\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u591a\u304f\u3001\u4eca\u56de\u306f\u3001<br \/>\nAcrobat PDFMaker Office COM Addin<br \/>\n\u304c\u539f\u56e0\u3060\u3063\u305f\u3002<\/p>\n<p>\u4fdd\u5b58\u3057\u3066\u3044\u308b\u306f\u305a(\u305f\u3076\u3093)\u306a\u306e\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u306a\u3044\u3068\u3044\u3046\u75c7\u72b6\u304c\u3067\u3066\uff64<br \/>\n\u4eca\u56de\u306f\u30a2\u30c9\u30a4\u30f3\u306f\u8aad\u307f\u8fbc\u3093\u3067\u3044\u306a\u304b\u3063\u305f\uff61<br \/>\n\u30aa\u30d7\u30b7\u30e7\u30f3&gt;\u4fdd\u5b58&gt;\u30ad\u30e3\u30c3\u30b7\u30e5\u30d5\u30a1\u30a4\u30eb\u306e\u524a\u9664\u306e\u5b9f\u884c<br \/>\n(\u30d5\u30a1\u30a4\u30eb\u3092\u9589\u3058\u305f\u3068\u304d\u306b &#8230; \u524a\u9664\u3059\u308b\u306b\u30c1\u30a7\u30c3\u30af)<br \/>\n\u3067\u4e00\u5fdc\u75c7\u72b6\u304c\u843d\u3061\u7740\u3044\u305f\uff61<br \/>\n\u305f\u3060\u3057\uff64\u3053\u308c\u306f\u539f\u56e0\u304c\u306f\u3063\u304d\u308a\u3057\u306a\u3044\u306e\u3067\u52d8\u9055\u3044\u304b\u3082\uff61<\/p>\n<h2>\u4f7f\u7528\u8005\u306f&#8217;<em>\u307b\u304b\u306e\u30e6\u30fc\u30b6&#8217;<\/em>\u3067\u3059\u3068\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3046<\/h2>\n<p>A\u304c\u958b\u3044\u3066\u3044\u3066B\u304c\u901a\u77e5\u3092\u53d7\u3051\u53d6\u308b\u3053\u3068\u306b\u3057\u305f\u3002A\u304cExcel\u3092\u9589\u3058\u3066\u3082B\u306b\u901a\u77e5\u304c\u884c\u304b\u306a\u304b\u3063\u305f(\u3082\u3057\u304b\u3057\u305f\u3089\u901a\u77e5\u306f\u884c\u3063\u305f\u3051\u3069\u3001B\u304c\u958b\u304b\u306a\u304b\u3063\u305f\u306e\u304b\u3082)B\u306f\u4ed6\u306eExcel\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u3044\u3066\u3044\u3066Excel\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u751f\u304d\u3066\u3044\u308b\u72b6\u614b\u3002\u3053\u308c\u3067~$\u306f\u524a\u9664\u3055\u308c\u3066\u3044\u308b\u3057\u3001\u8a72\u5f53\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306f\u8ab0\u3082\u958b\u3044\u3066\u3044\u306a\u3044\u3051\u3069\u3001B\u306eExcel\u306e\u30d7\u30ed\u30bb\u30b9\u304c\u30d5\u30a1\u30a4\u30eb\u3092\u3064\u304b\u3093\u3067\u3044\u305f\u3002<\/p>\n<h2>Exce\u30d5\u30a1\u30a4\u30eb\u306e\u8d77\u52d5\u304c\u7570\u5e38\u306b\u9045\u3044<\/h2>\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u30d7\u30ea\u30f3\u30bf\u306b\u554f\u984c\u304c\u3042\u308a\u3001\u305d\u3053\u306b\u6642\u9593\u304c\u304b\u304b\u3063\u3066\u3044\u305f\u3002<br \/>\n\u3069\u306e\u30d7\u30ea\u30f3\u30bf\u3092\u4f7f\u3046\u304b\u306fExcel\u30d5\u30a1\u30a4\u30eb\u3054\u3068\u306b\u4fdd\u5b58\u3055\u308c\u308b\u304c\u3001\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u30c7\u30d5\u30a9\u30eb\u30c8\u30d7\u30ea\u30f3\u30bf\u306b\u306a\u308b\u3002<\/p>\n<h2>\u5916\u90e8\u30ea\u30f3\u30af\u306e\u524a\u9664<\/h2>\n<p>\u6570\u5f0f\u3067[\u3092\u691c\u7d22\u3059\u308b<br \/>\n\u3042\u308b\u3044\u306f\u3001<br \/>\n\u30c7\u30fc\u30bf\uff1e\u30ea\u30f3\u30af\u306e\u7de8\u96c6\uff1e\u30ea\u30f3\u30af\u306e\u89e3\u9664<\/p>\n<p>\u691c\u7d22\u3057\u3066\u3082\u898b\u3064\u304b\u3089\u306a\u3044\u3001\u7de8\u96c6\u304b\u3089\u3082\u89e3\u9664\u3067\u304d\u306a\u3044\u5834\u5408\u3001<br \/>\n\u30d7\u30eb\u30c0\u30a6\u30f3\u306b\u5b58\u5728\u3059\u308b\u5834\u5408\u304c\u3042\u308b\u3002<br \/>\n\u30c7\u30fc\u30bf\uff1e\u30c7\u30fc\u30bf\u306e\u5165\u529b\u898f\u5247<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"lUtKztQ2JR\"><p><a href=\"https:\/\/appbay.org\/?p=4402\">VBA \u5165\u529b\u898f\u5247<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;VBA \u5165\u529b\u898f\u5247&#8221; &#8212; \u30c6\u30c3\u30af\u30e1\u30e2\" src=\"https:\/\/appbay.org\/?p=4402&#038;embed=true#?secret=VOylhOMH3p#?secret=lUtKztQ2JR\" data-secret=\"lUtKztQ2JR\" width=\"525\" height=\"296\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h2>\u6700\u7d42\u884c\u306e\u898b\u3064\u3051\u65b9<\/h2>\n<p>Ctrl + End<br \/>\nCtrl+G\uff1e\u30bb\u30eb\u9078\u629e\uff1e\u6700\u671f\u306e\u30bb\u30eb<\/p>\n<p>VBA\u306e\u5834\u5408<\/p>\n<pre class=\"lang:vb decode:true\">Sub test1()\r\nFor Each w In Sheets\r\nDebug.Print w.Name, w.Cells.SpecialCells(xlLastCell).Row\r\nNext w\r\nEnd Sub<\/pre>\n<p>\u884c\u524a\u9664\u3067\u30b9\u30af\u30ed\u30fc\u30eb\u30d0\u30fc\u306e\u30b5\u30a4\u30ba\u304c\u623b\u3089\u306a\u3044\u5834\u5408\u3001\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u304c\u5b58\u5728\u3057\u3066\u3044\u308b\u5834\u5408\u3042\u308a\u3002<\/p>\n<h2>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u898b\u3064\u3051\u65b9<\/h2>\n<p>\u52d5\u4f5c\u304c\u9045\u3044(\u91cd\u3044)\u5834\u5408\u3001\u3053\u308c\u304c\u539f\u56e0\u306e\u3053\u3068\u304c\u591a\u3044\u3002<\/p>\n<p>\u30db\u30fc\u30e0\uff1e\u691c\u7d22\u3068\u9078\u629e\uff1e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u9078\u629e\u3068\u8868\u793a<\/p>\n<p>VBA\u306e\u5834\u5408<\/p>\n<pre class=\"lang:vb decode:true \">Sub test2()\r\nFor Each w In Sheets\r\nDebug.Print w.Name, w.Shapes.Count\r\nNext\r\nEnd Sub\r\n\r\nSub test3()\r\nFor Each s In ActiveSheet.Shapes\r\ns.Delete\r\nNext\r\nEnd Sub<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u77ed\u304f\u306a\u3063\u305f\u30b9\u30af\u30ed\u30fc\u30eb\u30d0\u30fc\u306e\u30ea\u30bb\u30c3\u30c8<\/h2>\n<p>\u6700\u671f\u306e\u30bb\u30eb\u306e\u4f4d\u7f6e\u3092\u4fee\u6b63\u3057\u3001A1\u306a\u3069\u3092\u9078\u629e\u3057\u4fdd\u5b58\uff0b\u9589\u3058\u308b\u3002<\/p>\n<h2>\u6700\u7d42\u884c\u307e\u3067\u7d9a\u304f\u7f6b\u7dda\u306e\u6d88\u3057\u65b9<\/h2>\n<p>(\u7f6b\u7dda\u304c\u6700\u671f\u306e\u30bb\u30eb\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u3082\u591a\u3044)<\/p>\n<p>\u884c\u524a\u9664\u3057\u3066\u3082\u4e0b\u304b\u3089\u5fa9\u6d3b\u3059\u308b\u3088\u3046\u306a\u7f6b\u7dda\u306f\u3001\u8a72\u5f53\u306e\u30ab\u30e9\u30e0(A\u3001B\u306a\u3069)\u3092\u9078\u629e\u3057\u3066\u7f6b\u7dda\u3092\u300c\u306a\u3057\u300d\u306b\u3059\u308b\u3002<\/p>\n<p>1\u884c\u304b\u30891048576\u884c\u307e\u3067\u7e26\u306e\u7f6b\u7dda\u3092\u5f15\u3044\u3066\u3044\u308b\u5834\u5408\u3067\u3082\u3001\u4e0b\u304b\u3089\u3042\u308b\u7a0b\u5ea6\u306e\u7f6b\u7dda\u3092\u30af\u30ea\u30a2\u3059\u308c\u3070\u884c\u524a\u9664\u3057\u3066\u3082\u5fa9\u6d3b\u3057\u306a\u304f\u306a\u308b\u3002<\/p>\n<h2>\u6539\u30da\u30fc\u30b8\u30d7\u30ec\u30d3\u30e5\u30fc\u3092\u6a19\u6e96\u306b\u623b\u3059<\/h2>\n<p>\u30b7\u30fc\u30c8\u304c\u591a\u3044\u5834\u5408\u3067\u3001\u6539\u30da\u30fc\u30b8\u30d7\u30ec\u30d3\u30e5\u30fc\u306b\u3057\u3066\u3044\u308b\u3068\u91cd\u3044\u3053\u3068\u304c\u3042\u308b\u3002<\/p>\n<h2>\u30b3\u30fc\u30c9\u306e\u81ea\u52d5\u5b9f\u884c\u3092\u6b62\u3081\u308b<\/h2>\n<pre class=\"lang:vb decode:true\">Sub auto_open()\r\nThisWorkbook.Close\r\nEnd Sub<\/pre>\n<p>\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u3002<\/p>\n<p>Shift\u3092\u62bc\u3057\u306a\u304c\u3089\u958b\u304f\u306e\u306f\u3001<br \/>\n\u30d5\u30a1\u30a4\u30eb\uff1e\u958b\u304f\uff1e\u53c2\u7167<br \/>\n\u3067\u8868\u793a\u3055\u308c\u308b\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u30c0\u30a4\u30a2\u30ed\u30b0\u3067\u5b9f\u884c\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3002<\/p>\n<p>MsgBox\u304c\u8868\u793a\u3055\u308c\u308b\u5834\u5408\u306a\u3089\u3001\u8868\u793a\u3055\u308c\u305f\u3068\u304d\u306bCtr+Break\u3067\u3082\u6b62\u3081\u3089\u308c\u308b\u3002<\/p>\n<h2>\u5faa\u74b0\u53c2\u7167\u306e\u898b\u3064\u3051\u65b9<\/h2>\n<p>\u6570\u5f0f\uff1e\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\uff1e\u5faa\u74b0\u53c2\u7167<\/p>\n<h2>\u30af\u30a4\u30c3\u30af\u4fee\u5fa9<\/h2>\n<p>appwiz.cpl&gt;Microsoft Officexxx&gt;\u5909\u66f4&gt;\u30af\u30a4\u30c3\u30af\u4fee\u5fa9<br \/>\n\u30af\u30a4\u30c3\u30af\u4fee\u5fa9\u3060\u3068\u30d7\u30ed\u30c0\u30af\u30c8\u30ad\u30fc\u306f\u4e0d\u8981\uff61<\/p>\n<h2>\u81ea\u52d5\u56de\u5fa9<\/h2>\n<p>C:\\Users\\xxx\\AppData\\Roaming\\Microsoft\\Excel<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6bce\u56de\u691c\u7d22\u3057\u3066\u3044\u308b\u306e\u3067\u30e1\u30e2\u3002 Excel\u306e\u66f4\u65b0\u3092\u5b9f\u884c \u30d5\u30a1\u30a4\u30eb\uff1e\u30a2\u30ab\u30a6\u30f3\u30c8\uff1eOffice\u66f4\u65b0\u30d7\u30ed\u30b0\u30e9\u30e0 \u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u3001\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30a2\u30af\u30bb\u30e9\u30ec\u30fc\u30bf \u30de\u30eb\u30c1\u30b9\u30ec\u30c3\u30c9\u3001\u30b0\u30e9\u30d5\u30a3\u30c3\u30af\u30a2\u30af\u30bb\u30e9\u30ec\u30fc\u30bf\u3092\u6b62\u3081\u308b\u3068\u74b0\u5883\u306b\u3088\u3063\u3066\u306f\u5b89\u5b9a\u3059\u308b &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/appbay.org\/?p=4199\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;Excel \u4e0d\u5177\u5408\u95a2\u9023&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4199","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/4199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4199"}],"version-history":[{"count":37,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/4199\/revisions"}],"predecessor-version":[{"id":7743,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/4199\/revisions\/7743"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}