other

murata excel vba ブック保存

' "C:\Users\addre\vba\"は保存先までの絶対パス
ActiveWorkbook.SaveAs "C:\Users\addre\vba\" & Format(Date, "yyyymmdd") & ActiveSheet.Name & ".xlsx"
ActiveWorkbook.Close
Was this helpful?