Taking each row of excel file and exporting to html

[bb]

Hello.

Im trying to take a large excel file and basically have it do this.


It is setup as follows.
| PartNumber | MFG | Pole | Amp | Volt | Price|
xyx,mfg1,3,5,1,10
xxx,mfg2,3,5,11,25
.....

and continues.

What i want to do is have a html template file that excel opens.
This template file would have variables to be replaced in random
places $$PartNumber$$ $$MFG$$ for example would be replace.

What i need excel to do is go through each row individually, select
the 6 columns of data, replace the $$MFG$$ with the excel data for
that row, save it as an html file named by its PartNumber and loop
down each row creating a new html file for each row's data.

Anyone know of any tools or macros that can help me with this?

Thank you so much.

Matt

 

[Douglas J. Steele]

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

You might have more luck asking in a newsgroup that's related to Excel.