Hi,

How should we translate the following Excel macro to xBase?

Sheets("New-Sheet").Move After:=Sheets(4)

I'd like to move the newly inserted sheet to the end (right) position.

Many thanks,

-Itai

Op Thu, 07 Jan 2010 00:35:01 -0800 schreef IBA:

> Hi,
> 
> How should we translate the following Excel macro to xBase?
> 
> Sheets("New-Sheet").Move After:=Sheets(4)
> 
> I'd like to move the newly inserted sheet to the end (right) position.
> 
> Many thanks,
> 
> -Itai

Hi,

I think this should be:

oDoc := yourdocumentobject...
oDoc:Sheets("New-Sheet"):Move(, oDoc:Sheets(4))

Here is a tip:
Open Excel
Alt+F11
F2

And there is your object list as you can use in XBase.

Application is the startpoint that is your ActiveXObject starting point.

Good luck!

Thank you, Ronald.
This is working great.
-Ben