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!
