Excel was unable to open the file by repairing or removing the unreadable content

Hi
See how to troubleshoot to open files.XLSM with VBA Macros.
When you go to open the file, you receive the following error message:




"Excel was unable to open the file by repairing or removing the unreadable content.
Part Removed: part of/xl/VbaProject.bin. (Visual Basic for Applications (VBA)) "


Follow the step by step to solve this problem:

1. open Excel 2007.
2. click on the Office Button in the upper-left corner of the screen.
3. Access the "Excel Options", where he opened an advanced settings screen.
4. Select the option "add-ins", then select the option "VBA-analysis tool" that was to disabled and click the button "Go" at the end of the screen.
5. in the "add-ins", enable the feature "VBA-" analysis tool, click on the "OK" button and confirm the information that the feature was not installed and would like it to be made the installation by clicking "YES".

6. supplement "analysis tool-VBA" installed and enabled in Excel.

Comentários

LEIA-ME

Criar ferramentas e scripts que facilitam seu trabalho no dia a dia, solucionar problemas, documentar tudo e criar o passo a passo de como resolver, é uma tarefa que requer tempo e disposição. Por esse motivo, precisamos de sua contribuição.




Apesar de não ser obrigatória, a sua doação é muito importante para continuarmos criando ferramentas, scripts e procedimentos!
Com sua contribuição manteremos o funcionamento e desenvolvimento dessas e outras soluções.