ActiveX component can't create object:'Excel.Application'

[rajan_burad]

Hello Experts,

I'm trying to create excel as a target using vbscript. I created the vbscript and tried to execute that using exec() in BODS but it throws following error:

50085000PRINTFN10/30/2017 6:55:13 AMZ:\Rajan\Dynamic_Excel\rb.vbs(5, 1) Microsoft VBScript runtime error: ActiveX component can't create object: 'Excel.Application'

Any suggestion on how can I resolve this error?

Thanks in advance.