Open Datastream add-in through VBS script

Question

Question by neil1 · Aug 09, 2019 at 06:15 AM · datastream excel vba add-in vbscript

Open Datastream add-in through VBS script

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!

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-08-09T21:16:56Z

REFINITIV

Best Answer

Answer by Alex Putkov. · Aug 09, 2019 at 09:16 PM

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

1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Open Datastream add-in through VBS script

1 Reply

Watch this question

Related Questions