Forum Discussion

Diego_Benner's avatar
Diego_Benner
Copper Contributor
Nov 14, 2019

Excel app is removing the vbaProject

Hello guys,

 

I've created some files in excel (.xlsm) in different companies, but when I try to open the files in my PC the excel removes all the macros and try to recover my files.
At my company, I use office 365 as I use at home.

 

I receive the following messages:

 

-We found a problem with some content in "xxxxx.xlsm". Do you want us to try to recover as much as we can? ...

- Removed Part: /xl/vbaProject.bin part.  (Visual Basic for Applications (VBA))

 

Is there someone who can help me with this thing?

Thanks

excel
Macros and VBA
office 365

3 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 14, 2019
    I would suggest to have your Office setup do an online repair.
    • Diego_Benner's avatar
      Diego_Benner
      Copper Contributor
      Nov 15, 2019
      Me and the microsoft support tried to do that and it didn't work 😞
      Thanks buddy
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Nov 15, 2019
        If there is a system on which you can successfully open these files, make sure you run VBA Code Cleaner by Rob Bovey on them and save them. Then try opening them on the other systems, see if it helps. If you like I can have a look at one of the files as well?

Resources