FiveTech Software tech support forums

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.

César E. Lozada wrote: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  Expand view

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

EMG

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