Range.copyPicture behaves differently??
 

Essentially I want to copy a range and save it as a bitmap.
I have code that worked in excel 97, 200, 2003 to do this
it used copypicture to copy the ranges
ie. myrange.copypicture xlscreen, xlbitmap

in older versions of xl this left on my clipboard - bitmap,DIB and dibv5 files
in 2007 on the clipboard is enhmetafile and enh metafilepict. which apear to
incompatible with the code that i am using to retreive the bitmap off of the
clipboard.

Does any one know if there is documentation somewhere about this change to
functionality. or how to achieve my objective of saving a range to a bitmap
without using the copypicture function??

Thank you
Mike Myers