Taking each row of excel file and exporting to html

  • Thread starter Thread starter bb
  • Start date Start date
B

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
 
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.
 
Back
Top