Results 1 to 8 of 8

Thread: Opening Files

  1. #1
    New Lounger
    Join Date
    Feb 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Files

    For several days I haven't been able to open Excel files from desktop shortcuts or from within the "MY DOCUMENTS" folder. When I try, I receive the message "Cannot find the file * (or one of its components). Make sure the path and file name are correct and that all required libraries are available." I'm still able to open files within the open files dialog. Would reinstalling Excel fix the problem? I'm using Excel 97 SR-2. Thanks.

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Massachusetts
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    In Excel, look at Tools-Options-General, uncheck "Ignore Other Applications"

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    How about re-connecting what type of program to use to open the file? From Windows Explorer, select View, then folder options. Then select File Types. Scroll down the list to Microsoft Excel Worksheet and highlight. Make sure that Opens with says Excel. If it doesn't, you may have to edit it.

  4. #4
    New Lounger
    Join Date
    Feb 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    Thanks for your response. I did as you suggested and the problem was fixed. Any idea how the "Ignore other applications" box could have become checked?

  5. #5
    New Lounger
    Join Date
    Feb 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    Thanks for the suggestion. I checked in the "file types" dialog and the Excel Workbooks entry was OK.

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Massachusetts
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    Martin,
    The only time I have seen that get checked, is when a user has checked it; but although I'm not sure how, I would not doubt that something else could have set it, such as a template. (There is an Application.IgnoreRemoteRequests property in VBA that could have done it).

  7. #7
    New Lounger
    Join Date
    Feb 2001
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Files

    I was using Excel with a DDE link to real-time financial data when I first noticed my problem if that might give you a clue as to the cause. Thanks again for your help.

  8. #8
    BAM
    Guest

    Re: Opening Files

    Hi Martin,

    Sometimes this is caused by a problem with the file association. Even though it may look correct, there could still be a problem in the Registry. Try re-registering Excel and in doing so this will rebuild your file associations.

    For this go to Start/Run and run the following command:
    excel /regserver

    Note that there is a space before the forward slash.
    ~~~~~~~~~
    Cheers!

Posting Permissions

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