How to move worksheet from vbscript

  • Thread starter Thread starter Robert Stober
  • Start date Start date
R

Robert Stober

Hi,

I want to move the last worksheet to be the first, but I don't the syntax
becuase the method usually requires a named argument (Before:=location):

' create an Excel object
set xlApp = CreateObject("Excel.Application")
set xlWb = xlApp.ActiveWorkbook

' move the last worksheet to be the first...
xlWb.Sheets(xlWb.Sheets.Count).Move Before:=xlWb.Sheets(1)

This causes an error. I know that I can't use the Excel named argument
syntax, but then how DO I specify the location to move the sheet?

Many thanks in advance,

Robert Stober
 
Robert Stober said:
Hi,

I want to move the last worksheet to be the first, but I don't the syntax
becuase the method usually requires a named argument (Before:=location):

' create an Excel object
set xlApp = CreateObject("Excel.Application")
set xlWb = xlApp.ActiveWorkbook

' move the last worksheet to be the first...
xlWb.Sheets(xlWb.Sheets.Count).Move Before:=xlWb.Sheets(1)

This causes an error. I know that I can't use the Excel named argument
syntax, but then how DO I specify the location to move the sheet?

Many thanks in advance,

Robert Stober
Click to expand...
For the before method just use:
xlWb.Sheets(xlWb.Sheets.Count).Move xlWb.Sheets(1)

for after I think you need:
xlWb.Sheets(xlWb.Sheets.Count).Move , xlWb.Sheets(1)

For future just open Excel, alt+F11 then F2, choose Excel in top dropdown
box and search on move, you can see the syntax and if you have help
installed press F1 when on the relevant entry.

Joe
 
Back
Top