Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is this code ok for 2003 (2003 sp2)

    Greetings,
    Been a while since I posted. The guru's of the site developed this code. Basically, it will cycle through the directly as listed in the code, and copy the data from each of the files it finds. I have since changed from 2000 ver. to 2003 version. It will now NOT work.

    Does the code look ok for 2003?

    Thanks,
    Brad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is this code ok for 2003 (2003 sp2)

    The code in your workbook will not work in any version of Excel. There should be a backslash at the end of the path:

    strPath = "Cocuments and Settingsgz57l1My DocumentsARA WorkloadMetrics"

    Apart from that, the code looks OK - there is nothing specific to a version of Excel.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Is this code ok for 2003 (2003 sp2)

    As always,,, Thanks. Man do I feel like a novice....



    BRad

Posting Permissions

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