HTML title

[Jaymond Flurrie]

I'm trying to create a macro for Excel 2007 that would save my file with name somefile.html having a HTML title sometitle

This name for file (somefile) should come automatically from cell A1 of sheet1 of workbook.xlsm and the title (sometitle) should come automatically from cell A2 of sheet1 of workbook.xlsm

This sounds like very easy macro, but I haven't found any VBA-related info of Excel 2007's HTML title. Could someone here help me?

Thank you in advance!

[royUK]

Have you read this?

http://blogs.msdn.com/excel/archive/...24/718786.aspx

[Jaymond Flurrie]

Have you read this?

http://blogs.msdn.com/excel/archive/...24/718786.aspx

So are you saying that I shouldn't save my file as html at all?

The idea I have is to keep publishing these: http://kapsi.fi/~jflurrie/CS/G29-0708.html

Is there some certain thing that you can recommend to me to keep publishing these? People should be able to read only, not to see any formulas and not to change anything.

Any feedback is more than welcome!

[royUK]

I'm not sure if you can save as a multi-page html file. There is an otion to save as mht. This could be because Excel 2007 workbooks now use xml, change the file extension on a 2007 workbook to .zip and hn open the zip to see what comprises the workbook.