I have a macro which is used to submit data from a form, save a copy of
the file to a designated network location & also email the file to an
assigned individual.

I need more transparency on all these forms submitted & so I now want
to be able to export certain fields from this form to an HTML file upon
execution of this macro.

The two main areas I'm struggling with a
1.) Exporting the form input fields; none of the data I'm exporting is
in a simple row or column. How do I loop to find all the named ranges
and export them?

2.) Each time a user uses the form & submits the data - it must not
overwrite existing data. I want each file submitted to be stored in a
seperate
row on the html page.

Many thanks in advance to those who can help.
All comments welcome.

hyper