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
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
Is his personal.xls file in a different folder now?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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.
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")
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.
ASKER
Had the user run this script and it worked a treat.
Thanks!
Thanks!