Updated 2015.07.31: corrected and added System32 vs SysWOW64 details.
If macros do not execute when running from the RPE Web Services or Rational DOORS Next Generation that is most likely caused by Word automation not functioning properly. If you check the RPE/RDNG log files you may observe error an entry like this one: Error loading document. Error: 424 – Object required
A solution that worked for us in many cases is to create a “Desktop” folder under C:\Windows\System32\config\systemprofile or C:\Windows\SysWOW64\config\systemprofile. Create the folder, restart the application server and verify if the problem is resolved.
What folder to use
- for 32 bit Windows it’s only C:\Windows\System32\config\systemprofile
- for 64 bit Windows
- if Word is 64 bit you need to use C:\Windows\System32\config\systemprofile
- if Word is 32 bit you need to use C:\Windows\SysWOW64\config\systemprofile
Please note that Microsoft does not officially support Word automation from NT Services so there is no guarantee that this solution will always work.
More information is available in the RPE Infocenter here: http://www-01.ibm.com/support/knowledgecenter/SS6RHZ_1.2.0/com.ibm.rational.pe.troubleshooting.doc/topics/t_macro_execution.html
NOTE: if you type C:\Windows\SysWOW64\config\systemprofile or C:\Windows\System32\config\systemprofile in the Windows Explorer address bar you might receive an error from Windows that the path does not exist. You need to start the navigation from the System32/SysWOW64 folder and confirm your administrator access when prompted.