ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy picture from footer to worksheet (https://www.excelbanter.com/excel-programming/377194-copy-picture-footer-worksheet.html)

Jakobshavn Isbrae

copy picture from footer to worksheet
 
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

copy picture from footer to worksheet
 
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

Jakobshavn Isbrae

copy picture from footer to worksheet
 
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



All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com