My pleasure - Hope it works out OK. You will use OpenOffice.calc to open the workbook, and when
it gets there, use Tools / Macro to open the Macro window. Click on any module name in your file
and hit Edit, and you should then have a horizontal row of tabs showing you all the modules in the
book (Same as Excel's tabbed worksheets)

The code may well all be Rem'd out, but you can fix that with an Edit / Replace right where you
are in .calc, or once you get it back into Excel.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Dave" wrote in message
. au...
Downloading - thanks for tip Ken


"Ken Wright" wrote in message
...
Have you tried doing so with OpenOffice (Free 60MB download from
www.openoffice.org)

If that's too big a download then by all means fire it on down to me and
I'll give it a go for
you.

You need to take the NOSPAM bit out of my email address

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------------------------
--
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------------------------
--



"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