Need VBScript Equivalent of VBA Excel Copy Method 1

[Rob94]

Can anyone help me find the VBScript eqivalent of the VBA code listed below? I'm pretty sure VBScript does not support named arguments, so I'm even wondering if this is even possible. Here it is:

Sub Macro2()
    Sheets("Sheet1 (2)").Select
    Sheets("Sheet1 (2)").Copy Before:=Workbooks("Book2").Sheets(1)
End Sub

Any help would be greatly appreciated.

 

[tsuji]

Hello Rob94,

Just make the named arguments to positional usually suffice.

Sub Macro2()
    Sheets("Sheet1 (2)").Select
    'case needed "before"
    Sheets("Sheet1 (2)").Copy Workbooks("Book2").Sheets(1)
    'case needed "after
    Sheets("Sheet1 (2)").Copy ,Workbooks("Book2").Sheets(1)
End Sub

regards - tsuji

 

[Rob94]

In the "case needed after" section, do I need to put a set of empty quotation marks before the comma, like this:

'case needed "after
Sheets("Sheet1 (2)").Copy "",Workbooks("Book2").Sheets(1)

Sorry, I'm not in a psoition to test this code out yet, but I wanted to ask the question first. Thanks!

 

[Rob94]

tsuji,

this worked like a charm. thanks!

 

[tsuji]

Rob94,

Am glad, thanks.

- tsuji