If it's still possible to open the file, copy past tab by tab the content to a new file and save it under a different name.
If the file doesn't want to open, you can still try to link to the file from within an other excel file
Third possibility is to open the file as a database via ado and access the data tab by tab