Move excel sheets

[César E. Lozada]

Hi,

Anybody knows what's the traduction of this macro from VB to xH/FWH?


Sheets("Sheet1").Select
Sheets("Sheet1").Move After:=Sheets(3)


Thanks a lot.

[Enrico Maria Giordano]

Hi,

Anybody knows what's the traduction of this macro from VB to xH/FWH?


Sheets("Sheet1").Select
Sheets("Sheet1").Move After:=Sheets(3)


Thanks a lot.

Try

Code: Select all

oExcel:Sheets( "Sheet1" ):Select()
oExcel:Sheets( "Sheet1" ):Move( , oExcel:Sheets( 3 ) )

EMG

[Jeff Barnes]

You should also be able to do this:

oSheet := oExcel:Sheets(“oSheet1”)
oExcel:Sheets( "oSheet2” ):Move( oSheet )

This example will move sheet2 infront of sheet1


Jeff