Hello,
I have worked on a file for long time using Excel 2003. I have few macros and custom functions written. I decided to use another computer to do some additional work on this file - mainly new formulas and outline, but no code writing. The file was opened as 2003 and was saved in the same fashion, was not converted to 2007 at any point.
I saved it and closed it. I then opened it on my original computer and after opening it gave me "Automation Error - Catastrophic Failure" message without an error number. Right after that it sent me to VBA screen and instead of having my file name under the Project Tree, it has "VBAproject". I click on it and can see my code and my forms, but the worksheets are not label properly plus they have this little blue icon next to them.
I tried to open the file again by clicking Disable macros, and no error was given but obviously can't do much with the file. Now the option of Enable/Disable macros is not showing at all, which is very odd! Not only on this file.
One thing I read around is about sharing and references. This file sharing options were turned off so that's not it. I then realized under VBA-Tools-References that the office 2007 is referencing different files for some of the selections, like Visual Basic For Applications, Microsoft Excel 12.0 Object Library, etc. I copied those files to the proper folders on the 2003 computer but that didn't do the trick. The problem is that with my 2003 computer I can't check these references because the file crashes on opening and it restricts me from going to that option.
Any ideas? I did quite of work on this file so redoing this is the last resort but I hope I don't have to go that route.
Thank you in advance!
I have worked on a file for long time using Excel 2003. I have few macros and custom functions written. I decided to use another computer to do some additional work on this file - mainly new formulas and outline, but no code writing. The file was opened as 2003 and was saved in the same fashion, was not converted to 2007 at any point.
I saved it and closed it. I then opened it on my original computer and after opening it gave me "Automation Error - Catastrophic Failure" message without an error number. Right after that it sent me to VBA screen and instead of having my file name under the Project Tree, it has "VBAproject". I click on it and can see my code and my forms, but the worksheets are not label properly plus they have this little blue icon next to them.
I tried to open the file again by clicking Disable macros, and no error was given but obviously can't do much with the file. Now the option of Enable/Disable macros is not showing at all, which is very odd! Not only on this file.
One thing I read around is about sharing and references. This file sharing options were turned off so that's not it. I then realized under VBA-Tools-References that the office 2007 is referencing different files for some of the selections, like Visual Basic For Applications, Microsoft Excel 12.0 Object Library, etc. I copied those files to the proper folders on the 2003 computer but that didn't do the trick. The problem is that with my 2003 computer I can't check these references because the file crashes on opening and it restricts me from going to that option.
Any ideas? I did quite of work on this file so redoing this is the last resort but I hope I don't have to go that route.
Thank you in advance!
