Saving as html - bottom bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 24 Jun 2008 02:38 GMT

I am saving sheets out as html.

The problem i have is they are all one sheet with a menu bar placed on
the bottom. Is there a simple way to have excel save without this
meny bar?

I am using Office 2007 pro

Reply to this Message

Jim Rech - 24 Jun 2008 16:20 GMT

The "menu bar" is the worksheet tabs, which you get when you choose to save
the "entire workbook". Use "Selection" instead and a have only one cell
selected to have the entire sheet saved. Else select a range to get just
that.

Signature

Jim

|I am saving sheets out as html.
|
[quoted text clipped - 3 lines]
|
| I am using Office 2007 pro

Reply to this Message

Mike - 24 Jun 2008 22:35 GMT

>The "menu bar" is the worksheet tabs, which you get when you choose to save
>the "entire workbook". Use "Selection" instead and a have only one cell
>selected to have the entire sheet saved. Else select a range to get just
>that.

Thanks Jim. The only downside to this is I keep getting the html
alligned centre. Any idea how to get it to automatically save it
without this alignment or align left?

Reply to this Message

Jim Rech - 25 Jun 2008 14:34 GMT

Sorry but I don't see any center alignment, unless the cells has center
alignment set of course.

Signature

Jim

|
| >The "menu bar" is the worksheet tabs, which you get when you choose to save
[quoted text clipped - 5 lines]
| alligned centre. Any idea how to get it to automatically save it
| without this alignment or align left?

Reply to this Message

Mike - 30 Jun 2008 16:46 GMT

>Sorry but I don't see any center alignment, unless the cells has center
>alignment set of course.

thanks jim. after looking at this it appears because we have the
text centred in each cell (looks better this way) it then outputs the
full sheet as centred when saving to html.

any ideas how to get around this.

Reply to this Message