Saving Excel Range to Image without using Sendkeys
thanx for your replies there's an export method that can export a range to
png,tiff and other graphic filters on your system
Quote:
> Hi Sandeep,
> range("A1:B2").CopyPicture xlScreen ,xlBitmap
> You can use the CopyPicture method to capture an image (BMP/Picture
> format only). The problem is then how to get the image saved to an
> external file.
> Take a look at the code within my graphics exporter addin to see one way
> of doing this.
> (http://www.andypope.info/vba/gex.htm)
> > Hi
> > I want to save the Range of Excel Cells in Image Format
> > i want to provide user to specify the format whether its bmp
> > ,png,gif,tiff
> > Please Help me To Solve this Problem
> --
> Cheers
> Andy
> http://www.andypope.info
