+ Reply to Thread
Results 1 to 3 of 3

Convert "after:=..." to execute within vbs

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    4

    Convert "after:=..." to execute within vbs

    Does anyone know how to convert this code to execute from a vbs file?

    objXL.Sheets("ChartTabName").Move after:=objXL.Worksheets("Daily Report")

    The problem code being bolded.

    Failing that, does someone know how to change the default behavior of .Move from before: to after: ?

    I have a workaround:
    objXL.sheets.Add.move objXL.Worksheets(4)

    but, I would really like to know how to generally convert those after: and before: to execute from a vbs script.
    Last edited by habskilla; 05-02-2005 at 10:49 AM. Reason: Added workaround

  2. #2
    Registered User
    Join Date
    05-02-2005
    Posts
    4
    ^^bump the message back to the top of the heap!

  3. #3
    Registered User
    Join Date
    05-02-2005
    Posts
    4
    Quote Originally Posted by habskilla
    ^^bump the message back to the top of the heap!
    Last bump.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1