Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Macro problems in Excel 2002

Jul 14, 2004 12:42AM PDT

My PC at work has just been upgraded from windowsNT to XP Pro, and Excel 97 to Excel 2002.

I had a lot of custom buttons, with macros attached, in my copy of Excel 97.

The two files that seem to store this were a file called personal.xls, in c:\program files\microsoft office\office\xlstart, and a file called robert8.xlb, stored in the WinNT folder on drive C.

I made copies of these files before I got my new PC

On the new version of excel, personal.xls is stored in a different path, c:\program files\microsoft office\office10\xlstart.

The problem I have is that all my custom buttons try to link to the personal.xls file via the old path, and I can't open 2 copies of this file at once.

I manually re-assigned all the buttons to macros at the new location, when I close and re-open excel, it has reverted back.

I opened personal.xls from the old path, did file/save as/ to the new path, all worked till I closed and opened excel, when every thing was as before.

How can I sort this, as it is driving me crazy?

Robert

Discussion is locked

- Collapse -
Re: Macro problems in Excel 2002
Jul 14, 2004 1:13AM PDT

Macros are VBA or visual base files. If you were to edit such, a find and replace could fix it in one pass. Best of luck.

Bob

- Collapse -
Re: Macro problems in Excel 2002
Jul 14, 2004 1:29AM PDT

Hi

I don't think the problem is with the macro, the problem is with where excel 2002 thinks the spreadsheet containing the macro is saved.

Macros are saved in the personal.xls workbook, but because I copied the file that holds all the custom toolbar settings on to my new pc, it has some how dragged in the old path, and refuses to acknowledge the new one.

Robert

- Collapse -
Another idea.
Jul 14, 2004 1:40AM PDT

Make sure that you have ownership of the file, the new paths and that no file that needs to be changed is not Read-Only. Have your IT staff work on it.

Bob