Open Datastream add-in through VBS script

neil1

Hi

I have a vbs script scheduled to open anexcel workbook, refresh my data from Eikon, update some charts and send the charts to outlook. Everything works except refreshing the data, this is because the vbs excel instance doesn't have the eikon add-in loaded. Can someone please help me figure out how to load the add-in? I've found lots of threads online but can't piece it together (I'm very to new to VBA!)

This is what I have so far:

Set objExcel = CreateObject("Excel.Application")

objExcel.Application.Run "'S:\file.xlsm'!Module1.Email_charts"

objExcel.DisplayAlerts = False
obj

Excel.Application.Quit
Set objExcel = Nothing

Many thanks!

Alex Putkov.1

See how you can load Eikon Excel COM add-in on this thread.