topic-6582

Board index FiveWin for Harbour/xHarbour Excel Command

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Excel Command
Posted: 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 Collapse

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

Thanks,
Jeff

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Excel Command
Posted: Wed Apr 04, 2007 12:00 AM

I figured it out...

Code: Select all Collapse

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

Jeff

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Excel Command
Posted: Thu Apr 05, 2007 02: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

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

FiveTech Support Forums

Continue the discussion