HTML were do I start

[Stuby]

Hi

I need to create a report but it needs to be in HTML format with data from
cells and charts which cannot be altered when the sheet is updated.

Does anyone know of any sites that will point me in the right direction.

Many Thanks

Stuby

 

[JulieD]

Hi Stuby

as you don't want the cells & charts on the HTML document to change i'ld be
tempted to use a HTML editor program & copy the cells & charts as jpgs and
insert them in the HTML document as required - you could even use Word if
you really wanted to.

If you choose to use Word, basically type the report like any other ...
copy/paste the cells & charts - tables in Word help solve layout issues then
from the menu choose Files / Save As Web Page ... you can even in Word 2002
and above choose
File / Save As and under Save as Type choose Filtered Web Page ... this cuts
down on the amount of HTML code created but you can't edit this document &
resave it to the web, you'ld need to edit an "original" version of the
document.

When you save a document as a Web Page in Word all pictures are created as
separate things so when you save - create a folder to save into and then all
the bits stay together.

Hope this helps
Cheers
JulieD

 

[stuby]

Hi JulieD

First Many thanks for your reply.
I was hoping to do the tasks such as creating the HTML automatically,
that is user clicks a button on a userform and hay presto the report
appears already saved in a HTML document which I can then FTP to a
remote web server.
If you or anyone knows where I can start Links to web sites
recommended books etc would be grateful.

Regards

Stuby

 

[JulieD]

Hi Stuby

the reason i didn't think you were after that option is that you said you'ld
like to create a REPORT ...
this means (to me) that you want to combine information from different
places into a HTML document with additional text ...
you could make "automatic" by say, creating a report in Word with bookmarks
in the places that you want the Excel selections copied to and then when
they press a button, the information is copied and the word document is
saved as a HTML document.

If this is what you're after then the steps involved would be along the
lines of
1) range naming all the areas in excel that you want exported
2) creating a template in word with bookmarks in the places that you wanted
the information imported to

then in code
3) creating a new document based on the word template
4) exporting the excel data into the bookmarked places
5) saving the word document automatically to a nominated place as a filtered
HTML document

I don't know any resources that take you through this process but you would
probably find references to all of the above steps in the google archives
individually and then you'll just need to pull it all together.

Someone else might have a better suggestion but this is the way i would
approach it based on what i know of excel & word.

Cheers
JulieD