View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rleavitt@smithgroupre.com is offline
external usenet poster
 
Posts: 12
Default Access VBA outside of Excel

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