Macro that exports to text or html files

[matjnewton]

Hi guys

I'm just wondering if this is possible.

I'm currently creating a limousine directory website, with one worksheet per city.

Each worksheet has the basics like "URL" "Name" "Description" "Ph#" and things like this.

Is it possible to have it output each worksheet a bit like a mailmerge, where it just slots in the basic details of each company into a pre-formatted html file and then saves each one as a .html file?

For example, the code would output a bit like this

< a href="http://www.examplelimo.com">Example Limo</a> - Based in Exampleland, we offer 50 limousines all at $5/hr including monkey chauffeurs. Ph#: 1-800-749-8646. http://www.examplelimo.com">Click here to visit</a>
<br><br>

< a href="http://www.examplelimo2.com">Example Limo 2</a> - Based in Exampleland, we offer 52 limousines all at $5/hr including monkey chauffeurs. Ph#: 1-800-749-8646. http://www.examplelimo2.com">Click here to visit</a>
<br><br>

Each worksheet would need to output to a different file, with the file name based on the name of the worksheet.

If anyone knows of ANY method to do this, Excel or otherwise, that would be awesome.

 

[cjcobra]

I would have one tab with all the info that change be changed to customize each HTML file. Then have the other tab as the full html content, with links in the middle of the lines linking to each column of data. If you do this for the first HTML, then copy it multiple times. you can then just change the links over one column from the main file, or incorporate a cell in the top of your sheet that has "B" or "C", etc so when you change that cell, it'll link to B5, C5, etc in your main sheet.