Click to See Complete Forum and Search --> : HELP - Recovering VBA


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

Kyle Burns
February 16th, 2000, 07:29 AM
I've never heard of a tool that can do this. If you have a two day old backup and your code hasn't changed significantly within those two days, you could always copy and paste the code from your backup. No typing required!