Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Error in VBA (Excel 2003 SP2)

    Hi there!

    I'm experiencing a very strange behaviour in excel. One of our users is using an excel file with an embedded VBA project. Each time she uses the VBA project she's receiving an error message, something like "error 1400". The strange thing is, if ANY other user is using the very same file, even on the same computer, everything works perfectly fine. We already checked permissions and stuff, but found nothing what could explain this behaviour. We also tried to log on to another computer with her user - the VBA is working exactly as meant. It seems, the error only occurs if this one user is logged on to this one machine. Naturally we tried to eliminate the local profile of the user from the computer, with no success at all. You have ANY idea what could be the problem here?
    Perhaps I should mention that I have absolutely no knowledge of VBA, but I don't think this counts here. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Error in VBA (Excel 2003 SP2)

    I would guess you mean Error 1004 which is a generic "something went wrong" error. We'd probably need to see the code and know what she was doing when it went wrong, as it could be any number of things - having the wrong thing selected, protected worksheet etc.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    Hi Rory!

    What I can tell you is, that the VBA is sorting some values in the selected table and creating a chart from the result. We tried to do EXACTLY the same thing with another user on the same computer. No error, no message just the result we expect. OK, I don't know jack about VBA, but if it's working with one user an not with another one, is it definitely a VBA problem?
    There are no other programs running but excel. On an identical computer, logged in with her user, it's also working.
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Error in VBA (Excel 2003 SP2)

    Well, there must be a problem with the VBA in some regard, or you wouldn't be getting an error! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    If we can see the code, we may be able to narrow down the possible causes.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    Good point you got there! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    I'll try to get the code for ya (the VBA ist password protected), should just take a minute (+ a phone call). In the meantime I have to be annoying again: How can an error in an VBA occur with one user and not with another? Even though both have the same permissions and are doing exactly the same things. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

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

    Re: Error in VBA (Excel 2003 SP2)

    These things happen, and it's usually difficult to find the exact cause. Without seeing the code it is impossible. That's why Rory asked to see it.

  7. #7
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    Seem's like we have a problem. The only guy who could possible know the passwort for this VBA is not in the office today. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15>
    I'll try to reach him, but don't expect to be successful. As soon as I have some new info I'll post it here.
    In the meantime, thanks a lot for your help. What would I do without you guys? <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    In the mean time, try this:

    - empty the temporary folders.
    - Do a search and search for files with extension .exd. Delete all of them

    If that helps, great. If it doesn't, I'd suggest to do a Help, detect and repair from Excel.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Star Lounger
    Join Date
    May 2002
    Location
    Wels, Oberösterreich, Austria
    Posts
    64
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    Hi Jan Karel!

    You're awesome, the .exd files did the trick! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    I tried to delete the temporary files before, but that changed nothing. As soon as I deleted the .exd files it worked just fine. What kind of files are they anyway? I've never heard of them before.
    Thank you very much, great work everyone.
    Philipp
    __________________________________________________ ________
    Murphys Law rules the world, bow to it!

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error in VBA (Excel 2003 SP2)

    They are (as far as I know) temporary picture files of controls (dropdown, listbox, button, ...) on Excel worksheets.
    They *should* get removed as soon as the associated Excel file is closed, but sometimes some are left trailing behind and cause havoc, as your user experienced.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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