So.. I was happily working on my macro enabled workbook in excel 2010 and I decided to finish working on the document so went to close the workbook.
It asked me If I wanted to save the file, I clicked yes, it gave me an error saying that I am using a reserved word for one of my Sub's within the code.
This sub was called "DeleteRecord", the only option was Ok or Help and was vbCritical. I clicked ok as I saw this as the only option and now I am unable to open the file at all. I have tried the following:
- Excel's Safe Mode (by holding ctrl when opening the file),
- Stopping Macro's from running on start (by holding shift when opening the file),
- Both of the above combined.
Now I don't have a previous version of this file and I am not an admin on the server so have barely enough rights on the system to perform basic tasks (for example I'm unable to access command prompt, run or even the task manager.
Is there some way of recovering this file or even simply accessing the code of the document without opening it? If not is there any way to access any of the code from outside the program?
Any help is greatly appreciated.
-JC
It asked me If I wanted to save the file, I clicked yes, it gave me an error saying that I am using a reserved word for one of my Sub's within the code.
This sub was called "DeleteRecord", the only option was Ok or Help and was vbCritical. I clicked ok as I saw this as the only option and now I am unable to open the file at all. I have tried the following:
- Excel's Safe Mode (by holding ctrl when opening the file),
- Stopping Macro's from running on start (by holding shift when opening the file),
- Both of the above combined.
Now I don't have a previous version of this file and I am not an admin on the server so have barely enough rights on the system to perform basic tasks (for example I'm unable to access command prompt, run or even the task manager.
Is there some way of recovering this file or even simply accessing the code of the document without opening it? If not is there any way to access any of the code from outside the program?
Any help is greatly appreciated.
-JC
