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
|