How do you save an area of a worksheet as an external picture?

[CompEngr]

I'm creating a program that creates drawings using shapes. Once I have a drawing I want to copy the part of the screen it occupies as a bitmap and then save that as an external file. The code to capture it as a bitmap is shown below. Once I have the picture it is in the clipboard. How do I save the contents of the clipboard as an external file or how do I paste the picture as an image into the workbook and then save it as an external file? I thought of adding it as the background image to a blank chart and then saving the chart but I'm sure there is a more direct way to do it.

Range("A6:CT11").Select
Selection.Copy
Application.CutCopyMode = False
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap

[Keebellah]

Take a look here, this is the main idea.
You can change it to your exact need;
http://officetricks.com/print-screen...tomate-in-vba/

[Richard Buttrey]

Hi,

Here's one way

Please Login or Register  to view this content.

[Keebellah]

That's what the link says too

[Richard Buttrey]

That's what the link says too

I didn't even look at the link. It's a procedure I've had in my toolbox for a few years. The link must have come from the same source.

Presumably it does what the OP wants?

[Keebellah]

I guess so too. I have the same thing, this same code I have saved on a disk somewhere so I just looked up the link for this post.

[CompEngr]

Thanks for your reply. I will give it a try.