{"description":"\u2160. \u306f\u3058\u3081\u306b \u30bf\u30a4\u30c8\u30eb\u306e\u901a\u308a\u300cExcel VBA\u3067\u4efb\u610f\u306e\u6587\u5b57\u5217\u3067\u533a\u5207\u3089\u308c\u305fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3059\u308b\u65b9\u6cd5\u300d\u3067\u3059\u3002 \u2161. \u3084\u308a\u65b9 1. Microsoft ActiveX Data Objects x.x Library \u3092\u8ffd\u52a0\u3059\u308b \u300c\u30c4\u30fc\u30eb\u300d\u2192\u300c\u53c2\u7167\u8a2d\u5b9a\u300d 2. \u4ee5\u4e0b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u30b3\u30d4\u30da\u3059\u308b Option Explicit ' \u6587\u5b57\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0 Const Charset As String = \"UTF-8\" ' \u6539\u884c\u30b3\u30fc\u30c9 Const LineSeparator As String = adCRLF ' \u51e6\u7406\u5bfe\u8c61\u306e\u7bc4\u56f2 Const Area As String = \"A1:D4\" ' \u30d5\u2026","author_name":"kagasu","url":"https://kagasu.hatenablog.com/entry/2020/02/01/051239","title":"Excel VBA\u3067\u4efb\u610f\u306e\u6587\u5b57\u5217\u3067\u533a\u5207\u3089\u308c\u305fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3059\u308b\u65b9\u6cd5","provider_name":"Hatena Blog","blog_title":"\u5099\u5fd8\u9332","published":"2020-02-01 05:12:39","categories":["VBA"],"version":"1.0","author_url":"https://blog.hatena.ne.jp/kagasu/","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkagasu.hatenablog.com%2Fentry%2F2020%2F02%2F01%2F051239\" title=\"Excel VBA\u3067\u4efb\u610f\u306e\u6587\u5b57\u5217\u3067\u533a\u5207\u3089\u308c\u305fCSV\u30d5\u30a1\u30a4\u30eb\u3092\u51fa\u529b\u3059\u308b\u65b9\u6cd5 - \u5099\u5fd8\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kagasu/20200201/20200201051114.png","width":"100%","height":"190","blog_url":"https://kagasu.hatenablog.com/"}