Excel Command

Jeff Barnes · Post by **Jeff Barnes** » Tue Apr 03, 2007 11:25 pm

Hi Everybody,

I am trying to reduce the size of an image in excel but I am having problems converting the excel code in to fw.

Can someone please help...

Excel Code:

Code: Select all

Selection.ShapeRange.LockAspectRatio = msoTrue
Selection.ShapeRange.Height = 286.5
Selection.ShapeRange.Width = 657#
Selection.ShapeRange.Rotation = 0#

Thanks,
Jeff

Jeff Barnes · Post by **Jeff Barnes** » Wed Apr 04, 2007 12:00 am

I figured it out...

Code: Select all

      oSheet:Pictures:Height:= 286.5
      oSheet:Pictures:Width:= 657

Jeff

Jeff Barnes · Post by **Jeff Barnes** » Thu Apr 05, 2007 2:31 pm

Thought I had it.... but those commands make all the images get rezised.

Does anyone know how to resize an image as it gets inserted to the excel file?

Thanks,
Jeff