We are still using office 97 as our standard. However, due to memory leaks encountered in excel 8, we are having to use excel 10 for one specific analysis spreadsheet. This solution has been tested and works fine.
The problem is that we need to associate all spreadsheet file extensions with excel 8, this is because we have about 25,000 other spreadsheets with a lot of VB crap and macros which we don’t want to test just yet. We will code excel xp into the code of the app which will launch the sheet we need. Now, we have tried associating the files normally but whenever we try to open one, it opens in the most recent version of excel (10). Have tried both local and network installations of excel 97 with no improvement. Since we have about 3000 users at just this site, it is not possible or realistic to have end users open excel 8 and then open the sheet we need.
Thanks in advance for any help.
Rich