Saving data to a webpage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 24 Feb 2008 01:06 GMT

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

Reply to this Message

David McRitchie - 24 Feb 2008 03:10 GMT

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

Signature

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

> Dear All,
>
[quoted text clipped - 10 lines]
>
> Steve

Reply to this Message

steve - 24 Feb 2008 21:00 GMT

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

> Hi Steve,
> What part do you need help with.
[quoted text clipped - 8 lines]
> Excel to HTML conversions
> http://www.mvps.org/dmcritchie/excel/xl2html.htm

Reply to this Message