+ Reply to Thread
Results 1 to 7 of 7

VBA doesn't work on different users of the same computer

  1. #1
    Registered User
    Join Date
    05-29-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    VBA doesn't work on different users of the same computer

    I have created a macro that runs multiple macros to automate a process in excel. The code is saved on the shared drive, but doesnt work on one user on one computer. It works on my account, and on other computers and accounts on the floor, and even works on the computer in question from my account. The only person it doesnt work on is the end user, the IT department has no idea why.

    I have checked Macro security, certificates and error settings. We run on Excel 2003 (I know, old-school). The code isnt vert complicated and doesnt refer specifically to any accounts or workbooks. This is a sample of the code below. Any help would be greatly appreciated.

    Thanks!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA doesn't work on different users of the same computer

    what does 'doesn't work' mean? doesn't run, causes an error, does something wrong?
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: VBA doesn't work on different users of the same computer

    What does "doesn't work" actually mean?

    Can the user open the workbook?
    Can they run the code? If so does it generate an error?

    Given the code works it will be very difficult to remotely diagnose
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    05-29-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VBA doesn't work on different users of the same computer

    No, so the original macro runs 6 different macros. This was number 3. All other macros run but because this one is needed it comes up with an error. Each macro runs on its own except this one. When I run it from her computer it deletes the blank rows but doesnt delete the rows with certain keywords (the actual code has 12 different keywords I posted this code with one to avoid confusion).

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA doesn't work on different users of the same computer

    the problem may just be that you haven't specified all the arguments for Find-perhaps
    Please Login or Register  to view this content.
    excel remembers all those search parameters between searches (both code- and user-initiated)

  6. #6
    Registered User
    Join Date
    05-29-2013
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: VBA doesn't work on different users of the same computer

    That seemed to work, Thanks JosephP

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA doesn't work on different users of the same computer

    you're welcome :-)

+ 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