Activity: Save a Hard-coded Copy of Workbook
![]()
Activity: Save a Hard-coded (Formula free) Version of Your Workbook
Use the knowledge you've gained until now to create a macro that saves a hard-coded copy of your Workbook.
The copy should have no formulas - We just want to have a back up of the file without any links or formulas.
The name of the new Workbook should be "HC_" followed by the name of the workbook.
The steps for the macro would be:
- Save the current Workbook
- Select all sheets, copy and paste special all cells in the sheets
- Save the Workbook with Save As (be careful you don't SAVE, but SAVEAS)
- Save it in the same directory as the Workbook. Call the new Workbook "HC_" followed by the current name
BONUS: Add today's date in the form of "yymmdd" after "HC_". For example: "HC_yymmdd_S4_ReferencingRanges"
BONUS: #2: Save the copy without macros (i.e. the copied version should be a normal xlsx file)
Note: Instructions are also inside S4_ReferencingRanges_Start File in the Activity tab. Don't forget to save the file as a macro enabled Workbook.
Answer is in the project video (coming up next) and also included in the complete version of this Workbook in Module ProjectActivity. I also solve for the two bonus points in the next video - Just a heads up that I do use some VBA built-in functions here. We cover these in Section 7.
![]()
Activity: Save a Hard-coded (Formula free) Version of Your Workbook
Use the knowledge you've gained until now to create a macro that saves a hard-coded copy of your Workbook.
The copy should have no formulas - We just want to have a back up of the file without any links or formulas.
The name of the new Workbook should be "HC_" followed by the name of the workbook.
The steps for the macro would be:
- Save the current Workbook
- Select all sheets, copy and paste special all cells in the sheets
- Save the Workbook with Save As (be careful you don't SAVE, but SAVEAS)
- Save it in the same directory as the Workbook. Call the new Workbook "HC_" followed by the current name
BONUS: Add today's date in the form of "yymmdd" after "HC_". For example: "HC_yymmdd_S4_ReferencingRanges"
BONUS: #2: Save the copy without macros (i.e. the copied version should be a normal xlsx file)
Note: Instructions are also inside S4_ReferencingRanges_Start File in the Activity tab. Don't forget to save the file as a macro enabled Workbook.
Answer is in the project video (coming up next) and also included in the complete version of this Workbook in Module ProjectActivity. I also solve for the two bonus points in the next video - Just a heads up that I do use some VBA built-in functions here. We cover these in Section 7.