Recovery msg appear when open xls file full of vba codes

--------------------------------------------------------------------------------

Hello
Deep real problem

I wrote a complex vba project, when i click this file to open the exce
application, it gives me recovery message and send report......... whe
i do so then all the written codes(private and models) deleted......an
i end up with nothing .......

however, all other xls files with thier vba projects, can be opene
safly without losing any vba code............

any idea why

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=26489

Sounds like something is corrupt. Try holding down shift while opening the
file in question. If it opens, the macros will be disabled but you may be
able to get access to the vb project. Export all the modules and forms,
start a new workbook, import all the modules and forms. compile. save with a
new name.

It just might work. Good luck,

Robin Hammond
www.enhanceddatasystems.com

"helmekki" wrote in message
...

Recovery msg appear when open xls file full of vba codes

--------------------------------------------------------------------------
------

Hello
Deep real problem

I wrote a complex vba project, when i click this file to open the excel
application, it gives me recovery message and send report......... when
i do so then all the written codes(private and models) deleted......and
i end up with nothing .......

however, all other xls files with thier vba projects, can be opened
safly without losing any vba code............

any idea why?


--
helmekki


------------------------------------------------------------------------
helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=264895