View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SIGE SIGE is offline
external usenet poster
 
Posts: 206
Default Move sheets To New Wbk - recover workbook

Hi There,

I am deadline working ...
and with creating Charts (all embedded) in a workbook all day (saved
it regularly!), I closed the file in the end but now on re-opening
excel (97Sr2) it generates an error.
(application error: excel.exe has generated errors and will be closed
by windows)

(
There is NO VBA-code inside: besides this empty sub in one of the
worksheets

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
End Sub
)

The only way is maybe just exporting the sheets? -taking into account
that i cannot open the file...

-Can someone provide me a snippet to export all sheets from a closed
workbook to a new workbook?



Help seriously appreciated,
Sige