Everytime I try to open my Excel project I get an
hourglass then 'Microsoft Excel has encountered a problem and needs to
close. We are sorry for the inconvenience.'

It attempts 'Document Recovery' but the cycle above just repeats.

I had just put a button onto a Form, and after right clicking to 'Show
Code' didn't get taken to the expected Private Sub ..... so I added
it manuallly.

Is there any way I can open it to see what's wrong, or get any of the
Forms, code etc rescued from it?

Thanks - Kirk

Hi,

Try to open your workbook with macro disabled.
Eventually , copy/export almacros to new workbook.
HTH
Regards
JY

"kirkm" wrote in message
...

Everytime I try to open my Excel project I get an
hourglass then 'Microsoft Excel has encountered a problem and needs to
close. We are sorry for the inconvenience.'

It attempts 'Document Recovery' but the cycle above just repeats.

I had just put a button onto a Form, and after right clicking to 'Show
Code' didn't get taken to the expected Private Sub ..... so I added
it manuallly.

Is there any way I can open it to see what's wrong, or get any of the
Forms, code etc rescued from it?

Thanks - Kirk

I had the same problem yesterday. I finally just went into Windows Explorer,
copied the file and pasted, then changed the extension to the pasted copy to
..csv.

I was able to open the .csv version without problem, and did a "saveas"
with the .xls extension. Then I was able to deal with any lost links and
macros.
--
Best wishes,

Jim


"kirkm" wrote:


Everytime I try to open my Excel project I get an
hourglass then 'Microsoft Excel has encountered a problem and needs to
close. We are sorry for the inconvenience.'

It attempts 'Document Recovery' but the cycle above just repeats.

I had just put a button onto a Form, and after right clicking to 'Show
Code' didn't get taken to the expected Private Sub ..... so I added
it manuallly.

Is there any way I can open it to see what's wrong, or get any of the
Forms, code etc rescued from it?

Thanks - Kirk

Thanks Guys.
That change to .csv is a goodie... must remember.
I couldn't get it open without macros, so used a backup
and just had to redo a bit of stuff.
Could've been worse !

Cheers - Kirk