{"type":"rich","version":"1.0","provider_url":"https://hatena.blog","blog_url":"https://kaze88.hatenablog.jp/","title":"CSV\u30c7\u30fc\u30bf\u3092\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8aad\u307f\u8fbc\u3093\u3067\u3000\u6700\u7d42\u884c\u306b\u5165\u308c\u8fbc\u3080","blog_title":"\u98a8\u306e\u304d\u307e\u3050\u308c","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fkaze88.hatenablog.jp%2Fentry%2F2014%2F02%2F06%2F104600\" title=\"CSV\u30c7\u30fc\u30bf\u3092\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8aad\u307f\u8fbc\u3093\u3067\u3000\u6700\u7d42\u884c\u306b\u5165\u308c\u8fbc\u3080 - \u98a8\u306e\u304d\u307e\u3050\u308c\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","height":"190","author_name":"kazepapa","width":"100%","published":"2014-02-06 10:46:00","url":"https://kaze88.hatenablog.jp/entry/2014/02/06/104600","provider_name":"Hatena Blog","categories":["\u30cd\u30c3\u30c8\uff06\u30c4\u30fc\u30eb"],"author_url":"https://blog.hatena.ne.jp/kazepapa/","description":"\u7c21\u6613\u7684\u306b \u8aad\u307f\u8fbc\u307f\u3060\u3051\u306a\u3089\u3053\u3046\u304b\uff01Sub Sample2()Dim buf As StringOpen \"C:\\Data\\Sample.csv\" For Input As #1Do Until EOF(1)Line Input #1, buf''\u8aad\u307f\u8fbc\u3093\u3060\u30c7\u30fc\u30bf\u3092\u30bb\u30eb\u306b\u4ee3\u5165\u3059\u308bLoopClose #1End Sub\u76ee\u7684\u4f4d\u7f6e\uff08\u8a18\u5165\u6700\u7d42\u884c\u5f8c\uff09\u3078\u306e\u30bb\u30eb\u30b3\u30d4\u30fc\u304c \u3053\u308c\u304b\uff01Public Sub AddNewData()'\u65e2\u5b9a\u306e\u30c7\u30fc\u30bf\u306e\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3092\u8ffd\u52a0\u3059\u308b Range(\"J3:P3\").Select Selection.Copy Cells(ActiveSheet.Rows.Count, 2).End(\u2026","image_url":null}