View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Access VBA outside of Excel

Did you try Microsoft Office Recovery?

Start Menu - Programs - Microsoft Office - Tools - Microsoft Office
Application Recovery.

" wrote:

I have a very large sheet (115M) that I cannot open for some reason
(Excel hangs when I try to open). I can live with out the contents of
the sheet, but would love to be able to get at the VBA that is
contained within modules within the spreadsheet. In fact, I am
desparate, Does anyone have any ideas for how to access this code
without opening the sheet?

I don't really know why the sheet won't open... but it has something
to do with changes Excel made to the sheet during autorecovery
operation.

I am using Excel 2003 in XP-Pro

Thanks,
Rick