View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ion Chalmers Freeman Ion Chalmers Freeman is offline
external usenet poster
 
Posts: 1
Default Reclaiming VBA Code in a corrupted file

Well, thank you, J.E. McGimpsey!
I badly corrupted an excel file attempting to set a chart's series'
values to a dynamic array. I couldn't open in in Excel 2000, in which
I'd created it, or in Excel XP, which I have on another computer.
The sneaky opening via automation in word and exporting through the
VBE object worked about as well as I expected.
I despaired!
But, I read your posting, downloaded and installed OpenOffice, opened
my file in OpenCalc and reclaimed my code. That's quite a relief.