Saving Excel range to WMF file

Does anyone know how to go about taking a range from Excel and recording it into a windows metafile graphic format? Is there some kind of Windows API or do I need to use third party dlls for that? Any advise would be greatly appreciated!

Thanks,
Denis

I think you may have to use a screenshot since I dont see any methods for wmf.:(
Checkout the keyb_event API for screenshot functionality.

Use this const for snapshot.

VB Code:

Const VK_SNAPSHOT = &H2C

HTH

Thanks RobDog888.

The only problem with that is that the screen contains more than just the range that I need. I need to generate a screenshot from the range in wmf format and store it to the disk to be used for later use. I am researching how to do it through API but it is quite over my head...

I may be off on this one but how about resizing the child window that holds the
sheets to the size of the selected range. Then do something similar to an
Alt+Print Scrn so it screen captures only the child window?