February 16th, 2000, 07:25 AM
Hi,
Does anyone know of a tool that can pull the VBA out of Excel '97 spreadsheets that won't load as Excel thinks they are corrupt.
I know the data looks OK as I can get that out with another tool - e.g. Lotus' file viewer. But I can't find anything to scrape the code out. I really don't want to go back to a two day old backup and retype the VBA !!
Regards, Mike
Does anyone know of a tool that can pull the VBA out of Excel '97 spreadsheets that won't load as Excel thinks they are corrupt.
I know the data looks OK as I can get that out with another tool - e.g. Lotus' file viewer. But I can't find anything to scrape the code out. I really don't want to go back to a two day old backup and retype the VBA !!
Regards, Mike