Under Microsoft Excel Objects is a sheet called ThisWorkbook. It has some
code that will not work under Office 2007 and I need to update over 500
spreadsheets. Is there an automated way to update this by a macro I have
open or do I have to open every workbook , open the VB menue and update?

Never updated the code automaticly