Page 1 of 2 12 LastLast
Results 1 to 10 of 16

HELP - Macros are not running on ......

This is a discussion on HELP - Macros are not running on ...... within the Excel Questions forums, part of the Question Forums category; I just finished installing Excel 2000 on a new computer, with the same "Personal.xls" I copied from my old system. ...

  1. #1
    New Member
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    49

    Default HELP - Macros are not running on ......

    I just finished installing Excel 2000 on a new computer, with the same "Personal.xls" I copied from my old system.
    Now, when I run my old macros on the new machine, I receive this message:

    "A document with the name of "Personal.xls" is already open. You cannot open two documents with the same name, even if documents are in different folders........",

    and I cannot run the macros.
    How to solve this problem?
    Any help will be appreciated.
    Cheers

  2. #2
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,585

    Default Re: HELP - Macros are not running on ......

    Hi amflores,

    I think that's because Excel automatically creates the Personal.xls file once you first record a macro to it, and it is always opened with Excel, so you're trying to open two of the same thing. Try renaming the personal.xls you backed up, open it up, and then cut and paste the code into the personal.xls module that Excel automatically created. Do this through the vb editor.

    Hope this helps,
    Corticus
    Corticorp, LLC
    -Development Solutions for .NET, Java, PHP, HTML5, iPad/iPhone, Android and many more
    -Database Development for SQL Server, MySQL, Oracle and others
    http://www.corticorp.com

  3. #3
    Board Regular
    Join Date
    Aug 2003
    Location
    Maidstone, Kent UK
    Posts
    1,470

    Default

    It looks as if you put your copy in the wrong location. Search for Personal.xls to find where Excel is putting its original and replace that with your copy.

    HTH

    Peter

  4. #4
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,585

    Default

    Quote Originally Posted by bat17
    It looks as if you put your copy in the wrong location. Search for Personal.xls to find where Excel is putting its original and replace that with your copy.

    HTH

    Peter
    It should be noted that this would overwrite any macros in your new personal.xls file. You might not want to do that.

    The personal.xls file is located here, in Office2000 on WinXP:
    C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART\personal.xls
    You will need to replace UserName with your user name.

    This file does not exist until you first record a macro to it, which is why I suspect you might not want to write over it.

    This file is always opened with Excel.

    -Corticus
    Corticorp, LLC
    -Development Solutions for .NET, Java, PHP, HTML5, iPad/iPhone, Android and many more
    -Database Development for SQL Server, MySQL, Oracle and others
    http://www.corticorp.com

  5. #5
    New Member
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    49

    Default Re: HELP - Macros are not running on ......

    Hello Corticus,

    I think I simply replaced the newly created/untouched Personal.xls with a copy of the old one.

    It was placed here:
    C:\Documents and Settings\MyUserName\Application Data\Microsoft\Excel\XLSTART\personal.xls

    It doesn't work.


    Try renaming the personal.xls you backed up, open it up, and then cut and paste the code into the personal.xls module that Excel automatically created. Do this through the vb editor. I am not familiar with the VB Editor. I am afraid to use it. Sorry.

    What do I do?

  6. #6
    New Member
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    49

    Default

    Hello Corticus


    1 - It should be noted that this would overwrite any macros in your new personal.xls file. You might not want to do that.
    I agree. I did not write any macro to the new personal.xls file.
    I simply replaced it w/a copy of the old one, right after install.


    2 - The personal.xls file is located here, in Office2000 on WinXP:
    C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART\personal.xls
    That's where the copy was placed. Found no other personal.xls.

    You will need to replace UserName with your user name. Sure

    Still doesn't work.
    I keep getting that same message when I try to use my old macros.

    Cheers

  7. #7
    Board Regular
    Join Date
    Aug 2003
    Location
    Maidstone, Kent UK
    Posts
    1,470

    Default

    did you try the search to see where the two copies are that are trying to load?

    Peter

  8. #8
    New Member
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    49

    Default

    Hello Peter,


    1 - Did you try the search to see where the two copies are that are trying to load?
    Yes. I have (2) partitions on my HD. (C:>) for the system and programs. The other ( E:>), for documents, data, etc..
    Yes, I have a 2nd HD with 2 partitions used mostly for bkups.
    The search found:
    C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART\personal.xls
    C:\Documents and Settings\UserName\Application Data\Microsoft\Office\Recent\personal.xls.LNK
    The first, I believe is a copy of my old one: I can open/edit (but not run) all of my old macros.


    Regards,

  9. #9
    Board Regular
    Join Date
    Aug 2003
    Location
    Maidstone, Kent UK
    Posts
    1,470

    Default

    "Recent\personal.xls.LNK" is just a shortcut to the main file. I think we have another problem here. Are you running these macros from a toolbar? I suspect that there may be a difference in path between your old instalation and this new one.


    Peter

  10. #10
    Board Regular Corticus's Avatar
    Join Date
    Apr 2002
    Location
    Sarasota, FL
    Posts
    1,585

    Default Re: HELP - Macros are not running on ......

    First, open the renamed personal.xls you backed up,

    To open the VB editor, hit Alt+F11 once in Excel. Now hit Ctrl+R, this will bring up the project explorer. On the left you should see two folders, one called personal.xls, and one called whatever you renamed the old personal.xls file. Double click on the old personal.xls file, copy everything out of the module that pops up. Then open the new personal.xls moule and paste everything in you copied.

    Hope this helps,
    Corticus
    Corticorp, LLC
    -Development Solutions for .NET, Java, PHP, HTML5, iPad/iPhone, Android and many more
    -Database Development for SQL Server, MySQL, Oracle and others
    http://www.corticorp.com

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com