Hi febausa,
While I am sorry for the loss and work, I'm not sure what your request of us is? Can you just close the file and open the previously saved file? Do you have a back-up copy, either on a normal back-up, or if you have enabled XL to create backups?
What did the macro do? Is the file corrupted, or info is simply missing?