{"id":1559,"date":"2019-05-29T15:29:06","date_gmt":"2019-05-29T06:29:06","guid":{"rendered":"https:\/\/euc-access-excel-db.com\/tips\/?p=1559"},"modified":"2019-08-02T11:58:37","modified_gmt":"2019-08-02T02:58:37","slug":"close-file-syuukei01","status":"publish","type":"post","link":"https:\/\/euc-access-excel-db.com\/tips\/ct07_se\/ct075012_xls2k_vba_tips\/close-file-syuukei01","title":{"rendered":"\u2605\u2605\u2605 Access2000VBA\u30fbExcel2000VBA\u72ec\u5b66\uff5e\u4ed6\u306eExcel\u30d5\u30a3\u30eb\u304c\u300c\u9589\u3058\u305f\u307e\u307e\u300d\u3001\u300c\u96c6\u8a08\u3092\u3059\u308b\u300d\u305f\u3081\u306e\u65b9\u6cd5\u306b\u3064\u3044\u3066\u3002\uff13\u3064\u4ee5\u4e0a\uff5e"},"content":{"rendered":"<p>\u2605\u2605\u2605 Access2000VBA\u30fbExcel2000VBA\u72ec\u5b66\uff5e\u300c\u9589\u3058\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u96c6\u8a08\u3092\u3059\u308b\u300d\u65b9\u6cd5\u3002\u9589\u3058\u305f\u307e\u307e\u306e\u4ed6\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u3042\u308b\u8868\u306b\u3064\u3044\u3066\u3001\u305d\u306e\u96c6\u8a08\u3092\u3059\u308b\u65b9\u6cd5\u3002\uff13\u3064\u4ee5\u4e0a\uff5e<br \/>\n<SPAN>\u3000\u3000<\/SPAN><br \/>\n<span style=\"color: #ff0000;\">\u203b\u307e\u3060\u66f8\u304d\u304b\u3051\u3067\u3059\u3002\u3059\u307f\u307e\u305b\u3093\u3002<\/span><br \/>\n<span style=\"color: #ff0000;\">\u203b\u9593\u9055\u3063\u3066\u305f\u3089\u3059\u307f\u307e\u305b\u3093\u3002<\/span><br \/>\n<span style=\"color: #ff0000;\">\u203b\u30e1\u30e2\u66f8\u304d\u306a\u306e\u3067\u3001\u81ea\u5206\u3067\u3082\u610f\u5473\u4e0d\u660e\u306a\u7b87\u6240\u3082\u591a\u3044\u3067\u3059\u3002\u3054\u3081\u3093\u306a\u3055\u3044\u3002<\/span><\/p>\n<p>\u2605\u76f8\u624b\u304c\u300c\u52d5\u7684\u306a\u8868\u300d\u306e\u5834\u5408<\/p>\n<p>(01)\u300c\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u300d\u3092\u300c\u5916\u90e8\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u300d\u3067\u4f7f\u3046\u3002<br \/>\n(02)\u300cMicrosoft Query\u300d\uff08MSQRY32.EXE\uff09\u3092\u5358\u72ec\u3067\u4f7f\u3046\u3002<br \/>\n(03)\u300cMicrosoft Query\u300d\uff08MSQRY32.EXE\uff09\u3092Excel\u304b\u3089\u4f7f\u3046\u3002<br \/>\n(04)\u300cQueryTable\u300d\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08\uff1dSQL\uff09\uff0bODBC\uff0bVBA\u3092\u4f7f\u3046\u3002<br \/>\n\u3000\u3000\uff08\u203b\u300c\u30de\u30af\u30ed\u306e\u8a18\u9332\u300d\u6a5f\u80fd\u3067\u8a18\u9332\u3055\u308c\u308b\u3082\u306e\u3068\u540c\u3058\u65b9\u6cd5\u3002\uff09<br \/>\n(05)\u300cQueryTable\u300d\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08\uff1dSQL\uff09\uff0bDAO\uff0bVBA\u3092\u4f7f\u3046\u3002\uff0832bit\u7248\u3060\u3051\u304b\u3082\uff1f\uff09<br \/>\n(06)\u300cQueryTable\u300d\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\uff08\uff1dSQL\uff09\uff0bADO\uff0bVBA\u3092\u4f7f\u3046\u3002<br \/>\n(07)Excel\u306e\u30b7\u30fc\u30c8\u4e0a\u3067\u3084\u308b\u5834\u5408\u306f\u3001\u4e0a\u8a18\u306e(03)\u301c(06)\u307e\u3067\u3068\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u3092\u639b\u3051\u5408\u308f\u305b\u3066\u4f7f\u3046\u3002<br \/>\n(08)DAO\uff0bSQL\u3067\u3001\u30b7\u30fc\u30c8\u306b\u7d50\u679c\u3092\u8fd4\u3055\u305a\u306bVBA\u306e\u4f8b\u3048\u3070\u5909\u6570\u306b\u4e2d\u3060\u3051\u3067\u96c6\u8a08\u7b49\u3092\u3059\u308b(html\u5185\u3067\u3082VBS\u3084PHP\u306a\u3069\u3092\u4f75\u7528\u3059\u308c\u3070\u884c\u3051\u308b\u304b\u3082\uff1f)<br \/>\n(09)ADO\uff0bSQL\u3067\u3001\u540c\u4e0a<br \/>\n(10)PowerQuery\uff1f\u3092\u4f7f\u3046<br \/>\n(11)\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u95a2\u6570\u3092\u4f7f\u3046\uff1f<br \/>\n(12)\u6570\u5f0f\uff08\u5916\u90e8\u30ea\u30f3\u30af\uff09\uff0b\u300c\u30d4\u30dc\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u300d\u3092\u4f7f\u3046\u3002<br \/>\n<SPAN>\u3000\u3000<\/SPAN><br \/>\n<SPAN>\u3000\u3000<\/SPAN><br \/>\n\u2605\u76f8\u624b\u304c\u300c\u9759\u7684\u306a\u8868\u300d\u306e\u5834\u5408<br \/>\n<SPAN>\u3000\u3000<\/SPAN><br \/>\n<SPAN>\u3000\u3000<\/SPAN><br \/>\n<SPAN>\u3000\u3000<\/SPAN><\/p>\n","protected":false},"excerpt":{"rendered":"\u2605\u2605\u2605 Access2000VBA\u30fbExcel2000VBA\u72ec\u5b66\uff5e\u300c\u9589\u3058\u305f\u30d5\u30a1\u30a4\u30eb\u306e\u96c6\u8a08\u3092\u3059\u308b\u300d\u65b9\u6cd5\u3002\u9589\u3058\u305f\u307e\u307e\u306e\u4ed6\u306eExcel\u30d5\u30a1\u30a4\u30eb\u306e\u4e2d\u306b\u3042\u308b\u8868\u306b\u3064\u3044\u3066\u3001\u305d\u306e\u96c6\u8a08\u3092\u3059\u308b\u65b9\u6cd5\u3002\uff13\u3064\u4ee5\u4e0a\uff5e \u3000\u3000 \u203b\u307e\u3060\u66f8\u304d\u304b\u3051\u3067\u3059\u3002\u3059\u307f ...","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[234],"_links":{"self":[{"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/posts\/1559"}],"collection":[{"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/comments?post=1559"}],"version-history":[{"count":0,"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/posts\/1559\/revisions"}],"wp:attachment":[{"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/media?parent=1559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/euc-access-excel-db.com\/tips\/wp-json\/wp\/v2\/categories?post=1559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}