+ Reply to Thread
Results 1 to 6 of 6

VBA sub works perfectly on my PC using a "shared directory" but not on my colleague's

  1. 06-14-2010, 04:39 PM #1
    honest
    honest is offline
    Registered User
    Join Date
    04-20-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    VBA sub works perfectly on my PC using a "shared directory" but not on my colleague's

    Hello all
    I created an Excel sub that run with no problem on my machine. The file is located in our "shared directory" that every colleague has access too. What might be the reason? any help will be appreciated.

    Regards,
    Reply With QuoteRegister To Reply
  2. 06-14-2010, 05:12 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: VBA sub works perfetcly on my PC using a "shared directory" but not on my colleag

    Mapped drive? Use the UNC path in the macro.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 06-14-2010, 05:14 PM #3
    Leith Ross
    Leith Ross is offline
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA sub works perfetcly on my PC using a "shared directory" but not on my colleag

    Hello honest,

    More information is needed to pinpoint the problem.
    1. Is an error generated? If so, what is the message or number of the error?
    2. Can you post the code you are using?
    3. What Operating system are you using and that of your colleague?
    4. What computers (make and model) are you both using?
    5. What versions of Excel are you both using?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)
    Reply With QuoteRegister To Reply
  4. 06-14-2010, 08:32 PM #4
    honest
    honest is offline
    Registered User
    Join Date
    04-20-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VBA sub works perfectly on my PC using a "shared directory" but not on my colleag

    Ok..thanks guys..I will run it again and give you more details...thanks....
    Reply With QuoteRegister To Reply
  5. 06-15-2010, 11:48 AM #5
    honest
    honest is offline
    Registered User
    Join Date
    04-20-2010
    Location
    Toronto
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VBA sub works perfectly on my PC using a "shared directory" but not on my colleag

    Ok here are some details:

    1-Is an error generated? If so, what is the message or number of the error?


    Answer: Yes......msg is "Subscipt out of range"


    2- Can you post the code you are using?

    Yes I can ..it's just a bit long...


    3-What Operating system are you using and that of your colleague?

    Windows


    4-What computers (make and model) are you both using?

    Dell

    5-What versions of Excel are you both using?

    2003




    Thanks...regards,
    Reply With QuoteRegister To Reply
  6. 06-15-2010, 12:10 PM #6
    romperstomper
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: VBA sub works perfectly on my PC using a "shared directory" but not on my colleag

    Well, without code, this will be a guess but:
    If you are both running the same macro against the same workbook, then I would guess that one of you has Explorer set to show file extensions and the other doesn't and your code refers to Workbooks("blah") or Windows("blah") without using the .xls extension in the file name.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1