Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Bogangar NSW Australia
    Posts
    154
    Thanks
    29
    Thanked 3 Times in 2 Posts

    Excel 2010: Visual Basic Error on Closing Excel

    Hi All Excel Experts,

    I have just edited an xlam file and reinstalled it. The VBA procedures within that file are working as expected.

    However, now every time I close (exit) Excel I get the following error message:

    20140412 Excel Error on Closing.JPG

    The Help on the error dialogue is, as usual, not particularly helpful

    20140412 Excel Error Help.JPG

    I've searched all the locations where file are located and saved etc under File|Options, including the locations of all Add-Ins and can find nothing amiss.

    Any suggestions as to where to look or try next will be appreciated.

    Cheers

    Trevor

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Diaable the Addins until you find the program you know causes the problem. you may have to change the setting (I presume it is protected) to allow it to be debugged so you can see the line causing the problem. That may help allow you to track the error.

    [The error message sounds to me like the path and/or file is named correctly, but it is located where you don't have access to it or it is read-only or something like that...]

    It would be helpful to us to see the line of code that is causing the problem...
    Steve

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Upon closing, are any of the Add-in procedures coded to write/save data to a folder or file whose path may have changed?
    Last edited by Maudibe; 2014-04-14 at 16:48.

Posting Permissions

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