{"provider_url":"https://hatena.blog","type":"rich","title":"\u300c\u30cf\u30ca\u30af\u30bd\u300d\u306e\u9664\u53bb\u306b\u3064\u3044\u3066","width":"100%","author_name":"akashi_keirin","blog_url":"https://akashi-keirin.hatenablog.com/","description":"\u6628\u65e5\u306e\u8a18\u4e8b\u3067\u3001Word\u306e\u8868\u304b\u3089Excel\u306b\u8ee2\u8a18\u3059\u308b\u3068\u3001\u30cf\u30ca\u30af\u30bd\u307f\u305f\u3044\u306a\u3084\u3064\u304c\u30c6\u30ad\u30b9\u30c8\u306e\u672b\u5c3e\u306b\u3064\u3044\u3066\u304f\u308b\u3068\u66f8\u3044\u305f\u3002 \u3067\u3001\u305d\u306e\u30cf\u30ca\u30af\u30bd\u3092\u9664\u53bb\u3059\u308b\u306e\u306b\u3001Replace\u95a2\u6570\u3092\u4f7f\u3063\u3066\u3044\u305f\u3002 \u3053\u306e\u3053\u3068\u306b\u3064\u3044\u3066\u3001Twitter\u306e\u6570\u5c11\u306a\u3044VBA\u95a2\u4fc2\u306e\u30d5\u30a9\u30ed\u30ef\u30fc\u3055\u3093\u304b\u3089\u3001 Left\u95a2\u6570\u3067\u3084\u3063\u305f\u65b9\u304c\u3088\u304f\u306d\uff1f \u3068\u306e\u3054\u6307\u6458\u3092\u53d7\u3051\u305f\u3002 \u306a\u308b\u307b\u3069\u3002\u78ba\u304b\u306b\u305d\u3046\u3060\u3002\u3084\u308a\u305f\u3044\u3053\u3068\u306f\u300c\u53f3\u7aef\u306e\u90aa\u9b54\u306a\u6587\u5b57\u3092\u6d88\u3059\u300d\u3068\u3044\u3046\u3053\u3068\u306a\u306e\u3060\u304b\u3089\u3001\u7d20\u76f4\u306b\u53f3\u7aef\u306e\u90aa\u9b54\u306a\u6587\u5b57\u3092\u524a\u308b\u3001\u3068\u3044\u3046\u30b3\u30fc\u30c9\u306b\u3059\u3079\u304d\u306a\u306e\u3060\u3002\u6628\u65e5\u306e\u4f8b\u3067\u8a00\u3048\u3070\u3001 'str \u306fString\u578b\u306e\u5909\u6570 str = objDoc.Tables(1).Cell(i, 1).Range.Text \u2026","image_url":null,"categories":["VBA\u899a\u66f8","WordVBA"],"url":"https://akashi-keirin.hatenablog.com/entry/2017/02/24/215542","height":"190","author_url":"https://blog.hatena.ne.jp/akashi_keirin/","provider_name":"Hatena Blog","blog_title":"\u7d20\u4eba\u304cExcelVBA\u306b\u3088\u308b\u300c\u4e00\u4eba\u50cd\u304d\u65b9\u6539\u9769\u300d\u306b\u6311\u3080\u30d6\u30ed\u30b0","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fakashi-keirin.hatenablog.com%2Fentry%2F2017%2F02%2F24%2F215542\" title=\"\u300c\u30cf\u30ca\u30af\u30bd\u300d\u306e\u9664\u53bb\u306b\u3064\u3044\u3066 - \u7d20\u4eba\u304cExcelVBA\u306b\u3088\u308b\u300c\u4e00\u4eba\u50cd\u304d\u65b9\u6539\u9769\u300d\u306b\u6311\u3080\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2017-02-24 21:55:42","version":"1.0"}