Excel Command

[Jeff Barnes]

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  Expand view

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


Thanks,
Jeff

[Jeff Barnes]

I figured it out...

Code: Select all  Expand view

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


Jeff

[Jeff Barnes]

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