How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!

You could do an Alt+PrintScr to capture the image, crop the unwanted elements
from the image after pasting it into Word (Ctrl + V) and rotate the image as
needed.


--
Kevin Backmann


"sir23" wrote:

How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!

Thanks for the suggestion, but this isn't a simple "cut/paste" problem. The
format for the picture must be "MS Office Drawing Object". I've tried
various avenues to convert from Excel to this specific format, but no
application I can find will convert to this exact format.

Any other suggestions would be greatly appreciated!

"Kevin B" wrote:

You could do an Alt+PrintScr to capture the image, crop the unwanted elements
from the image after pasting it into Word (Ctrl + V) and rotate the image as
needed.


--
Kevin Backmann


"sir23" wrote:

How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!

Select the range.

SHIFT + Edit.

Select Copy Picture.........as shown on screen.

Open Word and Paste SpecialPicture(Enhanced Metafile)

This you can rotate.

If you want the data picture to be dynamic in Word, use the Camera Tool to take
the picture and paste special etc.

Camera Tool is found under ToolsCustomizeCommandsTools


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 09:25:01 -0800, sir23
wrote:

How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!

Thanks, but an enhanced metafile isn't the same as an MS Office Drawing
Object - rotating the picture isn't the issue, matching the exact format is.

Thanks, but still looking...

"Gord Dibben" wrote:

Select the range.

SHIFT + Edit.

Select Copy Picture.........as shown on screen.

Open Word and Paste SpecialPicture(Enhanced Metafile)

This you can rotate.

If you want the data picture to be dynamic in Word, use the Camera Tool to take
the picture and paste special etc.

Camera Tool is found under ToolsCustomizeCommandsTools


Gord Dibben MS Excel MVP

On Mon, 18 Feb 2008 09:25:01 -0800, sir23
wrote:

How would I save a selected range from an MS Excel worksheet into a MS Office
Drawing Object - the picture format that can be easily rotated in MS Word.
Unfortunately no other picture formats will substitute... Thanks!