Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    All Macros Stopped Working

    I am suddenly getting an error message when I try to run ANY of my macros:

    "A document with the name Personal.xls is already open. You cannot open 2 documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents."

    The problem is, I have just opened Excel and don't have 2 Personal.xls open?

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20> Any ideas?
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

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

    Re: All Macros Stopped Working

    Hi Sherry,

    It is possible that Excel is trying to load 2 separate files called personal.xls. The best thing to do is to search for personal.xls using Start, Find, Files or Folders, and see if you can locate more than one file. If so you should rename them all - you will probably be prevented from renaming the one that is loaded in Excel (assuming that Excel is open). You can then load them and check to see if they contain any macros that are not in the file that is loaded. If they do just copy the macros to the existing file and close and delete.

    Andrew C

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: All Macros Stopped Working

    Hi Andrew,
    I did as you said and there is only one copy of personal.xls on my system. I moved it out of xlstart and then opened Excel and recorded a macro in a clean version of personal.xls. Then I replaced the new version with the old version - with the same results!?

    I don't have a clue of what to do next - do you?
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

  4. #4
    Lounger
    Join Date
    Apr 2001
    Location
    Michigan, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: All Macros Stopped Working

    Just a shot in the dark:
    If you go to Tools>Options>General,
    is there anything listed in "Alternate startup file location:"?

    Mark

  5. #5
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: All Macros Stopped Working

    No, BUT I just realized something! Yesterday the IT dept installed Win98 on my PC. AND they divided my hard drive into C, D, and E. The location of personal.xls has moved from C:Program FilesMicrosoft OfficeOfficeXlstart to E:Program FilesMicrosoft OfficeOfficeXlstart.

    So, could Excel be confused even though there is only one personal.xls?
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

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

    Re: All Macros Stopped Working

    Whenn you did a search for persoanl.xls, did you search all drives, i.e. C, D and E. Is it possible that a copy was left on Drive C

    Andrew

  7. #7
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: All Macros Stopped Working

    Yes, I searched all local drives and it only found one copy - the one on the E drive.

    And I just tried creating a folder in C:Program FilesMicrosoft OfficeOfficeXlstart - and putting personal.xls there. That didn't work either.
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

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

    Re: All Macros Stopped Working

    How are you executing the macros? From the list under Tools/Macros, or from a button on a sheet or form or from a menu?

    I am guessing that your Personal.xls was moved to drive E: and is now being automatically opened from there when you start Excel. If you are running the macro from a button or menu, then the button or menu might have a path to the macro that is pointing at the old location. That would cause Excel to think it needs to open Personal.xls from the C: drive, which would cause the error even if the file on the C: drive does not exist.
    Legare Coleman

  9. #9
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Michigan, USA
    Posts
    408
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: All Macros Stopped Working

    You are absolutely correct! When I ran them from the Tools/Macro list they worked just fine. It was the buttons that didn't work. I reassigned the macros and they now work fine!

    Thanks Andrew, Mark and Legare <img src=/S/joy.gif border=0 alt=joy width=23 height=23>.
    <font face="Comic Sans MS"><big><font color=4682b4>Sherry</font color=4682b4></big></font face=comic>

Posting Permissions

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