15.1 [50] 

In this problem, you'll create a template and a macro that enters data into the template. This is a common procedure in the workplace setting, where templates are often pre-populated (partially) prior to distribution. For instance, you might have a template to which you want to add information specific to a given recipient, both to save time and to help that recipient avoid errors. Or you might want to add some information to the template before spcializing it to individual recipients — such as the fiscal year, or this year's values of specific parameters.

(a) [15] 

Create a template for your homework sets. It should contain a single worksheet The name of that worksheet should be "Info" and it should have the required information on it.

(b) [35] 

If you were actually using the template you just made for doing homework for this course, you would want to add sheets to it, one for each of the problems in the problem set. In this part (b), you will write a macro that adds worksheets to a workbook made from your template. It will add one worksheet for each of four problems in a fictitious problem set 17. Write a macro that starts with the template, then creates sheets for Problems 17.1, 17.2, 17.3 and 17.4, and finally saves the result with the name Dilbert17.xls. To learn how to add a worksheet to an existing workbook, use the macro recorder. In this part of the problem, you might want to use string concatenation. String concatenation works the same in VBA as it does on the worksheet. You just use the & operator.

15.2 [50] 

In this problem, you'll convert your macro into a distributable tool. For the purposes of this homework set, please ignore the fact that your macro works only for problem set 17. In a more realistic version, it might ask the user the the problem set number and for the number of problems in the problem set. We're ignoring that for now.

(a) [15] 

Assign the keyboard shortcut Ctrl+Shift+M to your macro. Make this assignment by adding appropriate VBA code to the ThisWorkbook module of the workbook that contains your macro.

(b) [35] 

Convert your workbook into an add-in and install it on your machine. Test it.