Recently I have upgraded MS Office from 2007 to 2010. As I work on some BI projects, part of mine set of oracle programs is oracle BI Publisher Desktop, which use Word as report template designer. When I run BI Publisher macros in Word 2010 I got following error:
The macro cannot be found or has been disabled because of your macro security settings
The solution
The solution shown here really works (tested on several computers), so I'm writing this down to be more like documentation for future reference to anyone stack on this case. Idea is to remove old
*.EXD files from any location in %USERPROFILE% folders that might exists.
Because mine praxis is to have separate %USERPROFILE% folder location then where are OS files (different then partition then C:), exd file was found as shown. In mine case it was only in one folder:
D:\Users\Sandip\Application Data\Microsoft\Forms>dir |
Volume in drive D is Data |
Volume Serial Number is 505E-794F |
Directory of D:\Users\Sandip\Application Data\Microsoft\Forms |
01.02.2011 11:45 <DIR> .. |
12.03.2009 15:17 165.808 MSComctlLib.exd |
31.08.2010 10:34 11.776 WINPROJ.box |
01.02.2011 11:19 7.168 WINWORD.box |
2 Dir(s) 51.699.859.456 bytes free |
D:\Users\Sandip\Application Data\Microsoft\Forms> |
So all you have to do is:
- Rename existing "MSComctlLib.exd" file to "MSComctlLib.exd_bak"
- Install BI Publisher again.
It should work....
Cherrrrrrrssssssssss...
Reference :-
http://damir-vadas.blogspot.com/2011/02/macro-cannot-be-found-or-has-been.html?showComment=1303225868321#c4865170160256515104
This solution is different from the others because they don't tell you to install BI Publisher desktop again. That step made the difference for me.
ReplyDeleteThanks a lot for the solution... it fixed the issue as you said...
ReplyDeleteThank You for ur comments Jim and Kamlakar!!!
ReplyDeleteIt doesn' work for me I am still getting the same message
ReplyDeleteThe macro cannot be found or has been disabled becaus of you Macro security setting