Test for document recovery pane visibility

**blackworx** · 08-08-2012, 07:09 AM

Hi all,

I am trying to figure out if there is a way to detect the presence of the special "Document Recovery" pane which appears at the left when Excel recovers from a crash.

For the normal task pane I can test for Application.CommandBars("Task Pane").Visible = TRUE but I can't seem to find a way of detecting the document recovery one.

Any ideas?

I suppose one way to do this would be to force a crash/recover then run a macro to enumerate all the visible controls/toolbars, but so far I have had no success in actually getting Excel to crash!

The reason I want to be able to detect this is for my current project which always runs from a temporary local copy on the user's C: drive which I don't want resurrected in the event of a crash.

All help/ideas gratefully accepted.

Cheers,
Bruce

**romperstomper** · 08-08-2012, 07:17 AM

For example:

Please Login or Register  to view this content.

PS You can just terminate the excel.exe process from task manager to get to it!

**blackworx** · 08-08-2012, 08:04 AM

Fantastic thanks romperstomper. And why didn't I think of just terminating the process - trying too hard, derp!

I did actually hit on the .CommandBars("Document Recovery").Visible property first time round, but since it was erroring (with Excel in a non-recovery state) as opposed to returning FALSE, I stupidly assumed I either had the name wrong, or it wasn't a member of the app.CommandBars() collection. I should know by now not to make such daft assumptions.