I have a macro that updates data on a sheet. After that I would like the
macro to update an HTML Web page with a few of the key cell values.

How can I update only a few select pieces of info on a page? Is there a
simple way?

Thanks,

Hi SpaceCamel;

Assuming that your in a Microsoft world including the web
serve and browsers you could just switch form using the
web page on the website to using an Excel file.

That would let you just resave the document from your
desktop to the internet so long as you have permissions.

Change the links on the website to hit the Excel file
instead of the html page. When a user hits it depending
on their individual MIME settings the page will
automatically open or offer a prompt with a choice to open
or download the page. NetScape user would be prompted if
they want to download it unless they install a Plug In.

Thanks,

Greg

-----Original Message-----
I have a macro that updates data on a sheet. After that I
would like the
macro to update an HTML Web page with a few of the key
cell values.

How can I update only a few select pieces of info on a
page? Is there a
simple way?

Thanks,
.

Yes, That would be easy but it is not what I need. I do not want to link to
the workbook. I need to update only a few key elements on the page using
data in Excel. I can tag the HTML elements with ID'd. I need a way to open
the html file, change the innertext then save it.

"GJones" wrote:

Hi SpaceCamel;

Assuming that your in a Microsoft world including the web
serve and browsers you could just switch form using the
web page on the website to using an Excel file.

That would let you just resave the document from your
desktop to the internet so long as you have permissions.

Change the links on the website to hit the Excel file
instead of the html page. When a user hits it depending
on their individual MIME settings the page will
automatically open or offer a prompt with a choice to open
or download the page. NetScape user would be prompted if
they want to download it unless they install a Plug In.

Thanks,

Greg

-----Original Message-----
I have a macro that updates data on a sheet. After that I
would like the
macro to update an HTML Web page with a few of the key
cell values.

How can I update only a few select pieces of info on a
page? Is there a
simple way?

Thanks,
.

I think for most of us, you would recreate the entire page. You could
use frames and put the part you want to change in their own little HTML files.
Frames aren't very well received and they take longer, and generally have
larger footprints than people want to look at..

If you control the server you might split it into parts and have the server
create the output on the fly.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SpaceCamel" wrote ...
Yes, That would be easy but it is not what I need. I do not want to link to
the workbook. I need to update only a few key elements on the page using
data in Excel. I can tag the HTML elements with ID'd. I need a way to open
the html file, change the innertext then save it.