| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 My Excel Life | 2021-11-26 07:17:55 |  11,644 Views |
How to Copy a Sheet from the ActiveWorkbook in the New and Save the New Workbook in the related folder with Current Date.
To do it you will do following using VBA:
1 Open the New Workbook
2 Copy Active Sheet into the New Workbook
3 ReName this Sheet in the New Workbook
4 Cancel the default Sheet1 from the New Workbook
5 Give the Name to the New Workbook with the Current Date
6 Save the New Workbook in the related folder
7 Receive the message: /”This Workbook is saved with the name:
Name & Current Date/”
To do it you will do following using VBA:
1 Open the New Workbook
2 Copy Active Sheet into the New Workbook
3 ReName this Sheet in the New Workbook
4 Cancel the default Sheet1 from the New Workbook
5 Give the Name to the New Workbook with the Current Date
6 Save the New Workbook in the related folder
7 Receive the message: /”This Workbook is saved with the name:
Name & Current Date/”
My Links:
Youtube: https://www.youtube.com/myexcellife
Pinterest: https://www.pinterest.es/jekasama/
Twitter: https://twitter.com/jeka_sama
Instagram: https://instagram.com/my_excel_life/
Thank You for Visiting my Channel ️
#MyExcelLife #ExcelTutorials #exceltips #excel @MyExcelLife
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
