Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Lost me references! (XL97/WinNT4)

    <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15>

    <img src=/S/help.gif border=0 alt=help width=23 height=15> <img src=/S/please.gif border=0 alt=please width=31 height=23> !!

    I just tried to debug some code I'd written and it told me that "Date" wasn't a valid reference ("compile error: can't find project or library") (on code that worked perfectly last time I tried it) <img src=/S/confused.gif border=0 alt=confused width=15 height=20> so I went to check Tools, References - and it won't even open the window! It says "object library not registered" !!!

    I've rebooted the machine, reverified the installation of XL, looked in the XL VBA help (nothing at all) and on the MSKB (ditto, for both XL and VBA) and I can't find out what's going on at all!

    Please, someone tell me how to get it running again - I can't do anything at all with it like this!

    <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> <img src=/S/weep.gif border=0 alt=weep width=21 height=16>
    Beryl M


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

    Re: Lost me references! (XL97/WinNT4)

    Do you have TextBridge OCR software installed? You can check for this by searching for a file named TbRun97.xls or TbRun9.xls. If you do find it:
    - Make sure that Excel is not active
    - Move the TbRun97.xls or TbRun9.xls file to another folder.
    - Start Excel, and see if you can get into Tools | References now, and if the code works.
    If not, we'll have to search further.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Lost me references! (XL97/WinNT4)

    Hi Hans, thanks for the suggestion, but no, I don't have textbridge installed. We've only got two scanners in the company, and neither are even in this building, let alone anywhere near my machine!

    I'm afraid I was too desperate to get it working again to wait, so I ended up completely uninstalling and reinstalling Office, and once I removed some registry links that were unremovable by the de-installation program, I got it running again.

    However, in the process I've now lost Outlook so I'm about to go off and deal with that ...!
    Beryl M


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

    Re: Lost me references! (XL97/WinNT4)

    >> However, in the process I've now lost Outlook

    That's the law of conservation of misery in action...

    My next suggestion would have been to look at <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post> by Jan Karel Pieterse. Perhaps something to keep in mind for next time, but let's hope it won't occur again...

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Lost me references! (XL97/WinNT4)

    Thanks, Hans, I'll keep a note of it for next time (which I shall devoutly hope does not happen!).
    Beryl M


Posting Permissions

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