{"blog_url":"https://ray88.hatenablog.com/","title":"VBA\u3000\u30b7\u30fc\u30c8\u306e\u30b3\u30d4\u30fc","description":"\u25a0\u30b7\u30fc\u30c8\u3092\u5225\u30d6\u30c3\u30af\u306b\u30b3\u30d4\u30fc\u3059\u308b\uff08\u30b7\u30fc\u30c8\u3092\u65b0\u898f\u30d6\u30c3\u30af\u306b\u30b3\u30d4\u30fc\u3057\u305f\u3044\u5834\u5408\u306f\u3053\u306e\u30da\u30fc\u30b8\u306e\u4e00\u756a\u4e0b\u3092\u53c2\u7167\uff09 Sub \u30a2\u30af\u30c6\u30a3\u30d6\u30b7\u30fc\u30c8\u3092\u5225\u30d6\u30c3\u30af\u306e\u5148\u982d\u306b\u30b3\u30d4\u30fc\u3059\u308b() ActiveSheet.Copy _ Before:=Workbooks(\"\u30b3\u30d4\u30fc\u5148\u306e\u30d6\u30c3\u30af.xlsx\").Sheets(1) End Sub Sub \u30a2\u30af\u30c6\u30a3\u30d6\u30b7\u30fc\u30c8\u3092\u5225\u30d6\u30c3\u30af\u306e\u672b\u5c3e\u306b\u30b3\u30d4\u30fc\u3059\u308b() Dim cnt As Long ' \u30b3\u30d4\u30fc\u5148\u30d6\u30c3\u30af\u306e\u30b7\u30fc\u30c8\u306e\u679a\u6570 cnt = Workbooks(\"\u30b3\u30d4\u30fc\u5148\u306e\u30d6\u30c3\u30af.xlsx\").Sheets.Count ActiveSheet.Copy _ After:=Workbooks(\"\u30b3\u30d4\u30fc\u5148\u306e\u2026","width":"100%","provider_url":"https://hatena.blog","type":"rich","height":"190","url":"https://ray88.hatenablog.com/entry/2022/02/19/211804","author_name":"ray88","provider_name":"Hatena Blog","image_url":null,"version":"1.0","author_url":"https://blog.hatena.ne.jp/ray88/","blog_title":"ray88\u2019s diary","categories":[],"published":"2022-02-19 21:18:04","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fray88.hatenablog.com%2Fentry%2F2022%2F02%2F19%2F211804\" title=\"VBA\u3000\u30b7\u30fc\u30c8\u306e\u30b3\u30d4\u30fc - ray88\u2019s diary\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}