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
Re: Saving Excel range to WMF file
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.
HTH
Re: Saving Excel range to WMF file
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...
Re: Saving Excel range to WMF file
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?