Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File Not Found (Visual Basic Error) (97)

    Everytime I open Excel, an error message appears stating "Error Not Found". The title bar says Microsoft Visual Basic.

    I have my macros stored in my personal.xls spreadsheet, which resides in xlstart.

    All of the macros seem to work.

    Any suggestions?

    Many thanks!

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    Is there a Debug button in the error box? If so, then it should show you what caused the error when you click it.

    If not, then how are you opening Excel? By double clicking a .xls file? By using the start menu? Double clicking an Excel program shortcut?
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    No, there is no debug option available. Just OK and help. The help doesn't help much.

    This is what the help file tells me.

    <blockquote><hr>Can't find specified file

    The file was not found where specified. This error has the following causes and solutions:

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: File Not Found (Visual Basic Error) (97)

    Do any of the macros use the Kill, Name, File, or Workbooks() Methods/properties? If you are not getting the error line highlighted in yellow, which is strange, you can use Find to locate these words, and then see if the referenced path and filename are valid or in the case of Workbooks() if the file is not open.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    Could be happening on a protected add-inm so code is not available.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: File Not Found (Visual Basic Error) (97)

    True, but he states it is code in his personal.xls. Another possibility is that the code modules in his personal.xls are Locked for viewing and Password protected, but I hope, since it's his personal.xls, that he can unlock those settings.
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    If you have active AddIns, try disabling them all (Tools, AddIns and uncheck all) and restart Excel. If that fixes the problem, re-introduce the AddIns one by one until the the problem presents itself once again. It could be that excel is trying to load an add in that has become lost.

    Andrew C

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    Ok, then two things to try.

    1- Remove all files from your XLStart directory. Move the files out of the directory to another directory, don't just rename them. If the problem does not occur, then put the files back in one at a time until you find the one causing the problem.

    2- Select Add-ins from the Tools menu. Make a list of all of the add-ins that are checked and then uncheck them all. If the problem goes away, then check the add-ins one at a time until you find out which one is causing the problem.
    Legare Coleman

  9. #9
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Not in KC anymore
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File Not Found (Visual Basic Error) (97)

    I removed all the add-ins...same result.

    I then removed all the files from my XLStart folder.

    This file was the culprit:
    50A93000

    Opened it with wordpad and it was 387 pages long. All gobbledygook. Made out a few things that looked like VBcode I had written.

    It was about the same size as my personal.xls worksheet.

    Everything seems to work fine now.

    Thanks a bunch.

Posting Permissions

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