topic-26531

Board index FiveWin for Harbour/xHarbour Excel / FWH

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Excel / FWH
Posted: Mon Jun 10, 2013 07:07 PM

I need to adjust the size of an image in Excel via my program...
The code below was done with the Excel macro. Can someone please help me convert this so I can adjust the size from within my program?

Code (fw): Select all Collapse

    ActiveSheet.Shapes.Range(Array("Picture 3")).Select
    Selection.ShapeRange.ScaleWidth 0.8163933292, msoFalse, msoScaleFromTopLeft
    Selection.ShapeRange.ScaleHeight 0.8163933794, msoFalse, _
        msoScaleFromBottomRight

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Jeff Barnes

Posts: 933

Joined: Sun Oct 09, 2005 01:05 PM

Re: Excel / FWH
Posted: Wed Jun 26, 2013 12:14 PM

<bump>

Thanks,

Jeff Barnes

(FWH 16.11, xHarbour 1.2.3, Bcc730)

Antonio Linares

Posts: 44158

Joined: Thu Oct 06, 2005 05:47 PM

Re: Excel / FWH
Posted: Wed Jun 26, 2013 02:00 PM

Jeff,

Basically you have to replace the "." with ":"

ActiveSheet:Shapes:Range( { "Picture 3" } ):Select()

Try that, thanks

regards, saludos

Antonio Linares
www.fivetechsoft.com

FiveTech Support Forums

Continue the discussion