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:
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.
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:
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.