Assignment #13

1. Watch the video Creating HTML Pages (MS Excel)   (CC).

2. Complete either Option A or Option B below.

   Option A:

   Create a MS Excel application using Visual Basic for Applications (VBA) that creates web pages similar to the one developed in the video and shown in the images below (Assignment 13 - students). When the "Create HTML Pages" command button is pressed your code should create the following 3 HTML pages ("all-companies.html", "retail-companies.html", and "service-companies.html"). Insert your name somewhere in the document. (VBA code.) (Maximum score possible: 15 points.)

   
   

   Option B:

   Create a MS Excel application using Visual Basic for Applications (VBA) that creates web pages similar to the one developed in the video and shown in the images below (Assignment 13 - students). When the "Create HTML Pages" command button is pressed your code should create the following 4 HTML pages ("all-companies.html", "retail-companies.html", "service-companies.html", and "grocery-companies.html"). Insert your name somewhere in the document. (VBA code.) (Maximum score possible: 20 points.) (Extra data for Grocery Stores).

   

   
   
   

3. Explore the tutorial Hyperlinks in Excel (A Complete Guide + Examples). Convince the instructor that you understand the key concepts in this tutorial by including one or more of the following: a summary of the tutorial, modified formulas similar to those covered in the tutorial, details, examples, charts, tips you learned, etc. Add this information (in a separate tab) to the document created in the previous step.
   
   
4. Save your work as "assignment13.xlsm" when you are finished. The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)".
   
   
5. Upload this file to YOUR-CLASS-WEBSITE.   Help