Saving as HTML questions?

**dlenoxx** · 06-02-2011, 09:54 AM

Normally I would create a quick test and try saving, but I'm trying to do a project for a class I'm teaching in the next week and the computer I'm working on won't let me save documents, so I would appreciate the input.

If I were to create a simple VBA excel sheet with multiple choice answers, and saved it as HTML how would that display?

I have three sheets, one for the questions, and two hidden sheets (one for the math, one for the answers)

Hopefully it would show the non-hidden sheet and still process the VBA, but I've never done it before.

**royUK** · 06-02-2011, 10:17 AM

I don't think that VBA will not work that way

**6StringJazzer** · 06-02-2011, 11:45 AM

It will definitely not work that way. VBA is executed by Excel. When you export a file as HTML you just get the look, but the VBA doesn't go with it. HTML also doesn't provide any functionality; if you want a web page to have behavior then you need to program it with some combination of JavaScript on the browser side plus a server-side language like PHP, Java (J2EE), etc. This is true whether you are writing HTML by hand or exporting from Excel.