Results 1 to 3 of 3

Thread: Excel in VBScript *RESOLVED*

Threaded View

  1. Oct 13th, 2003, 06:01 AM #1
    R00tj00se1
    R00tj00se1 is offline

    Thread Starter
    New Member
    Join Date
    Oct 2003
    Posts
    4

    Post 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
    Last edited by R00tj00se1; Oct 14th, 2003 at 04:12 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width