Excel macro code 2 VFP

[glamb]

I have a macro with the following code:

ActiveWindow.SmallScroll Down:=-3
Does anyone know the translation into VFP

 

[Mike Lewis]

If oXL is your Excel object, then the equivalent code is:

oXL.ActiveWindow.SmallScroll(3)

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Mike Lewis]

Just noticed that it should be -3 rather than 3. But the general idea is the same.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

ActiveWindow.SmallScroll Down:=-3

In a generic syntax this could be written as
Object.Method Parameter:=value

This is typical to VB, called "namend parameters". VFP doesn't support it, but it doesn't matter. Lookup the method, in this case Smallscroll() in the Visual Basic For Applications help and then you will see the definition of parameters:

SmallScroll(Down, Up, ToRight, ToLeft)

So Down is really the first parameter. If your makro would be

ActiveWindow.SmallScroll ToRight:=2

Then the VFP translation would be

oXL.ActiveWindow.SmallScroll(,,2)

That is you omit the first two parameters Down and Up. This should give you a more general idea on how to translate VB method calls to VFP.

Bye, Olaf.

 

[glamb]

Thanks so much, all, this was very helpful.