Search code snippets, questions, articles...

murata excel vba ブック保存

' "C:\Users\addre\vba\"は保存先までの絶対パス
ActiveWorkbook.SaveAs "C:\Users\addre\vba\" & Format(Date, "yyyymmdd") & ActiveSheet.Name & ".xlsx"
ActiveWorkbook.Close
Was this helpful?
0 Comments
Programming Feeds
Learn something new everyday on Devsheet