Hello colleagues,
This is my first post in Oracle community, that's why I would like to say HELLO to all of you.
I need your expertise.
I creating VBS macro in outlook to automate HFM refresh process (take excel attachment refresh and reply). I stuck in the part responsible for load ad-ins in Excel part. Please see below:
Set xlApp = CreateObject("excel.application")
xlApp.Visible = True
xlApp.COMAddIns("Hyperion.CommonAddin").Connect = True
xlApp.Workbooks.Open ("C:\Oracle\SmartView\bin\HsTbar.xla")
Set xlApp = xlApp.Workbooks.Open(link_to_file, UpdateLinks:=False)
Above code create Excel application, run Smartview add-ins and open the specific file. Unfortunately Smart View add-in not load successfully. 
Would you mind help me/ give some advise?
Kind Regards,
Luc