PC Review


Reply
Thread Tools Rate Thread

copy picture from footer to worksheet

 
 
=?Utf-8?B?SmFrb2JzaGF2biBJc2JyYWU=?=
Guest
Posts: n/a
 
      10th Nov 2006
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      10th Nov 2006
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
 
Reply With Quote
 
=?Utf-8?B?SmFrb2JzaGF2biBJc2JyYWU=?=
Guest
Posts: n/a
 
      10th Nov 2006
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
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy and Paste Chart as Picture into another workbook or worksheet =?Utf-8?B?U3RldmVD?= Microsoft Excel Charting 1 15th Feb 2007 11:47 PM
How to copy worksheet layout, values and graph as picture =?Utf-8?B?RXhjZWxlcmF0ZS1ubA==?= Microsoft Excel Programming 1 12th Dec 2005 02:08 PM
Is it possible to copy a header/footer from one worksheet to anoth =?Utf-8?B?RExD?= Microsoft Excel Misc 1 28th Sep 2005 02:01 PM
How do I copy the picture form a Excel worksheet which protected =?Utf-8?B?c2FsaW5h?= Microsoft Excel Misc 2 14th Oct 2004 12:23 AM
VBA to copy a worksheet to word as a picture Marc Microsoft Excel Programming 1 3rd Sep 2003 12:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:15 AM.