It can also relate to error XRL ERROR - MSSCRIPT.OCX.

When you get this error. You need to run a registry fix.
See attached
- Take a backup of the registry - open up regedit, file, export, save to c:\temp\registry. OK. Close out of regedit
- Double click on the .reg and run it.  This will apply the registry change to that pc
- Run the the registry change on each client machine that has XRL installed
- Launch Excel and login to XRL and confirm that reports can be created without encountering the VB script error
- Reboot the machine
The registry that get's updated is below.
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"Compatibility Flags"=dword:0
"ActivationFilterOverride"=dword:1
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"Compatibility Flags"=dword:0
"ActivationFilterOverride"=dword:1
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3742-5B07-11cf-A4B0-00AA004A55E8}]
"Compatibility Flags"=dword:0
"ActivationFilterOverride"=dword:1
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3742-5B07-11cf-A4B0-00AA004A55E8}]
"Compatibility Flags"=dword:0
"ActivationFilterOverride"=dword:1

If the above DOES NOT WORK and this is a TERMINAL SERVER XRL install and you have ticked the 'Application User Profiles' option in the XRL\MAINTENANCE\ABOUT screen: 
robocopy "%appdata%\infor query and analysis" "c:\Users\%username%\appdata\roaming\infor query and analysis" /e