Assignment #11   (20 points)

  1. Watch the video Create HTML Pages (CC).

  2. Create a MS Excel application using Visual Basic for Applications (VBA) that creates a web page similar to the one developed in the video and shown in the image below. When the "Create HTML Page" command button is pressed your code should create an HTML page that contains a thumbnail version of all the produce listed in the MS Excel file, along with hyperlinks to a "small", "medium" and "large" version of the produce. The interface and a screen capture showing the source code can be downloaded/viewed from the Assignment #11 folder. Save your work as "assignment11.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.



Grading Rubric
Required Elements Points Possible Does not meet requirements Meets some requirements Meets or exceeds all requirements Your Score
Created a MS Excel application using Visual Basic for Applications (VBA) that creates a web page similar to the one developed in the video and shown in the image above. When the "Create HTML Page" command button is pressed your code should create an HTML page that contains a thumbnail version of all the produce listed in the MS Excel file, along with hyperlinks to a "small", "medium" and "large" version of the produce. 20 0 10 20 __/20
Total points __/20