Link to home
Start Free TrialLog in
Avatar of Vai777
Vai777

asked on

Excel 2000 > 2003 bulk macro editing tool.

I have just migrated a user from Office 2000 to 2003. This user is a heavy macro user and after the upgrade it was discovered his macro's stopped working.
All the menu's are there as I copied over his personal.xls and excel.xlb files over.

The error refers to it not finding the file specified. See attached screenshot (error.jpg).
However if you modify the macro and strip out the full path C:\Program Files\Microsoft Office\Office\XLStart and just leave personal.xls in the file path field it then works.

This is a bit of a nightmare as there lots of these macros. Is there a way to bulk edit and strip out the file path to the personal.xls location in the assign macro window?
error.jpg
Assign-macro.jpg
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Is his personal.xls file in a different folder now?
ASKER CERTIFIED SOLUTION
Avatar of BrainB
BrainB
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check
C:\Program Files\Microsoft Office\Office10\XLStart
and see if personal.xls is there too

I'm guessing it created a new personal.xls file when you installed the new version but all his macros are in the old one.

Make sure the personal.xls file with all his macros is in the location the error is looking for.
C:\Program Files\Microsoft Office\Office\XLStart
Avatar of Vai777
Vai777

ASKER

His personal.xls file is in both XLStart locations:
C:\Program Files\Microsoft Office\Office10\XLStart

and

C:\Program Files\Microsoft Office\Office\XLStart

It's in the right location as it's loading up his custom menu's. It just seems like 2003 doesn't require the whole path name.

I might pass the above code to the person and see what he thinks as he can make more sense with what it's doing than me.
Have you checked Tools\Options\General ... something like "At startup open all files in .." (was "alternative startup location")
Avatar of Vai777

ASKER

But surely if the macro's are stored in the personal.xls and that's in the right location that should be enough?
Yes, it should assuming that macro is actually in the file.
Avatar of Vai777

ASKER

Had the user run this script and it worked a treat.

Thanks!