I don't believe VBA saves your code as text. It's "tokenized", which explains the "garbage" that
are the binary codes for various operators, functions, etc. The legible text probably is your
procedure names and quoted text, etc.

On Mon, 08 Sep 2003 04:19:07 GMT, "Bruce Cooley" wrote:

I saw this go by on the PowerPoint newsgroup recently:

"John O wrote:
'Next time someone runs across a corrupted Ppt doc try this tool.
In Word, do File - Open and choose file type "recover text from
any document". This pulls out the text off slides, from speaker
notes, from everywhere. It won't be clean, but if you need this...'
I just tried it on some oddball files and it works really well.
Gotta give credit to Woody for the tip."

I tried this with a short bit of Excel VBA code, and I did see it in there,
sort of, all choppy and mixed with garbage, barely decipherable, but it
might work differently with different files, and you might just get enough
to remember what you did. Let us know.

Bruce Cooley


"Dave" wrote in message
.au...
: I've just had a file corrupt with a decent chunk of code inside. I've
tried
: Excel Recovery but it doesn't recover VBA
:
: Is there any way to extract the code?
:
: Thanks
:
: Dave
:
: