I have developped a project with excel containing 20 sheets. One of these
sheets contains an error. When I open the project, Excel says that  an error
occured in a certain sheet and stops automatically. I try to find a way to
copy the cells and the layout of the other 19 sheets in another project to
avoid to lose them definitively. Is this possible with VBA ???

Thank you for your answer(s).

Fabian (Belgium).

I can't be sure that it's gonna work, but what you can try at least, in VBA
(from any office app), is to open an excel workspace, open your file, keep
it invisible, if at that point, you don't have problem, you can copy the 19
sheets into another new file..

So to answer your question, yes, it's possible, assuming, you can open the
file in VBA..

Cheers

Fred (Belgium too)

PS: mail me, we'll discuss this issue in french, it's gonna be easier