Porting key commands from Excel v.X to 2004

[RockyRoad]

When I upgraded to Office 2004, my custom Word key commands came across
but they didn't for Excel. Can anyone tell me how to get them across or
what v.X template ro pref file the commands are stored in?

Thank you.

 

[JE McGimpsey]

When I upgraded to Office 2004, my custom Word key commands came across
but they didn't for Excel. Can anyone tell me how to get them across or
what v.X template ro pref file the commands are stored in?

Unfortunately, I don't know of any easy way to do this.

XLv.X stores keyboard shortcuts in the

~:Libraryreferences:Microsoft:Excel Keyboard Shortcuts

file. XL04, I would guess to be more MacOSX-like, switched over to
storing them in the

~:Libraryreferences:Microsoft:com.microsoft.Excel.prefs.plist

file. The two files aren't directly compatible.

If you open the "Excel Keyboard Shortcuts" file in a hex editor, the
tokenized shortcut is stored starting 4 bytes after the ascii characters
data (hex: 64 61 74 61).

If you open the .plist, you can see that the

Microsoft Excel\count

element keeps track of how many keyboard shortcuts there are, and the

Microsoft Excel\data

element stores the same tokenized shortcut.

So in theory, you could open your v.X shortcuts file in a hex editor,
and edit the .plist file accordingly (it's just an XML text file), but
it would probably be faster to create the shortcuts in XL04.

 

[RockyRoad]

Unfortunately, I don't know of any easy way to do this.

XLv.X stores keyboard shortcuts in the

~:Libraryreferences:Microsoft:Excel Keyboard Shortcuts

file. XL04, I would guess to be more MacOSX-like, switched over to
storing them in the

~:Libraryreferences:Microsoft:com.microsoft.Excel.prefs.plist

file. The two files aren't directly compatible.

If you open the "Excel Keyboard Shortcuts" file in a hex editor, the
tokenized shortcut is stored starting 4 bytes after the ascii characters
data (hex: 64 61 74 61).

If you open the .plist, you can see that the

Microsoft Excel\count

element keeps track of how many keyboard shortcuts there are, and the

Microsoft Excel\data

element stores the same tokenized shortcut.

So in theory, you could open your v.X shortcuts file in a hex editor,
and edit the .plist file accordingly (it's just an XML text file), but
it would probably be faster to create the shortcuts in XL04.

Thanks. Yes. looks like it will be best for me to just start again in
2004