Excel VBA - Copy worksheet to a new workbook and rename

Ah Sing TV
Ah Sing TV
18.7 هزار بار بازدید - 3 سال پیش - How to copy worksheet to
How to copy worksheet to a new workbook in VBA?
How to save a workbook using the name of the worksheet?

Functions:
1. For Each ws In ActiveWorkbook.Worksheets
2. ws.Copy
3. ChDir "PASTE YOUR PATH HERE"
4. ActiveWorkbook.SaveAs Filename:="PAST YOUR PATH HERE\" & ActiveSheet.Name & ".xlsx"
5. ActiveWorkbook.Close

Remark: to save as "Macro-Enabled" workbook, use ".xlsm".
3 سال پیش در تاریخ 1400/07/18 منتشر شده است.
18,793 بـار بازدید شده
... بیشتر