Webpage from excel

[Lensmeister]

Hi all,

I know that excel had a built in function to create a web page but it is not what I need allow me to explain.

We have an intranet and I am fed up of the link going to a excel that has been set up as a htm file. Frequantly columns are collapsed and ruin the data contained within the excel.

I use to produce a webpage for my own website at home extracting the data from an Access 97 mdb using a vbs script I was given. This retained all the headers, footers, css etc. so my question:
Is this possible to extract the data using a macro that creates a webpage with all the css etc.?

Thanks for the advice.

 

[Rx_]

Ok, there are probably several ways to approach this depending on what the end product should be.
Excel can be saved as HTM or HTML.
Maybe save it as a PDF and just use the link?
Excel can be saved as XML. I posted some XML to web conversion solutiuons some time back.
Or, some vba code can strip the selected cells and then be used to rebild a HTML template.
Or, create a

 

[Lensmeister]

Thanks.

Ok, there are probably several ways to approach this depending on what the end product should be.
Excel can be saved as HTM or HTML. No CSS and ALWAYS causes us problems.
Maybe save it as a PDF and just use the link? No good need to hyperlink to documents.
Excel can be saved as XML. I posted some XML to web conversion solutiuons some time back. Will explore this.
Or, some vba code can strip the selected cells and then be used to rebild a HTML template. This would be the way I'd prefer to go
Or, create a

OR the only other way it to produce a mdb, but my company does not want to let me have access.

OR hand code each page