Consulting

Results 1 to 4 of 4

Thread: VBE help

  1. #1
    VBAX Regular countingapples's Avatar
    Joined
    Aug 2004
    Location
    Kennewick, WA
    Posts
    28
    Location

    Question VBE help

    Hi everyone,

    A friend of mine sent me the following:

    Problem with my Excel Installation?

    My Visual Basic Editor seems to have disappeared! Press Alt+F11, nothing happens. Tools/Macro/VB Editor, nothing happens. Using Controls Toolbox, create a Button. Right Click, select View Code, nothing happens........

    I've re-inserted my Office disk and told it to "Repair Installation". It does and seems to reinstall quite a few files. tried all the above again, and still no Editor....any suggestions?

    Can anyone here help? This is beyond my meager skills.

    countingapples

  2. #2
    Hello Apples ...

    You didn't mention which OS your friend is using but I'll assume it is XP. Make sure you have the following file in place:

    C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL

    This is the dll that pretty much runs the VBE. Your version may differ (I'm using 2000) but something very similar must be there. There are other dlls and various files in the directory as well. There are also a number of references in the registry but there are far too many to go through individually.

    If the OS is Windows XP, has your friend considered doing a system restore to a point before this all happened? No, not the factory reinstallation but something very similar to Go Back. Sometimes it works and sometimes it doesn't ... but it can't hurt to try.

    Another option that might work out well is to uninstall Office but also to delete all leftover relevant directories (including program files\common files\microsoft shared and then any references to Office or VBA ... also delete any office references in documents and settings\(your user name directory)\application data\microsoft and references in there. Lastly search through the registry and remove any excel entries. Almost all software leaves a LOT of residual garbage behind after a normal uninstall which is why you need to delete leftover directories and registry entries. A corrupted or infected file left behind will possibly corrupt future reinstallations. Incidentally, if you are not comfortable maneuvering through the registry it is best to stay away from it. Then reboot and reinstall the entire package with all the custom choices your friend might need. I make my living fighting with Windows and other software issues in addition to troubleshooting hardware which probably explains my growing lack of hair.

    Hope there is something in all that that helps.
    Ken

  3. #3
    VBAX Regular countingapples's Avatar
    Joined
    Aug 2004
    Location
    Kennewick, WA
    Posts
    28
    Location
    Thanks Ken,

    I've passed the info on and will let you know how it goes.

    Karen

  4. #4
    VBAX Regular countingapples's Avatar
    Joined
    Aug 2004
    Location
    Kennewick, WA
    Posts
    28
    Location

    Solved: VBE help

    Just heard back from my friend.

    He had a dual monitor setup. When he removed the second monitor, he forgot to reset all the software back to single monitor settings.

    Thanks again for your help Ken.

    Karen

Posting Permissions

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