Place setting items to the Web

Earlier, you did the place settings exercise. (If you didn't, do it now.)

Modify it so that it outputs a Web page, as well as to the worksheet. Sample partial output:

Web page output

Upload your Excel file.

Hint: Some code that might be useful:

  1. Open ThisWorkbook.Path & "\place-settings.html" For Output As #1
  2. Print #1, "<h2>Place Settings</h2>"
  3. ...
  4. Print #1, "<p><strong>Dishware</strong></p>"
  5. Print #1, "<p>Dinner plates: " & dinnerPlates & "</p>"
  6. ...
  7. Close #1

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)

Referenced in: