IN VBE IN EXCEL

Assume that there is only one Excel file currently open. Write a single sub that does the following tasks in the exact order as presented below:

- Displays the name and path of the workbook in a message box.

- Adds a new sheet to the workbook, locates it right before the last sheet (last sheet = rightmost sheet) of the workbook, and changes its tab name to NewSheet.

-Counts the number of worksheets in the workbook and displays it in a message box.

-Saves the workbook as Question1Modified.xlsm in the same path as the workbook Question1.xlsmis located. Your sub should not be written for a specific path, it should continue to work if Question1.xlsmis moved to another path.

- Tries to open the workbook Test.xlsx. Assume that there are two possible scenarios:

(1) There is no workbook with the name Test.xlsx in the same path as the currently active workbook is located. Then, the sub should display the message There is no Test.xlsx in this location!

(2) There is a workbook with the name Test.xlsx in the same path as the currently active workbook is located. Then, the sub should open Test.xlsx