I've used this befo
http://www.hkvstore.com/aspreportmaker/

I think it cost $100. It works great with an MS Access back end. As the
developers states, the tool can be used with any 'ADO data source', so Excel
should work fine. If you are feeling really ambitious, you may want to try
this:
http://www.microsoft.com/express/vwd/

It is totally free and very powerful!! Only one reason would prevent me
from full recommending this as a solution...it take a bit of work to get
acquainted with web development with VWD. It really depends on your appetite
for these types of things, but I would think it will take a good year or so
to get very proficient with VWD. However, you can probably find some video
tutorials online (there are many) and join some discussion groups (there are
many) and buy some books (there are many) and get up to speed with some BASIC
things in maybe a few weeks or month or so.

HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Glen" wrote:

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.