Is there a way to disable the compiler in Excel prior to opening a file?
I was in the middle of copying and modifying an existing macro when I
had to save the work so that I can do something else here at work.
Unfortunately, when I saved it, I had two macros with the same name.

Now, when I try to open this file, Excel bombs out on me. The auto
recovery files are no good because when I click on an old version, it
gives me a repaired file, but it was repaired by deleting all of my
code!

Somebody, please help.


--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=547255

Hold the SHIFT key down when you open the file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"gonger"
wrote in message
...

Is there a way to disable the compiler in Excel prior to
opening a file?
I was in the middle of copying and modifying an existing macro
when I
had to save the work so that I can do something else here at
work.
Unfortunately, when I saved it, I had two macros with the same
name.

Now, when I try to open this file, Excel bombs out on me. The
auto
recovery files are no good because when I click on an old
version, it
gives me a repaired file, but it was repaired by deleting all
of my
code!

Somebody, please help.


--
gonger
------------------------------------------------------------------------
gonger's Profile:
http://www.excelforum.com/member.php...o&userid=34797
View this thread:
http://www.excelforum.com/showthread...hreadid=547255

I already tried that and it's still hung up. Any other suggestions ..
I'll try anything

--
gonge
-----------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...fo&userid=3479
View this thread: http://www.excelforum.com/showthread.php?threadid=54725

I think you got hit by a coincidence. I saved a workbook with two procedures in
the same module that had the same name.

I could open the file with no problem. Excel did yell at me, but excel didn't
bomb out on me.

Lots of people have praised OpenOffice.org for saving their data and code.
http://www.openoffice.org, a 60-104 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)

gonger wrote:

Is there a way to disable the compiler in Excel prior to opening a file?
I was in the middle of copying and modifying an existing macro when I
had to save the work so that I can do something else here at work.
Unfortunately, when I saved it, I had two macros with the same name.

Now, when I try to open this file, Excel bombs out on me. The auto
recovery files are no good because when I click on an old version, it
gives me a repaired file, but it was repaired by deleting all of my
code!

Somebody, please help.

--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=547255

--

Dave Peterson

Dave,

You're a lifesaver! I downloaded the app from OpenOffice and was able
to retrieve my code.

Great job and thanks again!


--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=547255

Thanks for posting back. And glad your work was saved.

gonger wrote:

Dave,

You're a lifesaver! I downloaded the app from OpenOffice and was able
to retrieve my code.

Great job and thanks again!

--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=547255

--

Dave Peterson