Excel Cells Contents to HTML Pages

H

hmaf

Hi,

I have an excel sheet which has two columns.

Column 1: PageName
Column 2: HTMLCode

PageName has information like: OurServices.htm which is the name of th
HTML page.
HTMLCode clumn has actual HTML Code like:

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<p><b><font size="5">Main Page</font></b></p>
<p> </p>
<p><b>Main Menu</b></p>
<p>Link 1</p>
<p>Link 2</p>
<p>Link 3</p>

</body>

</html>

Is there a macro that can:

1- Pick-up Page Name from Cell A2 (e.g: ContactUs.htm)
2- Pick-up HTML Code from Cell B2
3- Create a WebPage called ContactUs.htm in an external folder

Thank you
hma
 

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

Top