I have a picture in the footer of one of my work sheets. How can I copy this
picture and paste it in the worksheet itself??

Thanks in advance for any suggestions
--
jake

Manually?

If you're using xl2002 or higher...

Save a copy of the file as a web page:
file|saveas
Save as type: Web Page (*.htm; *.html)

Then close excel

Use windows explorer to go to that folder that holds the file you just saved.
Look for a new subfolder that has the name of the file followed by _files, like:

Book1_files

You'll see a bunch of files there including the picture file.

I don't have any idea how this could be mechanized.

Jakobshavn Isbrae wrote:

I have a picture in the footer of one of my work sheets. How can I copy this
picture and paste it in the worksheet itself??

Thanks in advance for any suggestions
--
jake

--

Dave Peterson

Thank you Dave. It looks like I can get ALL the pictures in the workbook
this way, not just the footer of a single sheet.

While automation is nice, it is not necessary. I would have to know which
..jpgs hold which pictures.


Thanks again...
--
jake


"Dave Peterson" wrote:

Manually?

If you're using xl2002 or higher...

Save a copy of the file as a web page:
file|saveas
Save as type: Web Page (*.htm; *.html)

Then close excel

Use windows explorer to go to that folder that holds the file you just saved.
Look for a new subfolder that has the name of the file followed by _files, like:

Book1_files

You'll see a bunch of files there including the picture file.

I don't have any idea how this could be mechanized.

Jakobshavn Isbrae wrote:

I have a picture in the footer of one of my work sheets. How can I copy this
picture and paste it in the worksheet itself??

Thanks in advance for any suggestions
--
jake

--

Dave Peterson