This is really a sanity check for me:

I have created a file that will generate random quizzes for the
engineers in my group. The file has several modules running in the
background to make everything work and also to capture metrics in a
hidden sheet. I realize I have forced Excel to act like a database
here but the file and all of the modules work flawlessly. My problem
is getting user feedback to roll up the metrics on results. I was
thinking that if I could somehow convert the file to html and maintain
the functionality of the VBA modules, I could have all users generate
and complete these quizzes on our intranet and I would be able to
capture the metrics. Right now I am using a tool similar to
SharePoint where users need to check the file out but nothin forces
them to check in their results. If they do poorly, they don't upload
those results and I have no visibility. This method also limits the
file to one user at a time. So...
1) Will the web method be a possibility and how hard would it be? (I
have no experience with this)
2) Does anyone have any other suggestions for how to handle this?
(Aside form starting over by developing in Access)

Thank you to whoever can help.

Thanks.