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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Query setup 0
Exporting data between excel files 1
Best third-party tool to repair OST files 3
Export data to multiple Excel files using Template 0
Export Data from Report or Query to Excel 1
Easy Steps to Import PST Files to Office 365 0
export from access to excel 2
Exporting access table using vba to excel 1

Back
Top