Forum Discussion
Excel file with VBA code - ERROR
Hello everyone,
I´ve got a problem with my excel file. There are 2 VBA codes included. Whenever I start the file by double klicking the file on the desktop, the following error occurs.
It says, that they repaired and removed the VBA code.
In fact, my macros don´t work anymore and I have no further acces to VBA.
Whenever I start a blank Excel file and then open the needed file, everything works just fine.
Anyone who have an idea about this problem?
Thanks in advance guys.
3 Replies
- Are you able to share the file in question? Please remove sensitive information first.
JKPieterse : thanks for your reply.
I´ve uploaded a Test-file with an empty macro. It doesn´t matter wheter there is a macro-code. Even if VBA is empty at all - there is always the same error. I think there might be some problems with excel or windows since I can open the excel file in the way I´ve already mentioned: Open an empty Excel file and then search for the needed file. That´s the weird stuff.
- FOund this, perhaps it gives you some pointers?
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2010/removed-part-xlvbaprojectbin-part-visual-basic-for/ef249567-269c-40bd-9e06-fc8fef66f902
and
https://stackoverflow.com/questions/5124184/how-do-i-recover-this-vba-project-excel-error-message-removed-part-xl-vbapr
