Header Picture

[sgood73730]

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[Dodo2u]

(e-mail address removed) wrote in @o13g2000cwo.googlegroups.com:

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

The resolution loss is because of the low screen resolution of 72 dpi.
Copy/paste from a screen does not other than take the picture in screen
resolution.

Can you find out what the picture's original name was?

 

[Earl Kiosterud]

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the physical
screen space you can. Now do a print preview, and if it looks as though you
have all of the picture, capture it with Alt-Print Scr. This will put the
screen image of the active window on the clipboard. You can paste that into
most any image program, including Paint, where you can save it as a jpg or
whatever. You'll need to be able to crop it to get rid of the window stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[David McRitchie]

Hi S. Good,
I expect you could try converting a copy of the workbook sheet to HTML
If you do get your headers then you would find the pictures in a folder
with the same name as the workbook. I don't really think you will see
the same headers in HTML that you have in Excel, but even if you don't
they should be saved so that round tripping would work.

I have Excel 2000 so I can't have a picture in the header. In a cell and in
rows to repeat , yes, but not in a header.

Work with a copy of your workbook to keep things from going bad.

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the physical
screen space you can. Now do a print preview, and if it looks as though you
have all of the picture, capture it with Alt-Print Scr. This will put the
screen image of the active window on the clipboard. You can paste that into
most any image program, including Paint, where you can save it as a jpg or
whatever. You'll need to be able to crop it to get rid of the window stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[Earl Kiosterud]

David,

Yes, in Excel 2002, when you save it as a web page, includes the page header
picture in the folder for the htm file. I opened the jpg file and sure
enough, it was the one.

S. Goode, try File - Save as web page. If your workbook name is MyBook.xls,
look for a folder called MyBook_files. In that folder, look for something
like image001.jpg.
--
Earl Kiosterud
www.smokeylake.com

Hi S. Good,
I expect you could try converting a copy of the workbook sheet to HTML
If you do get your headers then you would find the pictures in a folder
with the same name as the workbook. I don't really think you will see
the same headers in HTML that you have in Excel, but even if you don't
they should be saved so that round tripping would work.

I have Excel 2000 so I can't have a picture in the header. In a cell and
in
rows to repeat , yes, but not in a header.

Work with a copy of your workbook to keep things from going bad.

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears
to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making
the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels
on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make
sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low
as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the
edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In
the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the
physical
screen space you can. Now do a print preview, and if it looks as though
you
have all of the picture, capture it with Alt-Print Scr. This will put
the
screen image of the active window on the clipboard. You can paste that
into
most any image program, including Paint, where you can save it as a jpg
or
whatever. You'll need to be able to crop it to get rid of the window
stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[David McRitchie]

Thanks Earl,

 

[sgood73730]

Hi S. Good,
I expect you could try converting a copy of the workbook sheet to HTML
If you do get your headers then you would find the pictures in a folder
with the same name as the workbook. I don't really think you will see
the same headers in HTML that you have in Excel, but even if you don't
they should be saved so that round tripping would work.

I have Excel 2000 so I can't have a picture in the header. In a cell and in
rows to repeat , yes, but not in a header.

Work with a copy of your workbook to keep things from going bad.

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the physical
screen space you can. Now do a print preview, and if it looks as though you
have all of the picture, capture it with Alt-Print Scr. This will put the
screen image of the active window on the clipboard. You can paste that into
most any image program, including Paint, where you can save it as a jpg or
whatever. You'll need to be able to crop it to get rid of the window stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[sgood73730]

Hi S. Good,
I expect you could try converting a copy of the workbook sheet to HTML
If you do get your headers then you would find the pictures in a folder
with the same name as the workbook. I don't really think you will see
the same headers in HTML that you have in Excel, but even if you don't
they should be saved so that round tripping would work.

I have Excel 2000 so I can't have a picture in the header. In a cell and in
rows to repeat , yes, but not in a header.

Work with a copy of your workbook to keep things from going bad.

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the physical
screen space you can. Now do a print preview, and if it looks as though you
have all of the picture, capture it with Alt-Print Scr. This will put the
screen image of the active window on the clipboard. You can paste that into
most any image program, including Paint, where you can save it as a jpg or
whatever. You'll need to be able to crop it to get rid of the window stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

 

[sgood73730]

Hi S. Good,
I expect you could try converting a copy of the workbook sheet to HTML
If you do get your headers then you would find the pictures in a folder
with the same name as the workbook. I don't really think you will see
the same headers in HTML that you have in Excel, but even if you don't
they should be saved so that round tripping would work.

I have Excel 2000 so I can't have a picture in the header. In a cell and in
rows to repeat , yes, but not in a header.

Work with a copy of your workbook to keep things from going bad.

sgood,

The original jpg (if that's what the original source was) seems to be
embedded in an Excel workbook file. The size of the saved file appears to
increase by the size of the header picture file. So it's all there. Try
this:

This will attempt to capture the picture from the screen, first making the
picture as large as possible to use the most possible screen pixels. The
picture will likely be of lower resolution, depending on the original
resolution, as it will have been resampled to that of the screen.

Optional: Set your screen resolution to the highest your system supports.
Control panel - Display - settings. This will give you the most pixels on
the screen. Stuff you see will be smaller, but you can set it back when
you're done.

First, get rid of all the stuff on the sheet (you don't have to save the
workbook, so you won't permanently lose it). Or copy the sheet. Make sure
that the gridlines option (Print preview - Sheet) is not on.

If the picture is wider than it is tall, you may want to change the print
orientation to landscape.

Raise the header margin as high as possible, and the footer margin as low as
possible. The other margins do not control the extents of the header
picture, so they don't matter.

Now make the header picture as large as you can without going off the edge
of the printed page. Do this in Page setup - Header/Footer tab, Custom
header. Put the cursor in the &[Picture] code, then click the formatting
button (far right, in Excel 2002 at least). You should be in the Format
Picture dialog. In the Size tab, adjust the height and width boxes until
the picture fills up the available space when you do print preview. In the
Picture tab, make sure there's no cropping.

Make sure the Excel window is maximized -- you want to use all the physical
screen space you can. Now do a print preview, and if it looks as though you
have all of the picture, capture it with Alt-Print Scr. This will put the
screen image of the active window on the clipboard. You can paste that into
most any image program, including Paint, where you can save it as a jpg or
whatever. You'll need to be able to crop it to get rid of the window stuff,
like toolbar buttons (I don't think Paint can do that).
--
Earl Kiosterud
www.smokeylake.com

I lost the original .jpg file that was imbedded in the header of a file
"&[picture]". Aside from the standard formatting features that are
available in the "Header and Footer"/"Custom Header"/"Format Picture"
menus, is there a way to copy the picture so that I may make some
modifications to it? I have attempted the usual copy/paste commands
and placed the image in "Paint" and the like. There is a major loss in
the resolution which renders it unusable. Any help would be greatly
appreciated.

David McRitchie - You are awesome! I saved an individual worksheet out
of the 31 sheets that I have in the workbook and realized that it
didn't work for the individual sheets. Then I saved it as a webpage for
the entire workbook selected as the option: success! Every .jpg file
was saved in my subdirectory. This will now allow me to edit each one
individually. The images happen to be individual floor plans for a
high-rise building. Thank you so much. I can't tell you how frustrating
it has been going through a number of good reference books and
websearching and never seeing this instruction or guidance, not to
mention the amount of time that it would have taken to scan the
individual sheets. Even with scanning, there would have been a loss in
resolution with numerous errors. What I have now, are the original
images.

Thanks Again,
Steve Goodwin

 

[sgood73730]

David McRitchie - You are awesome! I saved an individual worksheet out
of the 31 sheets that I have in the workbook and realized that it
didn't work for the individual sheets. Then I saved it as a webpage
for the entire workbook selected as the option: success! Every .jpg
file was saved in my subdirectory. This will now allow me to edit each
one
individually. The images happen to be individual floor plans for a
high-rise building. Thank you so much. I can't tell you how
frustrating it has been going through a number of good reference books
and websearching and never seeing this instruction or guidance, not to
mention the amount of time that it would have taken to scan the
individual sheets. Even with scanning, there would have been a loss in
resolution with numerous errors. What I have now, are the original
images.
Thanks Again,
Steve Goodwin

 

[sgood73730]

Earl Kiosterud - You are awesome! I saved an individual worksheet out
of the 31 sheets that I have in the workbook and realized that it
didn't work for the individual sheets. Then I saved it as a webpage
for the entire workbook selected as the option: success! Every .jpg
file was saved in my subdirectory. This will now allow me to edit each
one individually. The images happen to be individual floor plans for a
high-rise building. Thank you so much. I can't tell you how
frustrating it has been going through a number of good reference books
and websearching and never seeing this instruction or guidance, not to
mention the amount of time that it would have taken to scan the
individual sheets. Even with scanning, there would have been a loss in
resolution with numerous errors. What I have now, are the original
images.

Thanks Again,
Steve Goodwin