Dear All,


I have a worksheet and various data is written to this sheet about 300
times using a series of macros

i need to save each of the sheets(300 ish) as webpages

Cell J4 is the filename to which i need the file saves as


Can anyone please help me


Many many thanks in advance




Steve

Hi Steve,
What part do you need help with.

Does this page help, you would need to modify or add
a front end to loop through sheets or whatever you doing
but the macro will create an HTML page for very simple
tables, with some cell merging, one color font and one
background color for cell.

The actual purpose was to
extract the table and put it into my own web page.
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2html.htm

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"steve" wrote in message ...
Dear All,


I have a worksheet and various data is written to this sheet about 300
times using a series of macros

i need to save each of the sheets(300 ish) as webpages

Cell J4 is the filename to which i need the file saves as


Can anyone please help me


Many many thanks in advance




Steve

David,

Thanks for your reply,

I have had a look at your macro from converting from xl to a webpage and
to be honest with you im very lost

Ive only just started to use Excel VBA


Basically what i require(pretty pretty pretty) please is


Select A1:Z43
save selected cells to a webpage directory path c:\
but file name needs to be what it is in Cell J4

many many many thanks if yiu can do this for me


Regards


Steve




David McRitchie wrote:
Hi Steve,
What part do you need help with.

Does this page help, you would need to modify or add
a front end to loop through sheets or whatever you doing
but the macro will create an HTML page for very simple
tables, with some cell merging, one color font and one
background color for cell.
The actual purpose was to extract the table and put it into my own web
page.
Excel to HTML conversions
http://www.mvps.org/dmcritchie/excel/xl2html.htm