Hiko.Blog Excel VBA活用術

「Excel VBAで仕事を効率化!初心者でもできる自動化のコツ」

MENU

2025-12-01から1ヶ月間の記事一覧

ひな形を使って新規ブック作成 改修版(ヒット0件の場合の処理)

VBA

Sub ひな形を使って新規ブック作成() Dim srcWB As Workbook Dim srcSheet2 As Worksheet, srcSheet3 As Worksheet Dim destWB As Workbook Dim destSheet2 As Worksheet, destSheet3 As Worksheet Dim templatePath As String, outputFolder As String Dim …