Excel in VBScript *RESOLVED*
Hi
I'm trying to use vbscript to do some excel formatting. I'm using late binding within vbscript and have figured out how to write parameters after excel methods/properties using the Const value.
e.g.
.ActiveWorkbook.SaveAS "filename", -4143
However, I am having trouble with moving an excel worksheet within an open workbook. The VBA code is similair to this:
Sheets("Sheet2").Select
Sheets("Sheet2").Move Before:=Sheets(1)
Does anyone know what the code shouldlook like in VBScript - it's the Before part that is giving me trouble.
many thanks