Excel app is removing the vbaProject

%3CLINGO-SUB%20id%3D%22lingo-sub-1007342%22%20slang%3D%22en-US%22%3EExcel%20app%20is%20removing%20the%20vbaProject%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007342%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20created%20some%20files%20in%20excel%20(.xlsm)%20in%20different%20companies%2C%20but%20when%20I%20try%20to%20open%20the%20files%20in%20my%20PC%20the%20excel%20removes%20all%20the%20macros%20and%20try%20to%20recover%20my%20files.%3CBR%20%2F%3EAt%20my%20company%2C%20I%20use%20office%20365%20as%20I%20use%20at%20home.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20receive%20the%20following%20messages%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-We%20found%20a%20problem%20with%20some%20content%20in%20%22xxxxx.xlsm%22.%20Do%20you%20want%20us%20to%20try%20to%20recover%20as%20much%20as%20we%20can%3F%20...%3C%2FP%3E%3CP%3E%3CFONT%3E-%20Removed%20Part%3A%20%2Fxl%2FvbaProject.bin%20part.%26nbsp%3B%20(Visual%20Basic%20for%20Applications%20(VBA))%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EIs%20there%20someone%20who%20can%20help%20me%20with%20this%20thing%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%3EThanks%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1007342%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1007762%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20app%20is%20removing%20the%20vbaProject%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1007762%22%20slang%3D%22en-US%22%3EI%20would%20suggest%20to%20have%20your%20Office%20setup%20do%20an%20online%20repair.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1010231%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20app%20is%20removing%20the%20vbaProject%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1010231%22%20slang%3D%22en-US%22%3EMe%20and%20the%20microsoft%20support%20tried%20to%20do%20that%20and%20it%20didn't%20work%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3EThanks%20buddy%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1010673%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20app%20is%20removing%20the%20vbaProject%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1010673%22%20slang%3D%22en-US%22%3EIf%20there%20is%20a%20system%20on%20which%20you%20can%20successfully%20open%20these%20files%2C%20make%20sure%20you%20run%20VBA%20Code%20Cleaner%20by%20Rob%20Bovey%20on%20them%20and%20save%20them.%20Then%20try%20opening%20them%20on%20the%20other%20systems%2C%20see%20if%20it%20helps.%20If%20you%20like%20I%20can%20have%20a%20look%20at%20one%20of%20the%20files%20as%20well%3F%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

3 Replies
Highlighted
I would suggest to have your Office setup do an online repair.
Highlighted
Me and the microsoft support tried to do that and it didn't work
Thanks buddy
Highlighted
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?