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

Dim nm as Name, rng as Range
for each nm in thisworkbook.Names
set rng = Nothing
on error resume Next
set rng = nm.ReferstoRange
On error goto 0
if not rng is nothing then
' do what
end if
Next

But is seems more likely you would know the names and want to do something
particular with each name

namelist = Array("A","B","C","D")
for i = lbound(namelist) to ubound(namelist)
set rng = Range(namelist(i))
select case namelist(i)
case "A","C"

case "B","D"

end select
Next

an html file is just a text file that includes tags that are meaningful to
the software reading the html file. You can write such a file with low level
file io.

You could write your data to a database and have an html page that reads and
displays that database.

I am sure there are other ways as well.

--
Regards,
Tom Ogilvy



"Lenap" wrote:

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