Excel VBA "Automation Error" and "Object library Invalid Error" In VBA Programming. A Simple Solution.

Are you using Excel VBA for some programming. And You started getting Automation Error in Excel?? or object library invalid error.Don't worry here is a simple solution. this problem is because of *.exd files. You can delete them using the following simple steps and your Excel works fine all again.

Please follow the steps to resolve the issue.

These files should be located in the folder: %APPDATA%\Microsoft\Forms\

On Windows XP, it is usually located in:

C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Forms\

And on Windows Vista/7:

C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\

Then open your Excel and try for the Macro Now.

Note: Close all Opened Excels before following these steps.