I also created an Excel spreadsheet that uses macros to create the RS-232 code needed for the IR232. I did this as an attempt to reduce typing errors and to keep as a cross reference for the Sony buttons and matching them to Panasonic RS-232 commands. It was a huge help when manually programming/learning the Sony IR codes using the Harmony software.
Simply type in the Sony Key Code, corresponding Sony Remote Button, Panasonic RS-232 Command and SubCommand (if required), the spreadsheet will generate the IR232 code in the Final column. Just copy and paste and it's done.
The green fields in the Panasonic Control Contents are items that I have already programmed into the Harmony Remote. The color helps me know which items I still need to "teach" the Harmony.
I totally want to get all of the Panasonic 7000U picture modes programmed, but even though my Sony remote has more buttons, I haven't been unable to find the Sony code that these buttons generate. Anybody have a really good source for more Sony remote codes? I have this remote and I'd like to be able to use the Prev, Replay, Advance, Next, Play, Pause, Stop, Favorites, Input, Return, Home, & Options buttons:
RS232_Remote_Codes.zip 10.302734375k . file